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:
'D:\ORACLE\FLASH_RECOVERY_AREA\RTNE\ONLINELOG\O1_MF_4_5BWL0XDH_.LOG'
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

SQL> show parameter LOG_ARCHIVE_MIN_SUCCEED_DEST

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
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.