GGS Error 500 "Could Not Find Archived Log For Sequence" (Doc ID 1186935.1)

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

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