SOURCE
mgr
PORT 7839
DYNAMICPORTLIST 7840-7914
USERID goldengate, PASSWORD goldengate
--AUTOSTART EXTRACT *
AUTORESTART EXTRACT *,RETRIES 3,WAITMINUTES 5,RESETMINUTES 10
PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 1
PURGEDDLHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
extract
EXTRACT exta
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID goldengate, PASSWORD goldengate
cachemgr cachedirectory ./dirtmp 20480MB, CacheDirectory /arch
-----DDL Include Mapped
--DDL INCLUDE OBJNAME "ZWC.*" EXCLUDE INSTR 'CREATE TRIGGER'
--DDLOPTIONS ADDTRANDATA NOCROSSRENAME REPORT
--TRANLOGOPTIONS RAWDEVICEOFFSET 0
REPORTCOUNT EVERY 1 MINUTES, RATE
DISCARDFILE ./dirrpt/exta.dsc,APPEND,MEGABYTES 1024
DBOPTIONS ALLOWUNUSEDCOLUMN
WARNLONGTRANS 5h,CHECKINTERVAL 30m
EXTTRAIL ./dirdat/ea
FETCHOPTIONS NOUSESNAPSHOT
tranlogoptions altarchivelogdest instance zwc /arch
TranLogOptions ExcludeUser goldengate
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS _INFINITYTOZERO
--TranlogOptions ASMUser sys@zwc_asm , asmpassword oraclepwd
TRANLOGOPTIONS CONVERTUCS2CLOBS
--exclude report --------
TABLEEXCLUDE ZWC.TB1;
table ZWC.*;
mgr
PORT 7839
DYNAMICPORTLIST 7840-7914
USERID goldengate, PASSWORD goldengate
--AUTOSTART REPLICAT *
AUTORESTART REPLICAT *, RETRIES 5, WAITMINUTES 3
PURGEOLDEXTRACTS ./dirdat/*,USECHECKPOINTS, MINKEEPDAYS 10
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
REPLICAT
REPLICAT repa
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
setenv (ORACLE_SID="zwc")
USERID goldengate, PASSWORD goldengate
--DDLOPTIONS MAPSESSIONSCHEMA ZWC TARGET ZHONGWC
DDL include mapped
ddloptions report
ddlerror 30568, ignore
ddlerror 942, ignore
ddlerror 955, ignore
ddlerror 1430, ignore
ddlerror 54,ignore
ddlerror 904,ignore
ddlerror 4081,ignore
ddlerror 1418,ignore
REPORT AT 01:59
REPORTCOUNT EVERY 30 MINUTES, RATE
REPERROR DEFAULT, ABEND
HANDLECOLLISIONS
assumetargetdefs
DISCARDFILE ./dirrpt/repa.dsc, PURGE, MEGABYTES 1024
DISCARDROLLOVER AT 02:30
ALLOWNOOPUPDATES
GROUPTRANSOPS 2000
BATCHSQL
MAPEXCLUDE ZWC.TB1;
MAP ZWC.*, TARGET ZWC.*;
--MAP ZWC.*, TARGET ZHONGWC.* ,filter (@range (1, 6));