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

Or

ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

Symptoms:

User cannot connect to the database.

SQL> conn user/password

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

 

SQL> archive log all;

ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

 

Cause:

The flash_recovery_are is full.

To perform archiving one destination is allowed (log_archive_min_succeed_dest= 1).

 

Solution:

Check space limit and space used in flash_recovery_area.

SELECT * FROM V$RECOVERY_FILE_DEST;

Option 1:

Give more space in DB_RECOVERY_FILE_DEST

Example:

SQL> alter system set db_recovery_file_dest_size=5G;

 

Option 2:

Avoid the situation set if dest1 is full then archiving will carry out to the alternate dest2:

log_archive_dest_1='LOCATION=use_db_recovery_file_dest NOREOPEN ALTERNATE=LOG_ARCHIVE_DEST_2'

log_archive_dest_2='LOCATION=/other_dest_for_archiving'

log_archive_dest_state_1='enable'

log_archive_dest_state_2='alternate'

db_recovery_file_dest='/u01/app/oracle/product/11.2.0/db_1/flash_recovery_area'

db_recovery_file_dest_size=3G