Integrated Extract Does Not Capture Random Transactions - Inserts & Updates
(Doc ID 2948035.1)
Last updated on JULY 17, 2023
Applies to:
Oracle GoldenGate - Version 21.3.0.0.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |