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

Symptom

ORA-16014: log 1 sequence# 117 not archived, no available destinations

Solution

1. Check your disk space is still sufficient to hold the archive logs.

df -kh 

2. Connect to your Oracle SQL session and excute below command to check and confirm the archive log destination is maintained.

SQL> show parameter log_archive_dest;
NAME                             TYPE        VALUE
------------------------------   ----------- ------------------------------
log_archive_dest_1               string      location=/oracle/SID/oraarch/SIDarch

3. If the destination is not maintained, please set the destination as below,

SQL> alter system set log_archive_dest_1='location=/oracle/SID/oraarch/SIDarch';
System altered.

3. Ensure the log switch is working

SQL> alter system switch logfile;
System altered.