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.

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.

Option 1: Give more space in DB_RECOVERY_FILE_DEST Example:

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

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

Tagged:

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.