Oracle GoldenGate 安装配置(二)

2015-07-16 12:09:51 · 作者: · 浏览: 7
E.CHECKPOINT.


5.2 创建同步队列
GGSCI (node2) 4> add replicat rep1, exttrail /u01/ogg/dirdat/lt, checkpointtable ogg.checkpoint
?REPLICAT added.
?GGSCI (node2) 5> edit params rep1
?replicat rep1
?ASSUMETARGETDEFS
?userid ogg,password ogg
?discardfile /u01/ogg/dirdat/rep1_discard.txt, append, megabytes 10
?DDL
?map ss.*, target rr.*;


6. 开启同步
--源端
GGSCI (node1) 14> start extract ext1
?GGSCI (nod1) 15> info all
?Program Status Group Lag Time Since Chkpt
?MANAGER RUNNING
?EXTRACT RUNNING EXT1 00:00:00 00:00:05
--目标端


GGSCI (node2) 7> start replicat rep1
?GGSCI (node2) 8> info all
?Program Status Group Lag Time Since Chkpt
?MANAGER RUNNING
?REPLICAT RUNNING REP1 00:00:00 00:00:00