Maclean Liu(刘相兵

FYI

Symptoms

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
---------
2011-02-06 05:15:38  WARNING OGG-01573  br_validate_bcp: failed in call to: ggcrc64valid.

2011-02-06 05:15:38  WARNING OGG-01573  br_validate_bcp: failed in call to: br_validate_bcp.

2011-02-06 05:15:38  INFO    OGG-01639  BOUNDED RECOVERY:  ACTIVE: for object pool 1: p7186_Redo Thread 1.

2011-02-06 05:15:38  INFO    OGG-01640  BOUNDED RECOVERY: recovery start XID: 0.0.0.
...
2011-02-06 09:15:46 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p7186_Redo Thread 1: start=SeqNo: 21659, RBA: 117520912, SCN: 0.2984644709 (2984644709), Timestamp: 2011-02-06 09:15:44.000000, end=SeqNo: 21659, RBA: 117602816, SCN: 0.2984644709 (2984644709), Timestamp: 2011-02-06 09:15:44.000000.

Cause

Under these conditions, this may be a problem with the Bounded Recovery Checkpoint file. It is likely corrupted.

Solution

The solution is to reset the Bounded Recovery Checkpoint file when restarting the extract like:

GGSCI> start <extract> BRRESET