Classic Extract Fails With Error "The redo record indicates data loss on object nnnnn"

(Doc ID 2316712.1)

Last updated on OCTOBER 12, 2017

Applies to:

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

Symptoms

 Classic extract on 12.2 fails with ERROR OGG-01973 ...The redo record indicates data loss on object nnnnn

Note that, Table with same object id exists on database

SQL> select object_name,owner, object_type from dba_objects where object_id=nnnn;

 

 

 

 

Changes

 none

Cause

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