ORA-16139: media recovery required error encountered during physical DG Master/Slave database switchover

ORA-16139: media recovery required error encountered during physical DG Master/Slave database switchover

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

*

ERROR at line 1:

ORA-16139: media recovery required

Solution:

-- If the ORA-16139: media recovery required is reported, it may be caused by the absence of logs, You can first execute

Alter database recover managed standby database disconnect from session;

Then execute the command

References:

Important configuration parameters of Oracle Data Guard

Configure Oracle 11g Data Guard based on the same host

Explore Oracle 11g elastic uard

Oracle Data Guard (RAC + DG) archive deletion policies and scripts

Role conversion for Oracle Data Guard

FAL gap in Oracle Data Guard logs

Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby