Oracle GoldenGate - Version 11.2.1.0.1 and later
Information in this document applies to any platform.
SYMPTOMS
After GoldenGate upgrade from 11.1.1.3 to 11.2.1.0.14, errors occur in the log file and extract process
2014-01-06 22:18:45 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 276971. 2014-01-09 22:21:33 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 277202. 2014-01-10 22:18:21 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 277224. 2014-01-13 22:12:10 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 277479. 2014-01-14 22:13:10 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 277524. 2014-01-18 06:05:42 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 277749. 2014-01-24 22:14:31 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 278215. 2014-01-26 10:05:57 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 278304. 2014-01-26 10:12:47 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 278312. 2014-01-26 18:04:23 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 278327. 2014-01-27 22:15:40 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 278374. 2014-01-28 22:21:05 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 278527.
CAUSE
Compression Advisor (delivered with DBMS_COMPRESSION in 11gR2) is used.
DBMS_TABCOMP_TEMP_UNCMP and DBMS_TABCOMBP_TEMP_CMP are tables which are created and dropped dynamically by Oracle. If you check the object ID reported in the error message, the object ID is already gone.
So we can see in the extract parameter file : TABLEEXCLUDE *.DBMS_TABCOMP_TEMP_CMP
but not
TABLEEXCLUDE *.DBMS_TABCOMP_TEMP_UNCMP
SOLUTION
As tables DBMS_TABCOMP_TEMP_UNCMP are not excluded, please add this line in the extract parameter file: