OGG Replicat Checkpoint RBA Is Larger than Local Trail Size- Ogg v11.2
(Doc ID 1536741.1)
Last updated on JULY 18, 2023
Applies to:
Oracle GoldenGate - Version 11.2.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
After a system outage, a Replicat could get abended with the following error message. This issue occurs when the replicat read checkpoint RBA is larger than the local trail file size that it reads.
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 "<PATH>/xx000068" (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 <PATH>/xx000067
2012-09-06 22:32:04.123161 RBA 197650300
when you list the trail files, both xx000067 and xx000068 exist, but xx000067 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 <PATH>/xx000067
-rw-rw-rw- 1 oracle dba 83807478 Sep 7 12:46 <PATH>/xx000068
So the Replicat is reading past the EOF of the trail file.
The same issue is also noticed when a disk space issue happens.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |