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