ORA-16139: media recovery required
The following error received in physical standby database during switch from physical standby database to primary database.
ORA-16139: media recovery required
Solution:
SQL> alter database commit to switchover to primary with session shutdown;
alter database commit to switchover to primary with session shutdown
*
ERROR at line 1:
ORA-16139: media recovery required
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
------------------------------------------------------------
NOT ALLOWED
Or
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
------------------------------------------------------------
SWITCHOVER LATENT
SQL> RECOVER MANAGED STANDBY DATABASE FINISH;
Media recovery complete.
SQL> alter database commit to switchover to primary with session shutdown;
Database altered