OGG 的初始化加载

源端

Extract进程

GGSCI (cdb) 7> view params ext02

extract ext02
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
userid c##goldengate, password goldengate
rmthost cdbtest, mgrport 7809
rmttask replicat, group rep02
SOURCECATALOG source
table send.t1;

开启和查看进程

GGSCI (cdb) 8> add extract ext02, sourceistable
GGSCI (cdb) 8> info extract ext02
GGSCI (cdb) 8> info all

GGSCI (cdb) 8> start extract ext02
GGSCI (cdb) 8> info extract ext02
GGSCI (cdb) 8> view report ext02
GGSCI (cdb) 8> info all

目标端

Relicate进程

GGSCI (cdbtest) 4> view params rep02

replicat rep02
ASSUMETARGETDEFS        
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
userid c##goldengate@target, password goldengate
--reperror default, discard
discardfile /opt/oracle/ogg/dirrpt/rep02.dsc, append, megabytes 20
BATCHSQL
INSERTAPPEND         
map source.send.t1, target target.send.t1;

开启和查看进程

GGSCI (cdbtest) 8> add replicat rep02, specialrun
GGSCI (cdbtest) 8> info replicat rep02
GGSCI (cdbtest) 8> info all

GGSCI (cdbtest) 8> info replicat rep02
GGSCI (cdbtest) 8> view report rep02
GGSCI (cdbtest) 8> info all

源端开启ext02，目标端自动打开rep02