Sun Application Server Startup Command: /opt/SUNWappserver/bin/asadmin start-domain --domaindir /opt/SUNWappserver/domains --user admin

Thursday, January 21, 2010

Oracle: ORA-16014: log sequence not archived, no available destinations

SQL> alter database open;
alter database open
ERROR at line 1:
ORA-16014: log 4 sequence# 3874 not archived, no available destinations
ORA-00312: online log 4 thread 1:
How to resolve this ?

Firstly, you need to ensure that the log_archive_dest_nn parameters are set up correctly.

Here we have a flash recovery area defined, so we'll just use that.

SQL> alter system set log_archive_dest_10 = 'LOCATION=USE_DB_RECOVERY_DILE_DEST';

System altered.

SQL> alter database open;

Database altered.

To set it in the spfile, use the following:

SQL> alter system set log_archive_dest_10 = 'LOCATION=USE_DB_RECOVERY_DILE_DEST' scope=spfile;

You can also set up any of the other archive log destinations to a valid one. There could be other errors caused by this, which should also point you in the right direction.

SQL> alter system archive log all;
alter system archive log all
ERROR at line 1:
ORA-16020: less destinations available than specified by


------------------------------------ ----------- ------------------------------
log_archive_min_succeed_dest integer 1

This should not be the issue, but if higher than 1, ensure that enough destinations have been set up.

Also ensure that they are all enabled.

No comments: