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:
'X:\ORADATA\DEV\REDO\REDO01.LOG'

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.

 Solution:-

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
above.

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

Comments

Popular posts from this blog

PostgreSQL pgBadger

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

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

PostgreSQL Pgbadger Installation On Linux

PostgreSQL Database startup / shutdown /restart