My Oracle Support Banner

IE process capturing from an Autonomous database abends with errors OGG-02028/ORA-1304 (Doc ID 2783416.1)

Last updated on JUNE 10, 2021

Applies to:

Oracle GoldenGate - Version 19.1.0.0.4 and later
Oracle Cloud Infrastructure - GoldenGate Service - Version NA and later
Oracle Database - Enterprise Edition - Version 19.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

An Integrated Extract process capturing from an Autonomous database abends with the following errors:

OGG-02028 Oracle GoldenGate Capture for Oracle, <EXT_NAME>.prm:
Failed to attach to logmining server OGG$<NAME> error 1,304 - ORA-01304: subordinate process error.
Check alert and trace logs.
2021-06-04T06:13:39.752-0700 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, <EXT_NAME>.prm: PROCESS ABENDING.

The following query executed immediately after the extract abends shows the following errors:

select message_text from v$diag_alert_ext where originating_timestamp >
(select originating_timestamp from v$diag_alert_ext where message_text like
'Logminer%');

Fri Jun 04 13:11:02 2021
Logminer Bld: Done
GoldenGate Capture OGG$CAP_<EXT_NAME> CAPTURE Created
GoldenGate CAPTURE OGG$CAP_<EXT_NAME>: Start SCN: 36883997222249
(0xb98d6569.0000218b)

Starting persistent Logminer Session with sid = 43 for GoldenGate Capture
OGG$CAP_<EXT_NAME> (OS id=172103).

LOGMINER: Parameters summary for session# = 43
LOGMINER: Number of processes = 5, Transaction Chunk Size = 1
LOGMINER: Memory Size = 3999M, Checkpoint interval = 20000M
LOGMINER: SpillScn 0, ResetLogScn 1956119, ResetLogCnt 1034702386
LOGMINER: summary for session# = 43
LOGMINER: StartScn: 36883997222249 (0x0000218bb98d6569)

LOGMINER: Begin mining logfile during dictionary load for session 43 thread 2
sequence 13173, <path>/group_32.385.1034703447
LOGMINER: Preparing to load 1 dictionaries for session 43
LOGMINER: session# 43 Processing dictionary for pluggable database
<PDB_NAME>, pdbid 37
LOGMINER: session#=43 (OGG$CAP_<EXT_NAME>), builder MS01 pid=1157 OS id=172132
sid=346 16 stopped
Errors in file
<path>/<SID>/<INSTANCE>/trace/<inst>_ms01_1 72132.trc:
ORA-01347: Supplemental log data no longer found

 

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
Cause
Solution

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