ORA-00257:archiver error

Question

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?

Answer 1

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.

Answer 2

ORA-00257:archiver error is occured when your archivelog reached the FRA limit. So you have to clear the archivelogs or you may increase the FRA limit.

To clear the archivelogs, connect to the command prompt and follow steps below:

rman target /
RMAN> delete archivelog all;

It will ask for confirmation and you have to give 'yes'.