ORA-19573: cannot obtain exclusive enqueue during dataguard standby restore
Error
While restore the standby database with RMAN incremental backups, its giving below error:
RMAN-03002: failure of recover command at 16/10/2019 11:15:50
ORA-19870: error while restoring backup piece 4se32fe3_1_1
ORA-19573: cannot obtain exclusive enqueue for datafile 1432
Cause
Its failed because MRP process is not stopped. You should also stop the Dataguard broker if its configured.
Solution
1. Stop the MRP process from SQLPLUS.
SQL> alter database recover managed standby database cancel;
2. Verify the Status for MRP process.
select process,status,sequence#,thread# from gv$managed_standby where process like 'MRP%';
3. Stop the MRP process from dataguard broker service.
DGMGRL> edit database '' set STATE='APPLY-OFF' ;
4. Retry the RMAN restore process.