Resync / Recover Data ( Tables , Trails ) Trails Are Missing, Damaged, Incompatible, Corrupt or Suspect for Extract or Replicat (Doc ID 1614665.1)

Last updated on APRIL 05, 2023

Applies to:

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

Goal

To reliably recover data from Oracle logs when such data may have been lost or damaged in the trails prior to application by replicat or processed by an extract pump.
Recovery depends on whether the local extract trail as created by the main transaction log extract or target remote trail as written by an extract pump.
Examples of these Error messages in the report file indicates a possible corrupt trail:
OGG-01028 Incompatible record (logical EOF) in
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}
....etc