here are the switch over steps. what order we should run? Should we start on current primary first? or current standby first?
Any order is fine?
on current primary : make the current primary to standby
- Code: Select all
CONNECT / AS SYSDBA
ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY;
if above command does not work, then,
alter database commit to switchover to PHYSICAL STANDBY WITH SESSION SHUTDOWN;
Standby : make the standby to primary
- Code: Select all
SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
alter database recover managed standby database cancel;
alter database open;
alter database recover managed standby database using current logfile disconnect;