OGG Extracts Abends with OGG-00446 Error (Doc ID 1662433.1)

Last updated on APRIL 23, 2023

Applies to:

Symptoms

Extract abending with the following:

Maximum supported ASM read buffer size is 28 KB

2014-04-10 15:24:15 WARNING OGG-01423 No valid default archive log destination directory found for thread 1.

Maximum supported ASM read buffer size is 28 KB

2014-04-10 15:24:15 WARNING OGG-01423 No valid default archive log destination directory found for thread 2.

2014-04-10 15:24:16 INFO OGG-00546 Default thread stack size: 33554432.

2014-04-10 15:24:16 INFO OGG-01515 Positioning to begin time Apr 9, 2014 9:00:00 AM.

2014-04-10 15:24:36 INFO OGG-01516 Positioned to (Thread 1) Sequence 83, RBA 414058496, SCN 0.0, Apr 9, 2014 9:00:00 AM.

2014-04-10 15:24:36 INFO OGG-01515 Positioning to begin time Apr 9, 2014 9:00:00 AM.

Source Context :
 SourceModule : [er.common]
 SourceID : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/common.cpp]
 SourceFunction : [extract_start_point]
 SourceLine : [2090]
 ThreadBacktrace : [7] elements
  : [/app/oracle/ggs/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2ba78741470e]]
  : [/app/oracle/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x2ba78740d6ac]]
  : [/app/oracle/ggs/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x2ba7873fee09]]
  : [/app/oracle/ggs/extract(extract_start_point(time_elt_def*, time_elt_def*)+0x14e) [0x545abe]]
  : [/app/oracle/ggs/extract(main+0x3d7) [0x5738b7]]
  : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x33ae61d994]]
  : [/app/oracle/ggs/extract(__gxx_personality_v0+0x38a) [0x4edaba]]

2014-04-10 15:25:54 ERROR OGG-00446 Could not find archived log for sequence 1 thread 2 under default destinations SQL, error retrieving redo file name for sequence 1, archived = 1, use_alternate = 0Not able to establish initial position for begin time 2014-04-09 09:00:00.

2014-04-10 15:25:54 ERROR OGG-01668 PROCESS ABENDING.

Changes

Cause

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