GoldenGate常用参数.ppt

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