在源端使用filter streq 关键字 按属性值不同过滤复制到不同的表中
源端
提取进程 chj_blob
——〉add extract chj_blob, TRANLOG, BEGIN NOW
——〉edit params chj_blob
EXTRACT CHJ_BLOB
SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
USERID goldengate, PASSWORD goldengate
RMTHOST 126.33.8.96, MGRPORT 8200
RMTTRAIL ./dirdat/BJ
TABLE sgs_chj.CHJ_DATAFILE_HIS, FILTER ( @STREQ ( TABLE_NAME, "jtt"));
RMTTRAIL ./dirdat/BL
TABLE sgs_chj.CHJ_DATAFILE_HIS, FILTER ( @STREQ ( TABLE_NAME, "fbk"));
RMTHOST 126.33.8.125, MGRPORT 7809
RMTTRAIL ./dirdat/BO
TABLE sgs_chj.CHJ_DATAFILE_HIS, FILTER ( @STREQ ( TABLE_NAME, "oth"));
——〉add RMTTRAIL ./dirdat/BL, extract CHJ_BLOB, megabytes 50
——〉add RMTTRAIL ./dirdat/BJ, extract CHJ_BLOB, megabytes 50
——〉add RMTTRAIL ./dirdat/Bo, extract CHJ_BLOB, megabytes 50
多个目标端
目标一
jtt_blob
——〉 add replicat jtt_blob, EXTTRAIL ./dirdat/bj , nodbcheckpOint
——〉Edit params jtt_blob
REPLICAT jtt_blob
SETENV (ORACLE_SID=ORCL)
USERID goldengate@orcl, PASSWORD goldengate
HANDLECOLLISIONS
ASSUMETARGETDEFS
allownoopupdates
dynamicresolution
numfiles 3000
map sgs_chj.CHJ_DATAFILE_HIS , target sgs_jtt.jtt_datafile_his;
目标二
fbk_blob
——〉 add replicat fbk_blob, EXTTRAIL ./dirdat/bL , nodbcheckpOint
——〉Edit params fbk_blob
REPLICAT fbk_blob
SETENV (ORACLE_SID=ORCL)
USERID goldengate@orcl, PASSWORD goldengate
HANDLECOLLISIONS
ASSUMETARGETDEFS
allownoopupdates
dynamicresolution
numfiles 3000
map sgs_chj.CHJ_DATAFILE_HIS , target sgs_chj.chj_datafile_his;
目标三
Oth_blob
REPLICAT Oth_blob
SETENV (ORACLE_SID=ORCL)
USERID goldengate@orcl, PASSWORD goldengate
HANDLECOLLISIONS
ASSUMETARGETDEFS
allownoopupdates
dynamicresolution
numfiles 3000
map sgs_chj.CHJ_DATAFILE_HIS , target sgs_zj_mds.oth_datafile_his;