2019年7月11日星期四,GoldenGate參數,概述,所有的GoldenGate進程均有參數文件 Manager Extract Replicat Utilities 所有參數均有缺省配置 實際應用只需對小部分參數進行配置 所有參數文件均放在 ./dirprm目錄下 缺省通過進程名進行查找.,2019年7月11日星期四,Manager參數,MANAGER 參數舉例,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 參數,Extract 參數概覽,抽取進程有以下方面參數: Checkpoint 復制目標 Local System Multiple Remote Systems One to many GoldenGate Trails 數據源 Which Tables Which Rows and Columns Which Operations 數據影射和變換,Extract參數文件舉例 日志抽取進程,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參數文件舉例 傳輸進程,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參數,Syntax: TABLE , WHERE () , FILTER () , KEYCOLS () , COLS () | , ) , COLSEXCEPT () | , ) , FETCHCOLS () | , ) , FETCHCOLSEXCEPT () | , ) , SQLEXEC , FETCHBEFOREFILTER , SQLPREDICATE “WHERE ” , COLMAP () , , , ; 注意：TABLE的結尾有一個分號。,Extract參數（一）,Extract參數（二）,Extract參數（三）,Extract參數（四）,Extrac參數（五）,Extrac參數（六）,2019年7月11日星期四,Replicat參數,Replicat 參數概覽,提供如下方面參數: Checkpoint 數據影射關系 Optional row-level selection criteria Optional column mapping facilities Optional transformation services Optional Stored Procedure or SQL query execution 錯誤處理機制 其它可選參數,Replicat 參數舉例,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參數,MAP , TARGET , EXCEPTIONSONLY