ARCHIVE LOG MISSING in Oracle GoldenGate

Please check ggerror.log file : ARCHIVE LOG MISSING in Oracle GoldenGate

ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, extgrp1.prm:  Opening ASM file +IPAG_RECOVERY/1_14170_778456717.dbf in DBLOGREADER mode: (308) ORA-00308: cannot open archived log '+IPAG_RECOVERY/1_14170_778456717.dbf'

ORA-17503: ksfdopn:2 Failed to open file +IPAG_RECOVERY/1_14170_778456717.dbf ORA-15173: entry '1_14170_778456717.dbf' does not exist in directory '/'Not able to establish initial position for sequence 14170, rba 94987280.

To FIX:

Restore archivelogs using RMAN on the source database, then restart GG.  The first archive log sequence that is missing can be found in the error message, "'Not able to establish initial position for sequence 14170". 

To find the last archive log missing run the SQL the first archive log listed minus one will be the last archive log missing, in this case it would be 14271.  So in order to fix the above error a restore from 14170 to 14270 would need to be performed.

SQL> select THREAD#, SEQUENCE#, COMPLETION_TIME , DELETED from gv$archived_log where DEST_ID = 1 and DELETED = 'NO' order by THREAD#, SEQUENCE#;

   THREAD#  SEQUENCE# COMPLETIO DEL
---------- --------- -------- --
         1      14271 31-MAR-13 NO
         1      14272 31-MAR-13 NO
         1      14273 31-MAR-13 NO
         1      14274 31-MAR-13 NO

${ORACLE_HOME}/bin/rman target / catalogrman102/cat@rmandb.snt.bst.bls.com

RMAN>  run { restore archivelog from logseq=14170 until logseq=14270; }