10g_dataguard_switchover
測試環境:
主庫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/,如需轉載,請註明出處,否則將追究法律責任。