ORA-00257 archiver error. Connect internal only, until freed

// *Cause: The archiver process received an error while trying to archive
// a redo log. If the problem is not resolved soon, the database
// will stop executing transactions. The most likely cause of this
// message is the destination device is out of space to store the
// redo log file.
// *Action: Check archiver trace file for a detailed description
// of the problem. Also verify that the
// device specified in the initialization parameter
// ARCHIVE_LOG_DEST is set up properly for archiving.

This error occurs when the archive log destination has got full and archiver process cannot flush redo log file to disk. The database will not be able to execute any transactions. The best way is to take backup of the archivelogs and free the disk space where archivelogs reside.

Category: Database

Tags:

Leave a Reply

Article by: Shadab Mohammad