GoldenGate系统二:快速搭建三方单向通信GoldenGate环境(三)

2014-11-24 15:12:05 · 作者: · 浏览: 2
tt.ggschkpt
Successfully created checkpoint tablescott.ggschkpt.
6、配置目标端变更投递
(1)增加replicat组
广东:
GGSCI (irms155) 5> add replicat roragd, exttrail ./dirdat/gd, checkpointtablescott.ggschkpt
REPLICAT added.
江苏:
GGSCI (irms155) 5> add replicat rorajs, exttrail ./dirdat/js, checkpointtablescott.ggschkpt
REPLICAT added.
与源端的配置保持一致。
(2)创建replicat参数文件
广东:
GGSCI (irms155) 7> edit params roragd
REPLICAT RORAGD
USERID system, PASSWORD Lu123456
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORAGD.DSC, PURGE
MAP scott.emp, TARGET scott.emp;
MAP scott.salgrade, TARGETscott.salgrade;
MAP scott.bonus, TARGET scott.bonus;
MAP scott.dept, TARGET scott.dept;
江苏:
GGSCI (irms155) 7> edit params rorajs
REPLICAT RORAJS
USERID system, PASSWORD Lu123456
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORAJS.DSC, PURGE
MAP scott.emp, TARGET scott.emp;
MAP scott.salgrade, TARGETscott.salgrade;
MAP scott.bonus, TARGET scott.bonus;
MAP scott.dept, TARGET scott.dept;
(3)启动replicat进程
广东:
GGSCI (irms155) 8> start replicatroragd
Sending START request to MANAGER ...
REPLICAT RORAGD starting
GGSCI (irms155) 9> info replicat roragd
REPLICAT RORAGD Last Started 2013-05-14 15:39 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint File ./dirdat/gd000000
First Record RBA 0
GGSCI (irms155) 10> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RORAGD 00:00:00 00:00:02
江苏:
GGSCI (irms155) 8> start replicatrorajs
Sending START request to MANAGER ...
REPLICAT RORAJS starting
GGSCI (irms155) 9> info replicat rorajs
REPLICAT RORAJS Last Started 2013-05-14 15:39 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint File ./dirdat/js000000
First Record RBA 0
GGSCI (irms155) 10> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RORAJS 00:00:00 00:00:02