My Oracle Support Banner

IF:How to Resolve ORA-00257:Archiver Error (Doc ID 2014425.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Sep-2016***

Goal

 Users cannot connect to the database  due to below errors:

ORA-00257:archiver error, connect internal only until freed
ORA-16014 log %s sequence# %s not archived, no available destinations

 (OR)

0RA-00257:archiver error, connect internal only until freed
ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

 This document aims to explain how to quickly resolve these errors to avoid connection failures and/or database hang.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 When Flash Recovery Area is in use
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.