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