说明：此篇续接上一篇《使用GoldenGate在两台oracle 11g数据库间安装与DML单向同步配置》之后继续进行配置
先补充一张单向复制架构图
再上一张双向复制架构图
rac2服务器端操作
rac2：开启补充日志(上一篇中做了此操作的可忽略)
SQL>alter database add supplemental log data;
SQL>alter system switch logfile;
SQL>alter database force logging;
rac2：将测试表添加入日志
GGSCI (rac2) 1> DBLOGIN USERID ogg, PASSWORD ogg
Successfully logged into database.
GGSCI (rac2) 2> ADD TRANDATA hr.T1
Logging of supplemental redo data enabled fortable hr.T1.
rac2：配置Extract进程
GGSCI (rac2) 3> EDIT PARAMS EORA_T1
GGSCI (rac2) 4> VIEW PARAMS EORA_T1
extract eora_t1
setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
userid ogg,password ogg
tranlogoptions excludeuser ogg
exttrail ogg/dirdat/aa
TABLE hr.*;
GGSCI (rac2) 5> ADD EXTRACT EORA_T1, TRANLOG, BEGIN NOW
EXTRACT added.
GGSCI (rac2) 6> ADD EXTTRAIL ogg/dirdat/aa, EXTRACT EORA_T1, MEGABYTES 5
EXTTRAIL added.
GGSCI (rac2) 7> START EXTRACT EORA_T1
Sending START request to MANAGER ...
EXTRACT EORA_T1 starting
rac2：配置Pump进程
GGSCI (rac2) 8> EDIT PARAMS PORA_T1
GGSCI (rac2) 9> VIEW PARAMS PORA_T1
EXTRACT PORA_T1
SETENV(NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
PASSTHRU
RMTHOST 192.168.87.130, MGRPORT 7809
RMTTRAIL ogg/dirdat/pa
TABLE hr.*;
GGSCI (rac2) 10> ADD EXTRACT PORA_T1, EXTTRAILSOURCE ogg/dirdat/aa
EXTRACT added.
GGSCI (rac2) 11> ADD RMTTRAIL ogg/dirdat/pa, EXTRACT PORA_T1, MEGABYTES 5
RMTTRAIL added.
GGSCI (rac2) 12> START EXTRACT PORA_T1
Sending START request to MANAGER ...
EXTRACT PORA_T1 starting
rac2：查看进程状态
GGSCI (rac2) 13> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EORA_T1 00:00:00 00:00:07
EXTRACT RUNNING PORA_T1 00:00:00 00:00:08
REPLICAT RUNNING RORA_T1 00:00:00 00:00:00
rac1服务器端操作
rac1：配置Replicat进程
GGSCI (rac1) 1> EDIT PARAMS ./GLOBALS
GGSCI (rac1) 2> VIEW PARAMS ./GLOBALS
CHECKPOINTTABLE ogg.ggschkpt
GGSCI (rac1) 3> DBLOGIN USERID ogg, PASSWORD ogg
Successfully logged into database.
GGSCI (rac1) 4> ADD CHECKPOINTTABLE
No checkpoint table specified, using GLOBALSspecification (ogg.ggschkpt)...
Successfully created checkpoint tableOGG.GGSCHKPT.
rac1：配置Replicate进程
GGSCI (rac1) 5> EDIT PARAM RORA_T1
GGSCI (rac1) 6> VIEW PARAM RORA_T1
REPLICAT RORA_T1
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
USERID ogg, PASSWORD ogg
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ogg/dirrpt/RORA_aa.DSC, PURGE
MAP hr.t1, TARGET hr.t1;
GGSCI (rac1) 7> ADD REPLICAT RORA_T1, EXTTRAIL /ogg/dirdat/pa
REPLICAT added.
GGSCI (rac1) 8> START REPLICAT RORA_T1
Sending START request to MANAGER ...
REPLICAT RORA_T1 starting
rac1：查看进程状态
GGSCI (rac1) 9> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EORA_T1 00:00:00 00:00:08
EXTRACT RUNNING PORA_T1 00:00:00 00:00:09
REPLICAT RUNNING RORA_T1 00:00:00 00:00:13
验证DML操作双向同步
rac1： rac1→rac2，DML操作
rac2： rac2→rac1，DML操作
具体步骤参考上一篇《使用GoldenGate在两台oracle 11g数据库间安装与DML单向同步配置》
