GoldenGate

How to Resolve OGG-01973 The redo record indicates data loss on object

Found an extract abended when I checked the synchronization status of Golden Gate.
[oracle@test ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Sep 25 2013 02:33:54
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.

GGSCI (test) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     ABENDED     E_ERPAPP    00:00:02      34:50:40
EXTRACT     RUNNING     P_ERPAPP    00:00:00      00:00:04

We should check the extract log to see what happened at that moment.
[oracle@test ogg]$ cd dirrpt
[oracle@test ogg]$ less E_ERPAPP.rpt
...
2018-01-17 08:57:25  ERROR   OGG-01973  The redo record indicates data loss on object 297,476.

The source object ID is 297476. Let’s see what the object is.
SQL> select owner, object_type, object_name from dba_objects where object_id = 297476;

no rows selected

Maybe it had been dropped from the database. So what’s next? I think we should check the history of goldengate. (Suppose your ogg owner schema is OGG)
SQL> SELECT metadata_text, fragmentNo, optime FROM OGG.GGS_DDL_HIST WHERE seqno = (SELECT MIN(seqno) FROM OGG.GGS_DDL_HIST WHERE objectid = (SELECT objectId FROM OGG.GGS_DDL_HIST_ALT WHERE altobjectid = 297476 AND rownum = 1);

METADATA_TEXT
--------------------------------------------------------------------------------
FRAGMENTNO OPTIME
---------- ---------------------------------------------------------
,G1='drop table "ERPAP".CMP3$177665 purge ',
         1 2018-01-15 22:03:10

Oh, it’s a temporary table from Compression Advisory. So I decided to add exclusions to the extract rules.
[oracle@test dirprm]$ vi e_erpapp1.prm
...
TABLEEXCLUDE *.DBMS_TABCOMP_TEMP*
TABLEEXCLUDE *.CMP*

Then I started the extract process again.
GGSCI (test) 2> start E_ERPAPP

Sending START request to MANAGER ...
EXTRACT E_ERPAPP starting


GGSCI (test) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     E_ERPAPP    26:24:54      00:00:07
EXTRACT     RUNNING     P_ERPAPP    00:00:00      00:00:02

It worked.

Leave a Reply

Your email address will not be published. Required fields are marked *