GGS ERROR 500 Oracle GoldenGate Capture for Oracle, ext1.prm: Could not find archived log for sequence

Oracle GoldenGate - Version: 10.4.0.19 and later   [Release: 10.4.0 and later ]
Information in this document applies to any platform.

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 excuted 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

The query executed in OGG to obtain the correct archive file for the thread returned more than one row. The query didn't take having multiple threads into account with log sequence # that were close in value, this is a known bug 9846123

Solution

Upgrade to 10.4.0.77 or higher, and restart your extract,
or do the following
1. switch log file
2. position extract to current sequence number minus 1.