一、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;