关闭

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

1221人阅读 评论(0) 收藏 举报
分类:

一.问题描述:


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

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

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:162240次
    • 积分:4456
    • 等级:
    • 排名:第7029名
    • 原创:297篇
    • 转载:0篇
    • 译文:1篇
    • 评论:2条
    文章分类
    最新评论