My Oracle Support Banner

Classic Extract Abends with OGG-00446 Error on Windows System (Doc ID 1670624.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 and later
Generic Windows

Symptoms

 Classic Extract abends with

 

2014-05-09 09:25:49  ERROR   OGG-00446  Could not find archived log for sequence 133 thread 1 under alternative destinations.
SQL <Not available>. Last alternative log tried <PATH>\<FILENAME>. Failed to open redofile <PATH>\<FILENAME> for sequence XXX during initial positioning.
Not able to establish initial position for sequence XXX, rba YYYYYY.

 

The archive log is present in the database. On checking the file name in the database, it differs with the name the extract is trying to read


SQL> select name from v$archived_log where sequence#=XXX;

NAME
------------------------------------------------------------------
<PATH>\<FILENAMExxx>

 

 

Changes

 

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
References


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