Tuesday, August 14, 2012

Extract Abends With Bounded Recovery Errors in "ggserr.log"

Extract Abends With Bounded Recovery Errors in "ggserr.log"


Affected Versions: Oracle GoldenGate - Version 11.1.1.0.6 and later


Issues:



When running Oracle Golden Gate 11.1.1.0.6 or higher,  extract is "abending" every 4 hours on the hour. This approximates the same time or interval that Bounded Recovery is set to by default.
Extract can be restarted and continues to work but then fails again after 4 hours with the same errors as shown below.

ERROR

2012-08-14 15:15:36  WARNING OGG-01573  Oracle GoldenGate Capture for Oracle, eaatt.prm:  br_validate_bcp: failed in call to: ggcrc64valid.
2012-08-14 15:15:36  WARNING OGG-01573  Oracle GoldenGate Capture for Oracle, eaatt.prm:  br_validate_bcp: failed in call to: br_validate_bcp.
2012-08-14 15:15:36  INFO    OGG-01639  Oracle GoldenGate Capture for Oracle, eaatt.prm:  BOUNDED RECOVERY: ACTIVE: for object pool 1: p21900_Redo Thread 1.


Cause
There may be a problem with the Bounded Recovery Checkpoint file or Network Timeout to the file. 


Solution:

If the problem is with Bounded Recovery Checkpoint file, then restarting the extract by resetting Bounded Recovery will fix the issue, like:

GGSCI> start extract <extract> BRRESET