ORA-00308: Cannot Open Archived Log — Causes, Fixes & Prevention

ORA-00308 is thrown when Oracle attempts to open an archived redo log file but cannot access it — typically because the file is missing, corrupted, or located at a different path than what Oracle expects. This error commonly surfaces during database recovery operations, LogMiner sessions, or Data Guard Redo Apply processes. Left unresolved, it can halt recovery completely and cause extended downtime.

Top 3 Causes

1. Archived Log File Is Missing or Physically Deleted

The most frequent cause is that archived logs were deleted directly at the OS level (e.g., using rm ) instead of through RMAN, leaving Oracle's control file or catalog pointing to files that no longer exist.

-- Check for archived logs Oracle expects but cannot find SELECT NAME , SEQUENCE # , STATUS , DELETED FROM V $ ARCHIVED_LOG WHERE STATUS = 'A' AND DELETED = 'NO' ORDER BY SEQUENCE # DESC ;

-- In RMAN: crosscheck and clean up expired entries CROSSCHECK ARCHIVELOG ALL ;…