DataGuard角色切換

Step 1   Verify that the primary database can be switched to the standby role.
驗(yàn)證主庫(kù)能夠切換到備用角色。
SELECT SWITCHOVER_STATUS FROM V$DATABASE;
idle>:wq

SWITCHOVER_STATUS
---------------------
 

TO STANDBY

Step 2   Initiate the switchover on the primary database.
在主庫(kù)上面開(kāi)始切換
alter database commit to switchover to physical standby with session shutdown ;

Step 3   Shut down and then mount the former primary database.
關(guān)閉并且mount上從前的主庫(kù)。

shutdown abort;
startup mount ;

Step 4   Verify that the switchover target is ready to be switched to the primary role.
驗(yàn)證轉(zhuǎn)換目標(biāo)已經(jīng)準(zhǔn)備好轉(zhuǎn)換為主庫(kù)角色
SWITCHOVER_STATUS
--------------------
SWITCHOVER LATENT

這里查詢出來(lái)的值不為TO_PRIMARY即有點(diǎn)問(wèn)題。
執(zhí)行下一步的時(shí)候可能會(huì)出現(xiàn)問(wèn)題。

Step 5   Switch the target physical standby database role to the primary role.
轉(zhuǎn)換目標(biāo)邏輯備用庫(kù)角色為主庫(kù)角色。

sys@DEX>  ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;
 ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN
*
ERROR at line 1:
ORA-16139: media recovery required

這里提示需要介質(zhì)恢復(fù)。

sys@DEX> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.

sys@DEX> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS
--------------------
TO PRIMARY

sys@DEX> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

Database altered.

Step 6   Open the new primary database.
打開(kāi)新的主庫(kù)
sys@DEX> ALTER DATABASE OPEN;

Database altered.

Step 7 Verify the switch role .
驗(yàn)證角色轉(zhuǎn)換

主庫(kù)執(zhí)行
sys@DEX> alter system switch logfile ;

System altered.

sys@DEX> select sequence# from v$log ;

 SEQUENCE#
----------
        40
        41
        42

sys@DEX>

standby庫(kù)執(zhí)行

sys@DEX> select sequence# from v$log ;

 SEQUENCE#
----------
        40
        42
        41

sys@DEX>

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]