物理dataguard主备切换对ogg(dml)同步影响测试.doc

物理DATAGUARD主备切换对OGG（DML）同步影响测试 一、环境介绍 数据库角色 DG主库 DG备库 OGG同步库（查询库） IP 10.15.59.102 10.14.156.137 10.15.34.36 操作系统版本 AIX 5.3 AIX 5.3 AIX 5.2 Oracle rdbms版本 10.2.0.4.0 10.2.0.4.0 10.2.0.4.0 OGG版本 10.2.0.19 build 002 None 10.2.0.19 build 002 xlC.rte版本 9.0.0.1 10.1.0.0 9.0.0.1 Oracle sid oratest oratest oratest Db_unique_name oratest phyoratest oratest 注：如何搭建环境在此文档中不做描述。 测试表：test.testtb SQL desc test.testtb Name Null? Type ----------------------------------------- -------- -------------------------------------- A NUMBER(38) 切换前纪录： 主库： SQL select * from test.testtb order by a; A ---------------------------- 4 6 7 8 9 10 20 100 200 500 1000 A -------------------------- 1001 1002 5000 30000 15 rows selected. OGG查询库： SQL select * from test.testtb order by a; A ------------------------- 4 6 7 8 9 10 20 100 200 500 1000 A ----------------------- 1001 1002 5000 30000 15 rows selected. 通过表中的数据比较可以看到主库与OGG查询库为同步状态。 主库后台日志： Thread 1 advanced to log sequence 48 (LGWR switch) Current log# 2 seq# 48 mem# 0: /oratest/oratest/redo02.log Wed Dec 18 13:28:54 2013 ARC1: Standby redo logfile selected for thread 1 sequence 47 for destination LOG_ARCHIVE_DEST_2 Wed Dec 18 13:40:32 2013 Thread 1 advanced to log sequence 49 (LGWR switch) Current log# 3 seq# 49 mem# 0: /oratest/oratest/redo03.log Wed Dec 18 13:40:32 2013 ARC1: Standby redo logfile selected for thread 1 sequence 48 for destination LOG_ARCHIVE_DEST_2 可以看到当前主库归档日志为48号，在线日志为49号（未归档） DG灾备库后台日志： RFS[1]: Identified database type as physical standby Tue Dec 17 23:27:20 2013 RFS LogMiner: Client disabled from further notification Tue Dec 17 23:29:51 2013 RFS[1]: Successfully opened standby