Oracle GoldenGate常用参数详解(3)

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、常用参数

抽取进程有以下方面参数:

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/4880942e2846654ed1a91c859a090b7f.html