My Oracle Support Banner

How To Recover From Extract Pump Writing A Trail File In The 1000000 (One Million) Range (Doc ID 1632812.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


To recover from extract writing a trail with a sequence number in the 1000000 plus range.

This occurs due to a design flaw in extract as described in What Happens When The Maximum Number Of Trail Files (999999) Is Exceeded? (Doc ID 1060554.1).

This problem is visible in a report by looking at the trail sequence number..

Log Read Checkpoint  File <PATH>/xx1000000  <<<<<<<<---------
                    First Record  RBA 9999993


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

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