ctory (/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.*;
示例3:
extract extl --抽取进程名
userid ddw,password ddw --连接本机DB的帐号密码
rmthost 192.168.0.44, mgrport 7801 --目标数据库服务器地址和GG服务端口号
rmttrail d:\tools\GG\gg10g\dirdat\rl --远程队列的位置
dynamicresolution --优化参数,动态分析表结构
gettruncates --抓取truncate数据
table ddw.aatest; --需要抽取的表,可以使用通配符
3、全部可选参数
(1)通用参数
CHECKPARAMS Verifies parameter file syntax.
如果加入该参数,表示下次运行只是检查一下语法,并不实际运行进程。 注意:该命令只能检查一些简单语法,并不能保证参数文件是完全正确的。
COMMENT | -- Denotes comments in a parameter file. ##注释行,也可以用两个中划线--代替.--checkparams表示本行已经被注释掉
ETOLDFORMAT Generates trails in a format that is compatible with Replicat versions prior to Oracle GoldenGate version 6.0.
GETENV Retrieves variables that were set with the SETENV parameter.
SETENV Specifies a value for a UNIX environment variable from within the GGSCI interface.
针对extract进程设定系统环境变量。
示例:SETENV (NLS_LANG="AMERICAN_AMERICA.UTF8") --设置字符集环境变量为UTF8
OBEY Processes parameter statements contained in a different parameter file.
可以将外部文件的内容包含到本参数文件中来。用于将一些可以重复利用的参数文件部分内容隔离出来,便于统一修改。Obey tables.txt
RECOVERYOPTIONS Controls the recovery mode of the Extract process.
TCPSOURCETIMER |
NOTCPSOURCETIMER Adjusts timestamps of records transferred to other systems when those systems reflect different times.
TRACETABLE |
NOTRACETABLE Causes Extract to ignore database changes generated by Replicat during bidirectional synchronization. Supports Oracle
(2)处理方法Processing method
BEGIN Specifies when to begin a processing run.
DSOPTIONS Specifies Extract processing options when a Teradata Access Module (TAM) is being used.
END Specifies when to end a processing run.
EXTRACT Defines an Extract group as an online process. ##定义抽取进程的名字
GETAPPLOPS |
IGNOREAPPLOPS Controls whether or not operations from all processes except Replicat are written to a trail or file.
GETREPLICATES |
IGNOREREPLICATES Controls whether or not replicated operations are capture