ORA-00257 Error Message
Learn the cause and how to resolve the ORA-00257 error message in Oracle.
Description
When you encounter an ORA-00257 error, the following error message will appear:
- 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.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
This error can be caused when the destination device does not have enough storage space to store the redo log file.
Option #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.
No comments:
Post a Comment