目录
源端
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