My Oracle Support Banner

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 JUNE 10, 2021

Applies to:

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

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

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.