OGG源端和目标端配置

源端

Manager进程

GGSCI (cdb) 3> view params mgr

port 7809
dynamicportlist 7800-8000
autorestart extract *,retries 5,waitminutes 2,resetminutes 5

Extract进程

GGSCI (cdb) 4> view params ext01

EXTRACT ext01
SETENV (ORACLE_HOME = "/opt/oracle/products")
SETENV (ORACLE_SID = "cdb")
USERID c##goldengate, PASSWORD goldengate
LOGALLSUPCOLS
NOCOMPRESSUPDATES
DDL INCLUDE MAPPED SOURCECATALOG source
GETTRUNCATES
EXTTRAIL /opt/oracle/ogg/dirdat/ex
SOURCECATALOG source
TABLE send.*; 

GGSCI (cdb) 5> ADD EXTRACT ext01,INTEGRATED TRANLOG,BEGIN NOW
GGSCI (cdb) 5> ADD RMTTRAIL /opt/oracle/ogg/dirdat/ex, EXTRACT EXT01

Pump进程

GGSCI (cdb) 5> view params pmp01

extract pmp01
dynamicresolution
USERID c##goldengate, PASSWORD goldengate
PASSTHRU
rmthost cdbtest, mgrport 7809
rmttrail /opt/oracle/ogg/dirdat/pt
SOURCECATALOG source
TABLE send.*;

GGSCI (cdb) 8> add extract pmp01, exttrailsource /opt/oracle/ogg/dirdat/ex
GGSCI (cdb) 8> add RMTTRAIL /opt/oracle/ogg/dirdat/pt, EXTRACT PMP01

开启进程

GGSCI (cdb) 8> start mgr
GGSCI (cdb) 8> start exp01
GGSCI (cdb) 8> start pmp01

查看进程

GGSCI (cdb) 8> info all
GGSCI (cdb) 8> send pmp01,status

目标端

Manager进程

GGSCI (cdbtest) 2> view params mgr

port 7809
dynamicportlist 7800-8000
autorestart extract *, retries 5, waitminutes 2, resetminutes 5
ACCESSRULE,PROG *,IPADDR cdb,ALLOW

Checkpoint表

GGSCI (cdbtest) 16> dblogin userid c##goldengate@target, password goldengate
GGSCI (cdbtest as c##goldengate@cdbtest/TARGET) 2> add checkpointtable c##goldengate.checkpoint

Relicate进程

GGSCI (cdbtest) 3> view params rep01

replicat rep01
assumetargetdefs
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
userid c##goldengate@target, password goldengate
discardfile /opt/oracle/ogg/dirrpt/rep01.dsc, append, megabytes 20
dynamicresolution
ddloptions report 
ddlerror default ignore retryop maxretries 3 retrydelay 5
reperror default, discard
map source.send.*, target target.send.*;

GGSCI (cdbtest as c##goldengate@cdbtest/TARGET) 2> add replicat rep01, exttrail/opt/oracle/ogg/dirdat/pt, checkpointtable gg_user.checkpoint

开启进程

GGSCI (cdbtest as c##goldengate@cdbtest/TARGET) 2> start mgr
GGSCI (cdbtest as c##goldengate@cdbtest/TARGET) 2> start rep01

查看进程

GGSCI (cdbtest as c##goldengate@cdbtest/TARGET) 2> info all