Friday , June 21 2024

ORA-19573: cannot obtain exclusive enqueue for datafile X

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.

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.

You can stop the managed recover process as follows.

The “RECOVER DATABASE NOREDO” process will then start successfully.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *