Oracle GoldenGate EXTRACT/REPLICAT/MGR parameter Example

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 [email protected]_asm , asmpassword oraclepwd
TRANLOGOPTIONS  CONVERTUCS2CLOBS

--exclude report --------
TABLEEXCLUDE ZWC.TB1;
               
table ZWC.*;
           

TARGET

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));