goldengate（25）

goldengate（25）--参数选项TRANLOGOPTIONS DBLOGREADERBUFSIZE

选项DBLOGREADERBUFSIZE默认 2M,

下面是metalink下介绍的一篇文档，但DBLOGREADERBUFSIZE 为2M的时候，报错OGG-00720 ，导致extract 进程挂起。

下面是详细内容：

Applies to:

Oracle GoldenGate - Version 11.1.1.1.2 and later
Information in this document applies to any platform.

Symptoms

Extract hangs on AIX platform. when reading archived/redo log files from ASM via DBLOGREADER.

The ggserr.log file shows warnings like this:

WARNING OGG-00720 Oracle GoldenGate Capture for Oracle, .prm: Waiting for archive log +ASM/archivelog/2011_12_16/thread_1_seq_342619.1332.770035279 for seqno 342619 , has read 448141312 bytes, to be flushed.

Cause

This is an AIX specific problem. When the DBLOGREADERBUFSIZE is set higher than 1 MB the extract cannot read the files as the AIX read buffer size is 1 MB.

The default value of DBLOGREADERBUFSIZE  is 2 MB, thus not specifying explicitly this parameter will cause extract to hang.

Solution

1. Set DBLOGREADERBUFSIZEto 1 MB in the extract's parameter file:

TRANLOGOPTIONS DBLOGREADERBUFSIZE 1M

or

2. Use the build which contains a fix for this bug:
  BUG 13530053 - EXTRACT IS HUNG WITH WARNING OGG-00720 WAITING FOR BYTES TO BE FLUSHED TO ARCH

OGG Extract Hangs on AIX When Reading Through DBLOGREADER [ID 1432994.1]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21266384/viewspace-757284/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21266384/viewspace-757284/