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.
Connect with me on: