OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss o

来源：互联网发布：cmd命令查看端口号编辑：程序博客网时间：2024/05/29 13:32

一.问题描述：

ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, ext_xps.prm: The redo record indicates data loss on object 276971.

OGG-01973 Oracle GoldenGate Capture For Oracle - The Redo Record Indicates Data Loss On Object <X > (文档 ID 1629057.1)

In this Document

Symptoms Cause Solution References

APPLIES TO:

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:

TABLEEXCLUDE *.DBMS_TABCOMP_TEMP_UNCMP

or modify the line like that:

TABLEEXCLUDE *.DBMS_TABCOMP_TEMP*

忽略报错：

0 0