Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
We use the incremental backup of the primary database to fix the gap that occurs in the standby databases. If the managed recovery is turned on, errors such as ORA-19870 ORA-19573 will be received. For the recover operation, the standby database must be in mount mode and the recovery process must not have begun.
Rman error will be as follows.
1 2 3 4 5 6 | RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 03/22/2018 15:22:57 ORA-19870: error while restoring backup piece /u01/backup/ForStandby_m5sudn2g_1_1 ORA-19573: cannot obtain exclusive enqueue for datafile 12 |
For the solution, recovery in the standby database must be stopped or restarted in mount mode.
You can start it in mount mode as follows.
1 2 3 | SQL>shutdown immediate SQL>startup mount |
You can stop the managed recover process as follows.
1 | SQL> alter database recover managed standby database cancel; |
The “RECOVER DATABASE NOREDO” process will then start successfully.
