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