Wednesday 27 June 2012

ORA-00257:archiver error


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.

In My case the device associated with ARCHIVE_LOG_DEST  was 100 % full

No comments: