Monday, October 27, 2014

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

Error Code
ORA-00257

Description
Archiver error. Connect internal only, until freed.

Cause
Possible cause of this error is, 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
To fix this issue, 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.

reference

No comments:

Post a Comment