ORA-00257: archiver error

Let’s have look at the post of error’s solving steps.

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

Or

ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

Symptoms:

A 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 the 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

Today’s thought

“Nothing you wear is more important than your smile. ” By Connie Stevens

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp