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

Last updated on JANUARY 13, 2017

Applies to:

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

Goal

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 /ggsdata/opd1/dirdat/rb1000000  <<<<<<<<---------
                    First Record  RBA 9999993

Solution

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