GoldenGate常用参数.ppt

GoldenGate参数 概述 所有的GoldenGate进程均有参数文件 Manager Extract Replicat Utilities 所有参数均有缺省配置 实际应用只需对小部分参数进行配置 所有参数文件均放在 ./dirprm目录下 缺省通过进程名进行查找. 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 – Event Management 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 file name [, WHERE (where condition)] [, FILTER (expression)] [, KEYCOLS (key column specification)] [, COLS (column) | [ , column ]) ] [, COLSEXCEPT (column) | [ , column ]) ] [, FETCHCOLS (column) | [ , column ]) ] [, FETCHCOLSEXCEPT (column) | [ , column ]) ] [, SQLEXEC clause ] [, FETCHBEFOREFILTER ] [, SQLPREDICATE “WHERE clause” ] [, COLMAP (column mapping specification)] [, record type filter, record type filter, …] ; 注意：TABLE的结尾有一个分号。 Extract参数（一） Extract参数（二）