Extract Process Abending Due to Ogg-00446 Could Not Find Archived Log for Sequence Xxxxx Th 1 (Doc ID 1453569.1)

Last updated on MAY 16, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.1.0 to 11.2.0.0.0 [Release 11.1.1.1 to 11.2]
Information in this document applies to any platform.

Symptoms

When one node of Oracle RAC fails, extract abends on startup in the remaining node while trying to find the new  thread.

GGSCI> ADD EXTRACT EX, TRANLOG, BEGIN NOW, THREADS 2
EXTRACT added.
GGSCI> ADD EXTTRAIL /gg/home/dirdat/ex, EXTRACT EX, MEGABYTES 50
EXTTRAIL added.

After starting, it gives an error:
2012-04-26 15:53:26 INFO OGG-01515 Positioning to begin time Apr 26, 2012 3:44:48 PM.

Source Context :
 SourceModule : [er.main]
 SourceID : [/scratch/mmar/view_storage/mmar_stath08_tiers/oggcore/OpenSys/src/app/er/rep.c]
 SourceFunction : [extract_start_point]
 SourceLine : [13026]

2012-04-26 15:54:47 ERROR OGG-00446 Could not find archived log for sequence 80893 thread 1 under default destinations SQL

Changes

One node of Oracle RAC failed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms