Switchover: convert primary database to standby
–On Primary
— Convert primary database to standby
CONNECT / AS SYSDBA
ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY;
— Shutdown primary database
SHUTDOWN IMMEDIATE;
— Mount old primary database as standby database, open and enable real-time apply
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE OPEN;ALTER DATABASE RECOVER MANAGED STANDBY DATABASE using current logfile DISCONNECT FROM SESSION;
–On Standby
— Convert standby database to primary
CONNECT / AS SYSDBA
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
— Shutdown standby database
SHUTDOWN IMMEDIATE;
— Open old standby database as primary
STARTUP;
Comments
Post a Comment