GoldenGate常用參數(shù).ppt

2019年7月11日星期四,GoldenGate參數(shù),概述,所有的GoldenGate進程均有參數(shù)文件 Manager Extract Replicat Utilities 所有參數(shù)均有缺省配置 實際應(yīng)用只需對小部分參數(shù)進行配置 所有參數(shù)文件均放在 ./dirprm目錄下 缺省通過進程名進行查找.,2019年7月11日星期四,Manager參數(shù),MANAGER 參數(shù)舉例,PORT 7809 DYNAMICPORTLIST 7840-7850 PURGEOLDEXTRACTS /ggs/dirdat/rt*, USECHECKPOINTS AUTOSTART ER * AUTORESTART EXTRACT *, WAITMINUTES 2, RETRIES 5 LAGREPORTHOURS 1 LAGINFOMINUTES 3 LAGCRITICALMINUTES 5,MANAGER Parameters Port Management,MANAGER Parameters Event Management,2019年7月11日星期四,Extract 參數(shù),Extract 參數(shù)概覽,抽取進程有以下方面參數(shù): Checkpoint 復(fù)制目標 Local System Multiple Remote Systems One to many GoldenGate Trails 數(shù)據(jù)源 Which Tables Which Rows and Columns Which Operations 數(shù)據(jù)影射和變換,Extract參數(shù)文件舉例 日志抽取進程,extract extsz userid goldengate, password * -REPORT AT 01:59 -reportrollover at 02:00 -transmemory directory (/backup/goldengate/dirtmp,8G,4G),ram 2G,transram 500M tranlogoptions rawdeviceoffset 0 -warnlongtrans 12h, checkintervals 30m exttrail /backup/goldengate/dirdat/sz dynamicresolution numfiles 2000 tableexclude ctais2.TMP_*; tableexclude ctais2.BAK_*; tableexclude ctais2.MLOG$_*; tableexclude ctais2.RUPD$_*; tableexclude ctais2.KJ_*; table ctais2.*;,Extract參數(shù)文件舉例 傳輸進程,extract dpesz setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK ) passthru REPORT AT 01:59 reportrollover at 02:00 transmemory directory (/backup/goldengate/dirtmp,8G,4G), ram 2G,transram 500M -threadoptions iolatencydelay 3000 rmthost 99.16.1.12,mgrport 7809, compress rmttrail /oradata/goldengate/dirdat/sz dynamicresolution numfiles 3000 table ctais2.*;,Extract Table參數(shù),Syntax: TABLE , WHERE () , FILTER () , KEYCOLS () , COLS () | , ) , COLSEXCEPT () | , ) , FETCHCOLS () | , ) , FETCHCOLSEXCEPT () | , ) , SQLEXEC , FETCHBEFOREFILTER , SQLPREDICATE “WHERE ” , COLMAP () , , , ; 注意：TABLE的結(jié)尾有一個分號。,Extract參數(shù)（一）,Extract參數(shù)（二）,Extract參數(shù)（三）,Extract參數(shù)（四）,Extrac參數(shù)（五）,Extrac參數(shù)（六）,2019年7月11日星期四,Replicat參數(shù),Replicat 參數(shù)概覽,提供如下方面參數(shù): Checkpoint 數(shù)據(jù)影射關(guān)系 Optional row-level selection criteria Optional column mapping facilities Optional transformation services Optional Stored Procedure or SQL query execution 錯誤處理機制 其它可選參數(shù),Replicat 參數(shù)舉例,replicat repsz setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK ) userid goldengate, password * sqlexec “Alter session set constraints=deferred“ REPORT AT 01:59 reportrollover at 02:00 -handlecollisions reperror default,discard discardfile /oradata/goldengate/dirrpt/repsz.dsc,append, megabytes 10 -grouptransops 100 -batchsql assumetargetdefs allownoopupdates dynamicresolution numfiles 3000 -mapexclude CTAIS2.JC_GY_SWWSWH -map CTAIS2.SHOULIXINXI, target CTAIS2.SHOULIXINXI, keycols ( SHOULIBIANHAO ); MAP ctais2.* ,TARGET ctais2.*;,Replicat MAP參數(shù),MAP , TARGET , EXCEPTIONSONLY