GGATE ABBENDED: ORA-00308: Cannot Open Archived Log

Hi all!
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.

or

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 '/...

SOLUTION:

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 &current_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.

Cheers!