Oracle GoldenGate 安装配置(2)

5. 配置目标端同步队列
5.1 在目标端添加checkpoint表
[oracle@node2 ogg]$ ./ggsci
 GGSCI (node2) 1> edit params ./GLOBAL –添加下列内容
GGSCHEMA ggate
 CHECKPOINTTABLE ggate.checkpoint
 GGSCI (node2) 2> dblogin userid ogg password ogg
 Successfully logged into database.

GGSCI (node2) 3> add checkpointtable ogg.checkpoint
 Successfully created checkpoint table GGATE.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

GoldenGate单向表DML同步

Oracle GoldenGate 系列：Extract 进程的恢复原理

Oracle GoldenGate安装配置

Oracle goldengate的OGG-01004 OGG-1296错误

Oracle GoldenGate快速入门教程：基本概念和配置

搭建一个Oracle到Oracle的GoldenGate双向复制环境