Google+ Followers

Pages

Thursday, September 23, 2010

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;

No comments:

Post a Comment