Manual Switchover

For manual switchover

NOW ON PRIMARY DATABASE

connect sys/oracle@to_primary as sysdba

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

NOW ON STABD BY DATABASE

connect /@to_standby as sysdba

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ON previous primary

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP MOUNT;

SQL> alter database recover managed standby database disconnect

New Primary (previous stand by )

SQL> ALTER DATABASE OPEN;