Oracle GoldenGate EXTRACT/REPLICAT/MGR parameter Example

来源：互联网发布：怎么看淘宝买家的评价编辑：程序博客网时间：2024/05/17 04:11

SOURCE

mgr

PORT 7839DYNAMICPORTLIST 7840-7914USERID 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 1LAGINFOMINUTES 30LAGCRITICALMINUTES 45

extract

EXTRACT extasetenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERID goldengate, PASSWORD goldengatecachemgr cachedirectory ./dirtmp 20480MB, CacheDirectory /arch-----DDL Include Mapped--DDL INCLUDE OBJNAME "ZWC.*"  EXCLUDE INSTR 'CREATE TRIGGER' --DDLOPTIONS ADDTRANDATA NOCROSSRENAME  REPORT--TRANLOGOPTIONS RAWDEVICEOFFSET 0REPORTCOUNT EVERY 1 MINUTES, RATEDISCARDFILE ./dirrpt/exta.dsc,APPEND,MEGABYTES 1024DBOPTIONS  ALLOWUNUSEDCOLUMNWARNLONGTRANS 5h,CHECKINTERVAL 30mEXTTRAIL ./dirdat/eaFETCHOPTIONS NOUSESNAPSHOTtranlogoptions altarchivelogdest instance zwc /archTranLogOptions ExcludeUser goldengateTRANLOGOPTIONS DBLOGREADERTRANLOGOPTIONS _INFINITYTOZERO--TranlogOptions ASMUser sys@zwc_asm , asmpassword oraclepwdTRANLOGOPTIONS  CONVERTUCS2CLOBS--exclude report --------TABLEEXCLUDE ZWC.TB1;               table ZWC.*;

TARGET

mgr

PORT 7839DYNAMICPORTLIST 7840-7914USERID goldengate, PASSWORD goldengate--AUTOSTART REPLICAT *AUTORESTART REPLICAT *, RETRIES 5, WAITMINUTES 3PURGEOLDEXTRACTS ./dirdat/*,USECHECKPOINTS, MINKEEPDAYS 10 LAGREPORTHOURS 1LAGINFOMINUTES 30LAGCRITICALMINUTES 45

REPLICAT

REPLICAT repasetenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)setenv (ORACLE_SID="zwc")USERID goldengate, PASSWORD goldengate--DDLOPTIONS MAPSESSIONSCHEMA ZWC TARGET ZHONGWCDDL include mappedddloptions reportddlerror 30568, ignore ddlerror 942, ignoreddlerror 955, ignoreddlerror 1430, ignoreddlerror 54,ignoreddlerror 904,ignoreddlerror 4081,ignoreddlerror 1418,ignoreREPORT AT 01:59REPORTCOUNT EVERY 30 MINUTES, RATEREPERROR DEFAULT, ABENDHANDLECOLLISIONSassumetargetdefsDISCARDFILE ./dirrpt/repa.dsc,  PURGE, MEGABYTES 1024DISCARDROLLOVER AT 02:30ALLOWNOOPUPDATESGROUPTRANSOPS 2000BATCHSQLMAPEXCLUDE ZWC.TB1;MAP ZWC.*, TARGET ZWC.*;--MAP ZWC.*, TARGET ZHONGWC.* ,filter (@range (1, 6));