Search This Blog

2010-12-09

RMAN ORA-19573: cannot obtain sub-shared enqueue for datafile

Oracle Database Release: 9.2.0.6.0

In this version of Oracle database, there seems to be an issue when new dbf file automatic created in standby database.

RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE device type disk;

RMAN-00571: =======================================
RMAN-00569: ===== ERROR MESSAGE STACK FOLLOWS =====
RMAN-00571: =======================================
RMAN-03009: failure of backup command on ch1 channel at 12/09/2010 08:04:07
ORA-19573: cannot obtain sub-shared enqueue for datafile 95

Solution:
Restart MRP daemon

SQL> recover managed standby database cancel
Media recovery complete.
SQL> recover managed standby database disconnect
Media recovery complete.



Please use following PayPal donate if my post helped

No comments:

Blog Archive