Question: I am running Oracle Apps and getting a
ORA-00257: archiver error. Connect internal only, until
Answer: The oerr utility says this
about the ORA-00257 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 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.
The Oracle ARCH background process is responsible for taking the redo
logs from the online redo log file system and writing them to the flat file
ADRCI cannot create archive log file in Oracle Applications.