Switchover from Primary to Physical Standby Database

#########Switchover to Physical Standby Database#########

–In Primary–

SELECT database_role FROM v$database;
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
or
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN WAIT;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
or
startup nomount
alter database mount standby database;
SELECT database_role FROM v$database;

–In Standby–

select SWITCHOVER_STATUS from v$database; —switchover status should show “SWITCHOVER PENDING”
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
SHUTDOWN IMMEDIATE;
STARTUP;

–In New Standby–

alter database recover managed standby database disconnect from session;

–In New Primary–

ALTER SYSTEM SWITCH LOGFILE;

Note: If feel any issue just give me a buzz....