Oracle database failover

#################################FAIL OVER####################################


--Primary Database Crushes Due to several reason like Hardware failure.

On Standby Database:

#Stop Redo Apply:- 

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

#Finish applying all received redo data:-

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

#Verify that the target standby database is ready to become a primary database:-

SELECT SWITCHOVER_STATUS FROM V$DATABASE;

#A value of either TO PRIMARY or SESSIONS ACTIVE indicates that the standby database is ready to be switched to the primary role.

#Perform failover:

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

/* Session shutdown is optional if  switchover status returns TO_PRIMARY */

srvctl status database -d ORCL_PRODRAC2 -v


Thanks & Regards
Nikhil Kumar.