Oracle Dataguard HA (主備,災備)方案部署調試

標籤：

包括:

centos6.5 oracle11gR2 DataGuard安裝

dataGuard 主備switchover角色切換

資料同步測試

<一,>DG資料庫資料同步測試
1,正常啟動主庫
$sqlplus / as sysdba
sql>startup

2,啟動備庫
$sqlplus / as sysdba
sql>startup mount
sql>alter database recover managed standby database disconnect from session
sql>alter database recover managed standby database cancel
sql>alter database open read only
sql>alter database recover managed standby database using current logfile disconnect

3,在主庫上做一次日誌切換
sql>alter system switch logfile

4,在主庫上建表插入資料並在備庫查詢
sql>create table smsinfo(id integer,name char(10))
sql>insert into smsinfo values(1,‘chkRuiy‘)
sql>commit;
#如果standby模式為read-only模式下的即時redo應用模式,在主庫commit後,在備庫直接查詢即可
sql>select * from smsinfo

5,如果standby模式為redo應用模式,需做如下操作才可查詢
#測試時,需要在主庫上做一次日誌歸檔,將記錄傳送給standby庫
sql>alter system archive log current
#在備庫上取消redo應用,因為在redo應用模式下不能開啟資料庫
sql>alter database recover managed standby database cancel
sql>select * from smsinfo
測試成功!

建立user及tablespace同步測試



<二,>主備切換
select name,open_mode,database_role,protection_level,protection_mode from v$database;
1,主庫執行
sql>alter system archive log current;
sql>alter database commit to switchover to physical standby with session shutdown;
sql>shutdown immediate
sql>startup mount
主庫switchover切換到備庫狀態查看
select open_mode,switchover_status,database_role from v$database
2,備庫執行
sql>alter database commit to switchover to primary WITH SESSION SHUTDOWN;;
sql>ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
sql>alter database open
sql>alter database recover managed standby database disconnect;



DataGuard維護命令
1,standby上檢測應用率和活動
select to_char(start_time,‘dd-mon-rr hh24:mi:ss‘) start_time,item,sofar from V$recovery_progress where item in (‘Active Apply Rate‘, ‘Average Apply Rate‘,‘Redo Applied‘);
2,即時同步處理記錄查看
/ruiy/ocr/DBSoftware/app/oracle/diag/rdbms/dg1/dg/trace/alert_dg.log
3,在主庫和備庫上做切換前後的下列查詢，檢查歸檔日誌從主庫傳送到備庫的情況
SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG  ORDER BY SEQUENCE#; 

Oracle Dataguard HA (主備,災備)方案部署調試