版本信息: OS linux 6.4 DB oracle11R2 GG goldengate 11
需求说明: NODE1: 192.168.0.199 dominic.mysql1
NODE2: 192.168.0.195 dominic.mysql2
NODE3: 192.168.0.171 dominic.node1
原 node1 --> 同步 node2 (DDL,DML) , 现需要增加一个节点 node3 (同步)
node1 -> node2
-> node3
一个 mgr 进程,多个extract , replicat 进程组
操作方式:
一:
添加 node3 ./GLOBALS 参数
GGSCI (target) > edit params ./GLOBALS
checkpointtable ogg.checktable
GGSCI (target) > dblogin userid ogg,password ogg
GGSCI (target)>add checkpointtable ogg.checktable
二: node1 上再添加 extract 进程(exttrail,pump)
GGSCI (dominic.mysql1) 129> view params extra_2
extract extra_2
dynamicresolution
userid ogg,password ogg
rmthost 192.168.0.171,mgrport 7809,compress
reportcount every 1 minutes,rate
exttrail /dba/ogg/dirdat/at
ddl include all
ddloptions addtrandata, report
table scott.*;
GGSCI (dominic.mysql1) 130> view params pump_2
extract pump_2
rmthost 192.168.0.171,mgrport 7809,compress
passthru
rmttrail /dba/ogg/dirdat/bt
dynamicresolution
table scott.*;
三: node1 上把新增的 extract 进程 加入mgr 里:
添加Extract 进程:
GGSCI (source) > add extract extra_2, tranlog, begin now (第二次使用alter 。。。)
添加本地trail 文件,Extract组负责写这部分文件,pump进程负责读它。
GGSCI (source) > add exttrail /dba/ogg/dirdat/at , extract extra_2
----------------------------------------------------------
添加pump 进程:
GGSCI (source) > view params pump_2
GGSCI (source) > add extract pump_2,exttrailsource /dba/ogg/dirdat/at
GGSCI(source) > add rmttrail /dba/ogg/dirdat/bt, extract pump_2 --投递到目标端对应的目录。
四: 配置node3 mgr 进程
GGSCI >view params mgr
PORT 7809
dynamicportlist 7810-7850
autostart er *
autorestart extract *,waitminutes 2, retries 5
lagreporthours 1
laginfominutes 3
lagcriticalminutes 5
purgeoldextracts /dba/ogg/bt*,usecheckpoints,minkeepdays 3
五: 启动 node1 extract 新增的进程, 同时 启动node3 mgr 进程,通过info all 查看状态信息
六: node1 通过expdp/impdp 数据备份,同时加参数值
flashback_scn
tarting "SCOTT"."SYS_EXPORT_SCHEMA_01": scott/******** directory=dump_dir dumpfile=scott.dmp flashback_scn=2631840
--flashback_scn 号来之与 node1 的 v$database current_scn column 值
七: 拷贝及回复,node3 上 disable掉 constraint 值, 在db 上修改参数:ENABLE_GOLDENGATE_REPLICATION = TRUE
八: 开启node3 replicat 进程
--node1
GGSCI (dominic.mysql1) 128> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTRA_1 00:00:00 00:00:09
EXTRACT RUNNING EXTRA_2 00:00:00 00:00:02
EXTRACT RUNNING PUMP_1 00:00:00 00:00:03
EXTRACT RUNNING PUMP_2 00:00:00 00:00:06
--node2
GGSCI (dominic.mysql2) 21> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_1 00:00:00 00:00:07
--node3
GGSCI (dominic.node1) 58> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_2 00:00:00 00:00:00