Steps to re-extract data from source when pump or replicate fails with trail file corruption errors using SCN (Doc ID 2092467.1)

Last updated on JULY 12, 2017

Applies to:

Oracle GoldenGate - Version 10.0.0.0 and later
Information in this document applies to any platform.
Relevant for
OGG-01028 Incompatible record (logical EOF),
OGG-01179: Mismatched record version/bad data in {0} at {1},
OGG-01184: Expected {3,number,0} bytes, but got {4,number,0} bytes, in trail {0},seqno {1,number,0}, reading record trailer token at RBA {2,number,0},
Unable to lock file "/h/remis/ggs/dirdat/em000002" (error 13, Permission denied). Lock currently held by process id (PID) nnnnn).
Unable to lock file "/opt/oracle/ggs/dirdat/r2000008" (error 11, Resource temporarily unavailable).

Goal

 How to re-extract from the source when your pump or replicate hits an error which is caused by a corrupted trail

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