ORA-16014: log 6 sequence# 8614 not archived, no available destinations

Last night one of my team member gave me a call that we have got a space issue on one of our servers. I requested him to delete some old files and then he managed to free up some space.

The next day during the generation of Health Check Report we came across the following error in Alert Log:

ORA-16014: log 6 sequence# 8614 not archived, no available destinations
ORA-00312: online log 6 thread 1: '/opt/oracle/oradata/cdqa/redo06a.log'
ORA-00312: online log 6 thread 1: '/opt/oracle/oradata/cdqa/redo06b.log'

The Archiving processes was automated and we just need to set the log archive dest parameter again so as to point out to the correct location.

We realized that Automated Archiving is not happening properly and to correct the issue did the following :


alter system set log_archive_dest_1="location=/opt/oracle/oradata/cdqa reopen=60";

Here reopen tells the Archiving process to try reopening the failed Archive Destinations after 60 seconds.

Cheers
Aashish