Even when sequence number in trail file reaches the maximum value, does not start from 0.
(Doc ID 2596034.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 11.2.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
Behavior when sequence number of the trail file reaches the maximum value is mentioned in public document "Understanding Oracle GoldenGate".
https://docs.oracle.com/en/middleware/goldengate/core/19.1/understanding/getting-started-oracle-goldengate.html#GUID-88674F53-1E07-4C00-9868-598F82D7113C
Oracle Fusion Middleware Understanding Oracle GoldenGate 19c (19.1.0)
E98077-01 April 2019
- Trail File Creation and Maintenance:
As each new file is created, it inherits the two-character
trail name appended with a unique nine digit sequence number
from 000000000 through 999999999 (for example c:\ggs\dirdat\tr000000001).
When the sequence number reaches 999999999, the numbering
starts over at 000000000, and previous trail files are overwritten.
However, Even when sequence number in trail file reaches the maximum value, does not start from 0.
In GoldenGate 18c and earlier, the sequence number exceeds the maximum value, and Extract Process is abended.
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 |
Cause |
Solution |
References |