Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

ORA-00257: archiver error,ORA-16014 No Available Destinations --oracle

ORA-16014 No Available Destinations
By Robert Jackson | 0 Comments
ora-16014 no available destinations
I arrived at work today to find a few emails in my inbox saying that one of the
development environments appeared to be down. My first check was to try logging
on as one of the application users, which failed with the error:

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

I’ve written about this ORA-00257 error message previously, so read that for
some of the details, but in this post I would like to cover a little part this
I missed from that previous post. This part is related to the following error:

SQL> alter system archive log current;
alter system archive log current
ERROR at line 1:
ORA-16014: log 1 sequence# 161 not archived, no available destinations
ORA-00312: online log 1 thread 1:

SQL> alter system archive log all;
alter system archive log all
ERROR at line 1:
ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST
The first error above gives you a clue as to what the problem is, and this 2nd error
above really lets you know the problem; the destination that you are trying to write
out to is not available, is the short answer. This is because after a certain number
of tries the log archive destination that you have configured gets set to unavailable
 and therefore nothing can be written to it, even if you have cleared enough space.


SQL> alter system set log_archive_dest_state_1='ENABLE' scope=both;

System altered.

SQL> alter system archive log all;

System altered.
It’s just a simple case of re-enabling the archiving destination to let the database
know that it is valid and enabled. That’s what I did with the alter system command

Note: Check to make sure you are enabling the correct log_archive_dest. Remember,
you must enclose the ENABLE value with single quotation marks.


Popular posts from this blog

rman interview and scenario based questions and answer and also rman(backup and recovery) discussions panel

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

PostgreSQL Introduction