OGG Extract / Replicat Checkpoint RBA Is Larger than Local Trail Size (Doc ID 1138409.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle GoldenGate - Version 10.0.0.0 to 11.2.0.0.0 [Release 10.0.0 to 11.2]
Information in this document applies to any platform.

Symptoms

After a system outage, a pump Extract or Replicat may get stuck on a trail file even if there are more trail files available in machine for the reader object to process. This issue occurs when the pump extract / Replicat read checkpoint RBA is larger than the local trail file size that it reads.

If using a OGG version higher than 10.4.0.81 , the error message will be like

2011-11-28 07:51:36 ERROR OGG-01705 Input checkpoint position 160374765 for input trail file '/ogg-data/ogg/itmscmp/rmtdir/pe027505' is greater than the size of the file (160301092). Please consult Oracle Knowledge Management Doc ID 1138409.1. for instructions.

 

If using a OGG version higher than V11.2.1.0.1, the error message is a bit misleading

 2012-09-07 13:01:30 ERROR OGG-01091 Unable to open file "/u01/app/goldengate/dirdat/rt000068" (error 2, No such file or directory).

When you do info, it shows


REPLICAT XXXX Last Started 2012-09-07 14:28 Status ABENDED
Checkpoint Lag 00:00:00 (updated 02:05:27 ago)
Log Read Checkpoint File /u01/app/goldengate/dirdat/rt000067
2012-09-06 22:32:04.123161 RBA 197650300

when you list the trail files, both rt000067 and rt000068 exist, but rt000067 has smaller size than the RBA

This is the list of the files on Disk
-rw-rw-rw- 1 oracle dba 197640272 Sep 6 22:43
/u01/app/goldengate/dirdat/rt000067
-rw-rw-rw- 1 oracle dba 83807478 Sep 7 12:46
/u01/app/goldengate/dirdat/rt000068

 So the Replicat is reading past the EOF of the trail file.

 

The same issue is also noticed when a disk space issue happens.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms