ORA-10456 cannot open the standby database

Here we are going to discus how to solve ORA-10456: cannot open standby database media recovery session may be in progress. The ORA-10456 is Oracle Data guard error.

Note: The following error is coming at that time when you trying to open your standby database in read-only mode without stopping the archive process.

SQL> ALTER DATABASE OPEN READ ONLY;
ALTER DATABASE OPEN READ ONLY
*
ERROR at line 1:
ORA-10456: cannot open standby database; media recovery session may be in progress

ORA-10456 cannot open the standby database Solution

Step-1. Stop MRP process using following command.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY CANCEL;

Step-2. Now you can open your standby database in Read Only mode.

SQL> ALTER DATABASE OPEN READ ONLY;

Step-3. Once your database is open then start MRP process using following command to make it in sync.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

If this solution is helpful for you please write in comment box.

Read - PRCR 1086 resource ora.mgmtdb is already registered

Connect with me on:

Instagram: https://www.instagram.com/shripaldba
Linkedin: https://www.linkedin.com/in/shripal-singh
Twitter: https://twitter.com/ocptechnology
Facebook: https://www.facebook.com/ocptechnology
YouTube:https://www.youtube.com/ocptechnology