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 APRIL 17, 2023

Applies to:

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


 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/]
: [/u01/ogg/bin/../lib/*, unsigned int, ...))]
: [/u01/ogg/bin/../lib/*, 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/]
: [/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 > sysdate - 1;

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






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

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