IE capturing from an autonomous database abends with OGG-02028/ORA-01284 when extract has been down for more than 36 hours (Doc ID 2783387.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

 An Integrated Extract process capturing changes from an Autonomous Database abends with the following errors at startup after the process has been disabled from more than 36 hours:

2021-05-31 16:04:03 INFO OGG-02248 Logmining server DDL filtering enabled.

Source Context :
SourceModule : [er.redo.oraxo]
SourceID : [er/redo/oracle/redooraix.c]
SourceMethod : [attach]
SourceLine : [1999]
ThreadBacktrace : [16] elements
: [/u01/ogg/bin/../lib/libgglog.so(CMessageContext::AddThreadContext())]
: [/u01/ogg/bin/../lib/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/u01/ogg/bin/../lib/libgglog.so(_MSG_String_Int32_String(CSourceContext*, int, char const*, int, char const*, CMessageFactory::MessageDisposition))]
: [/u01/ogg/bin/extract()]
: [/u01/ogg/bin/extract(RedoIE::validateConfig(log_context_t*, ggs::gglib::ggocicpp::ORAConnection*, ggs::gglib::ggdatasource::DataSource*, ggs::gglib::ggapp::ReplicationContext*))]
: [/u01/ogg/bin/extract(RedoAPI::createInstance(ggs::gglib::ggdatasource::DataSource*, ggs::gglib::ggapp::ReplicationContext*))]
: [/u01/ogg/bin/extract(ggs::er::OraTranLogDataSource::setup())]
: [/u01/ogg/bin/extract(ggs::gglib::ggapp::ReplicationContext::establishStartPoints(char, ggs::gglib::ggdatasource::DataSourceParams const&))]
: [/u01/ogg/bin/extract(ggs::gglib::ggapp::ReplicationContext::initializeDataSources(ggs::gglib::ggdatasource::DataSourceParams&))]
: [/u01/ogg/bin/extract()]
: [/u01/ogg/bin/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/u01/ogg/bin/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/u01/ogg/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/u01/ogg/bin/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/u01/ogg/bin/extract()]

2021-05-31 16:04:07 ERROR OGG-02028 Failed to attach to logmining server OGG$<EXT_NAME> error 1,292 - ORA-01292: LogMiner for upstream capture cannot find log file.
2021-05-31 16:04:07 ERROR OGG-01668 PROCESS ABENDING.

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

select distinct
originating_timestamp,
message_text
from
V$DIAG_ALERT_EXT
where
originating_timestamp > sysdate - 1;

08-JUN-21 07.41.56.465000000 PM GMT LOGMINER: Region Queue size: 4096
08-JUN-21 07.41.56.466000000 PM GMT LOGMINER: Max Decomp Region Memory: 1M
08-JUN-21 07.41.56.466000000 PM GMT LOGMINER: Memory Release Limit: 1M
08-JUN-21 07.41.56.466000000 PM GMT LOGMINER: Memory Size = 999M, HWM 989M, LWM 799M, 79%
08-JUN-21 07.41.56.466000000 PM GMT LOGMINER: Transaction Queue Size: 131072
08-JUN-21 07.41.56.473000000 PM GMT LOGMINER: SkipScn: 37289926665029 (0x000021ea3cd52345)
08-JUN-21 07.41.56.473000000 PM GMT LOGMINER: highCkptScn: 37289929682676 (0x000021ea3d032ef4)
08-JUN-21 07.41.56.473000000 PM GMT LOGMINER: lowCkptScn: 37289926665029 (0x000021ea3cd52345)
08-JUN-21 07.41.59.693000000 PM GMT LOGMINER: Missing log for upstream capture session# 3, FILE NA, THREAD 8, SEQUENCE 10067, SCN 0x000021ea3cd52345
08-JUN-21 07.41.59.935000000 PM GMT OGG Capture client successfully detached from GoldenGate Capture OGG$CAP_<EXT_NAME> (OS pid=344071).

Cause

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