前提:
源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