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 17, 2019
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 |