Switchover Activity Issues

While Switch over the Database from Standby to Primary we will get below error

ORA-16139: media recovery required

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

ERROR at line 1:

ORA-16139: media recovery required

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

*ERROR at line 1:

ORA-16139: media recovery required

SQL> recover database until cancel;

ORA-00283: recovery session cancelled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

Solution:-

SQL> recover standby database;

Note: Here we need to provide the AUTO Command.

After completion of recovery we need to execute the below command.

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Note: here some situations after giving the recover standby database

Command the database will shutdown automatically.

Then we have start database in mount state then we need to execute the below command

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;