Wednesday, April 28, 2010

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 the 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.