Oracle技术之使用goldengate同步oracle

kinght2008

　　一、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
　　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;
　　oracle视频教程请关注:http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html