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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.