使用goldengate同步oracle

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:使用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;   
此条目发表在 GoldenGate 分类目录。将固定链接加入收藏夹。

使用goldengate同步oracle》有 2 条评论

  1. 星龙剑 说:

    请问 GoldenGate能实现同一数据库服务器,不同表空间之间的同步吗?

  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有什么不同,作用是什么,望解答,谢谢