Oracle Error ORA-00257: archiver is stuck. CONNECT INTERNAL only, until freed

Oracle Error Message

ORA-00257: archiver is stuck. CONNECT INTERNAL only, until freed

Reason for the Error

The ARCH procedure ran into a problem while attempting to archive a redo log file.

An very frequent Oracle database error is ORA-00257. The issue is essentially trying to notify us that the location where our archivelogs are being kept, whether it be on our ASM diskgroup, mount, local disc, or db recovery file dest location, has run out of logical or physical space.

All connections to the database are typically blocked when this problem arises, with the exception of admin access, to allow the DBA to resolve it.

In most circumstances, this is readily fixable, and the procedures listed below show you just how to do so.

Solution

There are 2 options that you can look at to fix this error

  • When the destination device does not have enough storage space to hold the redo log file, this error may occur.
  • Verify that the initialization parameter ARCHIVE LOG DEST is properly set in the initialization file. For further information about the issue, it could be useful to look over the archiver trace file.