sp; --指定在解析数据库日志时所需要的特殊参数
--本参数只用在extract端 UTF字符类型,并且11.1.1前处理CLOB才需要:
示例3:--tranlogoptions asmuser sys@asm, asmpassword AACAAAAAAAAAAGAIF, ENCRYPTKEY default
示例4:TRANLOGOPTIONS altarchivelogdest primary instance sgpmdb1 /sgpmdb/arch altarchivelogdest instance sgpmdb2 /sgpmdb/arch 指定RAC环境下每个节点的归档日志地址
TRANSMEMORY Controls the amount of memory and temporary disk space available for caching uncommitted transaction data.
设定GoldenGate的抽取进程能够使用的内存大小。如下参数指定本进程最大只能占用2G内存,其中每个事务最大占用内存不能超过500M,如果超过则使用指定目录作为虚拟内存,该目录下的单个文件大小为4G,最多只能在该目录下占用8G空间作为缓存:
示例:transmemory directory (/backup/goldengate/dirtmp,8G,4G),ram 2G,transram 500M
(11)维护Maintenance
DISCARDROLLOVER Controls how often to create a new discard file.
示例:DISCARDROLLOVER AT 3:00 --为了防止discard file被写满,每天3:00做一次文件过期设定
PURGEOLDEXTRACTS Purges obsolete trail files.同mgr进程,可以设置自动删除队列,建议在mgr设置
REPORTROLLOVER Specifies when to create new report files.
设定切换一个日志的时间和间隔。示例:reportrollover at 02:00
ROLLOVER Specifies the way that trail files are aged.
(12)安全性Security
DECRYPTTRAIL Decrypts data in a trail or extract file. 解密trail文件或extract文件数据
ENCRYPTTRAIL | NOENCRYPTTRAIL Controls encryption of data in a trail or extract file. 加密trail或extract文件的数据