My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.