ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

The Problem

You are receiving the error message:

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

You log into the database and try to archive the redo log files and get another error:

sys@TEST> archive log all;

ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

The Solution

alter system set log_archive_dest_state_1=’ENABLE’ scope=both;

sys@TEST> archive log all;

If you are having problems logging onto the database and are receiving the ORA-00257: archiver error. Connect internal only, until freed error message, you can read about how to fix that.

Like it, share it...

Category: Database Config