How to Perform Manual Failover in Oracle

Oracle Database Failover Steps (Manual)

Purporse: When primary site is unavailable/crashed/lost/theft/damaged then there is no option except performing failover to standby site.

Note - Do not try on production on testing basis because once you performed below steps then primary site will not be used i.e. you can not perform switchover operations later.

Failover Steps (Manual)

STEP 1 :

alter session set tracefile_identifier='FAILOVER_STBY_<Date-Time>';

STEP 2 :

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

If above command gets failed then try below command (otherwise skip)

ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;

STEP 3 :

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

STEP 4 :

ALTER DATABASE OPEN;