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

Last updated on APRIL 04, 2017

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 D:\Software\GG\dirdat\ARC00133_0841492194.001. Failed to open redofile D:\Software\GG\dirdat\ARC00133_0841492194.001 for sequence 133 during initial positioning.
Not able to establish initial position for sequence 133, rba 357392.

 

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#=133;

NAME
------------------------------------------------------------------
D:\Software\GG\dirdat\ARC0000000133_0841492194.0001

 

 

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