ORA-19573: cannot obtain exclusive enqueue during dataguard standby restore

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.

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply