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