Oracle 常用指令 & SQL - Dataguard 篇 (Dataguard section)

Dataguard 相關

-- 檢查 dataguard 服務狀態 (MRP)

select process, status, sequence# 
from v$managed_standby;

-- 檢查目前Database的dataguard角色狀態

select open_mode, database_role, switchover_status 
from v$database;

-- 檢查Dataguard同步狀況 (Primary & Standby)

select al.thread#, max(al.sequence#) "Last Seq Recieved",
max(lh.sequence#) "Last Seq Applied"
from v$archived_log al, v$log_history lh
where al.thread#=lh.thread#
group by al.thread#;

-- 取消同步

alter database recover managed standby database cancel;

-- 開啟同步

alter database recover managed standby database disconnect from session;

-- Convert Physical Standby to Snapshot database

alter database convert to snapshot standby;

-- Stop apply off using dgmgrl (dataguard control)

$ dgmgrl /
> edit database orcl_stby state 'APPLY-OFF';

-- switchover to standby

$ dgmgrl /
> switchover to orcl_stby;