GGS Error 500 "Could Not Find Archived Log For Sequence"

(Doc ID 1186935.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle GoldenGate - Version 10.4.0.0 to 10.4.0.76 [Release 10.4.0]
Information in this document applies to any platform.
***Checked for relevance on 22-Nov-2013***

Symptoms

ORACLE RAC Extract fails with the error

GGS Error 500 Could Not Find Archived Log For Sequence

The error message describes an archive log for a thread is not available when it is on disk.

A diagnostic is to run the query that OGG is running to see if you return more than one row which is a symptom of the a known bug.

Here is the query that will help you diagnose the issue 

SELECT sequence#, DECODE(archived, 'YES', 1, 0) FROM v$log WHERE
sequence# = (select max(sequence#) from v$log where first_time <
TO_DATE('timeinyourerrormessage','YYYY-MM-DD HH24:MI:SS') AND thread# = <thread # in error message> );

here is an example error and the pieces that were used to complete the query :-

GGS ERROR 500 Oracle GoldenGate Capture for Oracle, e1.prm: Could not find archived log for sequence 13861 thread 7 under default destinations SQL <SELECT name FROM gv$archived_log WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND deleted = 'N>, error retrieving redo file name for sequence 13861, archived = 1, use_alternate = 0 Not able to establish initial position for begin time 2010-07-22 03:02:40

Here is the completed query ready to be executed against the DB :-  

SELECT sequence#, DECODE(archived, 'YES', 1, 0) FROM v$log WHERE
sequence# = (select max(sequence#) from v$log where first_time <
TO_DATE('2010-07-22 03:02:40','YYYY-MM-DD HH24:MI:SS') AND thread# = 7 );

When run, returned the following output:

SEQUENCE# DECODE(ARCHIVED,'YES',1,0)
13881 0
13881 1

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