GoldenGate常用参数.ppt

2019年11月19日星期二,GoldenGate参数,概述,所有的GoldenGate进程均有参数文件ManagerExtractReplicatUtilities所有参数均有缺省配置实际应用只需对小部分参数进行配置所有参数文件均放在./dirprm目录下缺省通过进程名进行查找.,2019年11月19日星期二,Manager参数,MANAGER参数举例,PORT7809DYNAMICPORTLIST7840-7850PURGEOLDEXTRACTS/ggs/dirdat/rt*,USECHECKPOINTSAUTOSTARTER*AUTORESTARTEXTRACT*,WAITMINUTES2,RETRIES5LAGREPORTHOURS1LAGINFOMINUTES3LAGCRITICALMINUTES5,MANAGERParametersPortManagement,MANAGERParametersEventManagement,2019年11月19日星期二,Extract参数,Extract参数概览,抽取进程有以下方面参数:Checkpoint复制目标LocalSystemMultipleRemoteSystemsOnetomanyGoldenGateTrails数据源WhichTablesWhichRowsandColumnsWhichOperations数据影射和变换,Extract参数文件举例日志抽取进程,extractextszuseridgoldengate,password*-REPORTAT01:59-reportrolloverat02:00-transmemorydirectory(/backup/goldengate/dirtmp,8G,4G),ram2G,transram500Mtranlogoptionsrawdeviceoffset0-warnlongtrans12h,checkintervals30mexttrail/backup/goldengate/dirdat/szdynamicresolutionnumfiles2000tableexcludectais2.TMP_*;tableexcludectais2.BAK_*;tableexcludectais2.MLOG$_*;tableexcludectais2.RUPD$_*;tableexcludectais2.KJ_*;tablectais2.*;,Extract参数文件举例传输进程,extractdpeszsetenv(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)passthruREPORTAT01:59reportrolloverat02:00transmemorydirectory(/backup/goldengate/dirtmp,8G,4G),ram2G,transram500M-threadoptionsiolatencydelay3000rmthost99.16.1.12,mgrport7809,compressrmttrail/oradata/goldengate/dirdat/szdynamicresolutionnumfiles3000tablectais2.*;,ExtractTable参数,Syntax:TABLE,WHERE(),FILTER(),KEYCOLS(),COLS()|,),COLSEXCEPT()|,),FETCHCOLS()|,),FETCHCOLSEXCEPT()|,),SQLEXEC,FETCHBEFOREFILTER,SQLPREDICATE“WHERE”,COLMAP(),;注意：TABLE的结尾有一个分号。,Extract参数（一）,Extract参数（二）,Extract参数（三）,Extract参数（四）,Extrac参数（五）,Extrac参数（六）,2019年11月19日星期二,Replicat参数,Replicat参数概览,提供如下方面参数:Checkpoint数据影射关系Optionalrow-levelselectioncriteriaOptionalcolumnmappingfacilitiesOptionaltransformationservicesOptionalStoredProcedureorSQLqueryexecution错误处理机制其它可选参数,Replicat参数举例,replicatrepszsetenv(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)useridgoldengate,password*sqlexecAltersessionsetconstraints=deferredREPORTAT01:59reportrolloverat02:00-handlecollisionsreperrordefault,discarddiscardfile/oradata/goldengate/dirrpt/repsz.dsc,append,megabytes10-grouptransops100-batchsqlassumetargetdefsallownoopupdatesdynamicresolutionnumfiles3000-mapexcludeCTAIS2.JC_GY_SWWSWH-mapCTAIS2.SHOULIXINXI,targetCTAIS2.SHOULIXINXI,keycols(SHOULIBIANHAO);MAPctais2.*,TARGETctais2.*;,ReplicatMAP参数,MAP,TARGET,EXCEPTIONSONLY