GoldenGate--多对一

前提：

  源1:192.168.0.100

  源2:192.168.0.101

  目标:192.168.0.99

 

一、配置数据源

添加ggusr用户下表的log,放到日志里 

 dblogin userid system, password oracle

 add trandata ggusr.*

 

1.增加抽取extract sd1

   add extract sd1, tranlog, begin now

 

 2.关联trail文件

  add exttrail ./dirdat/co, extract sd1, megabytes 5

 

 3.edit params sd1

   extract sd1
   userid system, password oracle
   exttrail ./dirdat/co
   table ggusr.*;  

 

 4.增加pump extract

   add extract pump1, exttrailsource ./dirdat/co, begin now

   add rmttrail ./dirdat/mm, extract pump1

   edit params pump1

    加入:

      extract pump1
      dynamicresolution
      userid system, password oracle
      rmthost 192.168.0.99, mgrport 7809, compress
      rmttrail ./dirdat/mm
      numfiles 3000
      PASSTHRU
      TABLE ggusr.*;   

 

5.源2也采用同上步骤配置

 

二、配置接受数据源

 

 6.配置检查点表

  edit params ./GLOBALS

  写入：
CHECKPOINTTABLE system.ggchk

 

dblogin userid system, password oracle

add checkpointtable system.ggchk

 

7.添加replicat

 add replicat rep1, exttrail ./dirdat/mm, checkpointtable system.ggchk

 

8.编辑rep1

 replicat rep1
userid system, password oracle
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORAKK.DSC,PURGE
MAP ggusr.* TARGET ggusr.*;

 

9.添加rep2

add replicat rep2, exttrail ./dirdat/mm, checkpointtable system.ggchk

 

10.编辑rep2

 replicat rep2
userid system, password oracle
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORAKK.DSC,PURGE
MAP ggusr.* TARGET ggusr.*;

 

三、验证

 源端

  stats extract sd1

  stats extract pump1

 

目标端

 stats replicat rep1

 stats replicat rep2