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