Search code examples
oracleoracle9iora-00257

ORA-00257:archiver error

When I try connecting to my database, I get the following error.

ORA-00257:archiver error. Connect internal only until freed.

Till yesterday, the database was pretty functional.

Any workaround?

Solution

  • In SQL*Plus, can you

    SQL> show parameter log_archive
    • If LOG_ARCHIVE_START is FALSE, you'll want to set it to TRUE.
    • If LOG_ARCHIVE_DEST points to an invalid directory, you'll want to change it to point to a valid directory.