测试环境:
主库IP:192.168.249.150
备库IP:192.168.249.200
步骤:
1、先将主库切换到备库
主库:
SQL> select switchover_status fromv$database;
SWITCHOVER_STATUS
--------------------
TO STANDBY
SQL> alter database commit to switchover to physical standby;----主库切换到备库
SQL> shutdown immediate
SQL> startup mount
2、将备库切换到主库
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
TO PRIMARY
SQL> alter database commit to switchover to primary;
SQL> alter database open;
SQL> alter system switch logfile;
将已经成为新主库的200再次切换回来成为备库
3、200上:
SQL> select switchover_status fromv$database;
SWITCHOVER_STATUS
--------------------
TO STANDBY
SQL> alter database commit to switchover to physical standby;
SQL> shutdown immediate
SQL> startup mount
SQL> alter database recover managed standby database disconnect from session;
此时200已经成为备库
4、150上:
SQL> alter database commit to switchover to primary;
SQL> alter database open;
SQL> alter system switch logfile;
此时150成为了主库,200成为了备库,已经恢复到在测试前的角色。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24500180/viewspace-723323/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24500180/viewspace-723323/