Ok, so this is one of the most common issues for GGate administration. How to solve it? Easy thing.
First let’s understand what it means: It means the redologs don’t have the required information (assuming integrated) and you have already deleted archivelogs the extract needs. Why? Probably because you already backed up those archivelogs and they were not needed for the database anymore.
Unfortunately we don’t have any kind of ARCHIVELOG DELETION POLICY to guarantee extracts had already read it, like we have for Dataguard. So, what can we do?
Restore the missing archivelogs.
But first let’s confirm on the errors. Some examples:
ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, ext1.prm: Opening ASM file +ARCH/2_11055_742755632.dbf in DBLOGREADER mode: (308) ORA-00308: cannot open archived log '+ARCH/2_11055_742755632.dbf' ORA-17503.
ERROR OGG-01028 Oracle GoldenGate Capture for Oracle,ext1.prm: Getting attributes for ASM file +ARCH/2_86720_716466928.dbf, SQL : (15056) ORA-15056: additional error message ORA-15173: entry '2_86720_716466928.dbf' does not exist in directory '/...
Restore all archive logs starting from recovery checkpoint until the current checkpoint and restart the extract:
1) Query to abbended Extract find needed SCN:
GGSCI (greporasrv) 1> info all GGSCI (greporasrv) >info EXT1 EXTRACT EXT1 Last Started 2018-01-27 10:50 Status STARTING Checkpoint Lag 00:00:02 (updated 01:08:06 ago) Process ID 1577 Log Read Checkpoint Oracle Integrated Redo Logs 2015-01-27 12:59:39 SCN 2975.3281272024 (12780808977624)
2) Locate the archivelogs related to this SCN:
SQL> select name, thread#, sequence#, status, first_time, next_time, first_change#, next_change# from v$archived_log where 12780808977624 between first_change# and next_change#;
Also, take the current_scn:
SQL> col CURRENT_SCN format 999999999999999 SQL> select current_scn from v$database;
3) Ensure that all required archivelogs are exist in backups
RMAN> list backup of archivelog all;
4) Restore all the archive log files starting from SCN:
RMAN> restore archivelog from scn 12780808977624 until scn ¤t_scn;
5) Confirm that all archives are restored.:
ASMCMD> lsdg ASMCMD> cd ARCH/ ASMCMD> ls
6) Start Abbended Extracts and monitor Lag
GGSCI (greporasrv) 2> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED EXT1 00:00:02 08:48:00 EXTRACT RUNNING PUMP1 00:00:00 00:00:00 EXTRACT RUNNING REP1 00:00:02 00:00:04 GGSCI (greporasrv) 3> start extract EXT1 Sending START request to MANAGER ... EXTRACTEXT1 starting GGSCI (greporasrv) 5> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT1 08:48:25 00:00:01 EXTRACT RUNNING PUMP1 00:00:00 00:00:04 EXTRACT RUNNING REP1 00:00:02 00:00:04
7) Monitor Extract: Ensure no errors in log file and lag comes down.
Hope it helps.