Home Privacy Policy Feedback Link to us Site Map

Oracle/PLSQL: ORA-00257 Error


Error:

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

Cause:

While trying to archive a redo log file, the ARCH process encountered an error.

Action:

The options to resolve this Oracle error are:
  1. This error can be caused when the destination device does not have enough storage space to store the redo log file.
  2. Check that the initialization parameter ARCHIVE_LOG_DEST in the initialization file is set correctly.

It may be helpful to check the archiver trace file for more details on the problem.

Note:  If this problem is not resolved, Oracle will stop executing transactions.