UPREPORT Determines how often process heartbeat messages are reported.
##确定心跳检测信息多久报告一次
(4)事件管理参数:
DOWNCRITICAL Reports processes that stopped gracefully or abnormally.
DOWNREPORT Controls the frequency for reporting stopped processes.
LAGCRITICAL Specifies a lag threshold that is considered critical and generates a warning to the error log.
指定认为超过此时间即为严重错误的延迟最大值,如果延迟达到此时间值则会在ggserr.log里面写入一条error信息
示例:LAGCRITICALMINUTES 45 --传输延时超过45分钟将写入警告日志
LAGINFO Specifies a lag threshold at which an informational message is reported to the error log.
指定一个延迟时限,如果延迟达到此时间值则会在ggserr.log里面写入一条info信息
示例:LAGINFOMINUTES 30 --传输延时超过30分钟将写入错误日志
LAGREPORT Sets an interval for reporting lag time to the error log
指定在ggserr.log中报告延迟的时间间隔.
示例:LAGREPORTHOURS 1 --每隔一小时检查一次传输延迟情况
(5)数据库登陆:
SOURCEDB Specifies a data source name as part of the login information.
示例:SOURCEDB mydb
SOURCEDB mydb, USERID ggs, PASSWORD ggs123
USERID Provides login information for Manager when it needs to access the database.
示例:USERID /
USERID ggs, PASSWORD ggs123
USERID ggs@ora1.ora, PASSWORD ggs123
USERID data1
USERID ggs, PASSWORD AACAAAAAAAAAAAIALCKDZIRHOJBHOJUH, ENCRYPTKEY superx128
USERID ggs, PASSWORD AACAAAAAAAAAAAIALCKDZIRHOJBHOJUH, ENCRYPTKEY default
(6)维护相关参数:
CHECKMINUTES Determines how often Manager cycles through maintenance activities.
PURGEDDLHISTORY Purges rows from the Oracle DDL history table when they are no longer needed.
PURGEMARKERHISTORY Purges Oracle marker table rows that are no longer needed.
PURGEOLDEXTRACTS Purges trail data that is no longer needed.##自动删除过时的队列以节省硬盘空间。
一般按照两个规则来删除:
首先,要满足检查点要求,没有使用过的队列不能删除,保证无数据丢失;
其次,可以保留一定的天数。只有当已经使用过且超过设定的天数后的队列会被自动删除。
示例:purgeoldextracts /backup/goldengate/dirdat/*,usecheckpoints, minkeepdays 7
PURGEOLDTASKS Purges Extract and Replicat tasks after a specified period of time.
STARTUPVALIDATIONDELAY[CSECS] Sets a delay time after which Manager checks that processes are still running after startup.
参考:Oracle GoldenGate Windows and UNIX Reference Guide 11g Release 1(11.1.1) E17791-01
Oracle Golden Gate 系列八 -- GG 参数文件 说明
二、extract进程相关参数
1、常用参数
抽取进程有以下方面参数: