Oracle技术：使用goldengate同步oracle

一、source端

add extract extl,tranlog,begin now

ADD EXTTRAIL /u01/ogg/dirdat/lr, EXTRACT EXTL

ADD TRANDATA chf.objce_t

edit params extl

extract extl

userid ogg,password xifenfei

exttrail /u01/ogg/dirdat/lr

dynamicresolution

gettruncates

table chf.objce_t;

ADD EXTRACT pump1, EXTTRAILSOURCE /u01/ogg/dirdat/lr, BEGIN now

add rmttrail /u01/ogg/dirdat/rl extract pump1

edit params pump1

extract pump1

userid ogg, password xifenfei

rmthost 192.168.1.111, mgrport 7809

rmttrail /u01/ogg/dirdat/rl

PASSTHRU

gettruncates

table chf.objce_t;

二、target端

edit params ./GLOBALS

CHECKPOINTTABLE ogg.chkpoint

dblogin userid ogg,password xifenfei

ADD CHECKPOINTTABLE ogg.chkpoint

更多精彩内容：http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

add replicat repl exttrail /u01/ogg/dirdat/rl,begin now,checkpointtable ogg.chkpoint

edit  params repl

replicat repl

userid ogg,password xifenfei

assumetargetdefs

reperror default,discard

discardfile /tmp/repsz.dsc,append,megabytes 100

gettruncates

map chf.objce_t, target chf.objce_t;

作者：51cto Oracle小混子