Integrated Extract Does Not Capture Random Transactions - Inserts & Updates (Doc ID 2948035.1)

Last updated on JULY 17, 2023

Applies to:

Symptoms

Integrated Extract is missing to capture the random transactions - Inserts & Updates in the incremental extract trail files.

We have scanned through the trail files and the record isn’t there.

For Example, the insert record that is missing has ID number 55550004444444 with record
insert time stamp 10-03-2023 16:40:02.

When I used adhoc logminer to mine through the archive log that holds the
record, I could extract it just fine using below scripts:
 
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
   LOGFILENAME =>
'<complete path of archive log>',
-
   OPTIONS => DBMS_LOGMNR.NEW);
 
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
   LOGFILENAME =>
'<complete path of another archive log file>',
-
   OPTIONS => DBMS_LOGMNR.ADDFILE);
 
SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => -
   DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + -
   DBMS_LOGMNR.COMMITTED_DATA_ONLY);
 
SQL> select SQL_REDO from v$LOGMNR_CONTENTS where TABLE_NAME = '<TABLE_NAME>'
AND SQL_REDO like '%55550004444444%' and OPERATION = 'INSERT' ;

this query will returns insert.

Here is the start_scn and start_timestamp of the transaction.
 
SQL> select START_SCN , START_TIMESTAMP from v$logmnr_contents where
TABLE_NAME = '<TABLE_NAME>' AND SQL_REDO like '%55550004444444%' and
OPERATION = 'INSERT' ;
 
           START_SCN START_TIMESTAMP
-------------------- --------------------
      44458473XXXXXX 10-MAR-2023 16:40:00

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.