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 |