The following error received in physical standby database during switch from physical standby database to primary database. ORA-16139: media
recovery required SQL> alter
database commit to switchover to primary with session shutdown;
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE; Or SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SQL> RECOVER MANAGED STANDBY DATABASE FINISH; Media recovery complete. SQL> alter database commit to
switchover to primary with session shutdown; |