使用goldengate同步oracle

Posted on by

联系：手机(13429648788)  QQ(107644445)

链接：https://www.orasos.com/%e4%bd%bf%e7%94%a8goldengate%e5%90%8c%e6%ad%a5oracle.html

标题：使用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

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;

2 thoughts on “使用goldengate同步oracle”

  2. GGSCI (PONY) 1> add extract ext1,tranlog,begin now
    EXTRACT added.
    GGSCI (PONY) 2> edit param ext1
    extract ext1
    userid goldengate,password goldengate
    rmthost 172.17.17.61, mgrport 7809
    rmttrail d:\ggs\dirdat\r1
    dynamicresolution
    gettruncates
    table sajet.*;

    GGSCI (PONY) 3> add rmttrail d:\ggs\dirdat\r1 extract ext1

    请问怎样只添加一个extratct与本文中添加两个不同的extract有什么不同，作用是什么，望解答，谢谢

Comments are closed.