My Oracle Support Banner

Extract Abends With Ogg-00446 Could Not Find Archived Log for Sequence When A RAC Node is down (Doc ID 1453569.1)

Last updated on NOVEMBER 02, 2018

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

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
Changes
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.