Please check gg log file:--
ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, elci3t1d.prm: The redo record indicates data loss on object 80,238.
To FIX:
Query the database with the folloiwng query then exclude the table from the extract. In this case it was the workorder table.
select owner, object_name from dba_objects where object_id=80238 or data_object_id=80238;
GGSCI (nmsis) 18> edit param ELCI3T1D
TABLEEXCLUDE MER.WORKORDER;
SAVE AND EXIT
ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, elci3t1d.prm: The redo record indicates data loss on object 80,238.
To FIX:
Query the database with the folloiwng query then exclude the table from the extract. In this case it was the workorder table.
select owner, object_name from dba_objects where object_id=80238 or data_object_id=80238;
GGSCI (nmsis) 18> edit param ELCI3T1D
TABLEEXCLUDE MER.WORKORDER;
SAVE AND EXIT
No comments:
Post a Comment