ORA-00257:Archiver Error, Connect Internal Only Until Freed and ORA-16014 and ORA-00312

Cause

The flash_recovery_area is full.

SQL>  archive log list; Database log mode Archive Mode Automatic archival Enabled Archive Destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 231 Next log sequence to archive 231 Current log sequence 233

SQL>select group#,status archived from v$log; GROUP# ARCHIVED ————  ———————— 1                INVALIDATED 2                INACTIVE 3                INACTIVE

The suggested solution to archive all fails :

SQL>archive log all; ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEEDED_DEST

The only one destination allowed (log_archive_min_succeed_dest= 1) is not able to perform the archiving.

Solution

1. Either allow more space in the DB_RECOVERY_FILE_DEST with the DB_RECOVERY_FILE_DEST_SIZE parameter  :

SQL> alter system set db_recovery_file_dest_size=3G ;

1. Or to avoid the situation once the 3Gb is full , set the following parameters so that when the dest1 is full, archiving is automatically  performed 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/10.1.0/db_1/flash_recovery_area’ db_recovery_file_dest_size=2G