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 works.