PROBLEM:

Application log shows below error and users are unable to connect to the database.

0RA-00257:archiver error, connect internal only until freed
ORA-16014:log 1 sequence# 280 not archived, no available destinations
ORA-00312:online log 1 thread 1:’/data/oradata/orcl/redo01.log’

SOLUTION:

This error comes, when the archive destination is full and there is no space to accommodate new archivelogs.

Check archive dest location.

There are different solution for this.

OPTION 1:  Try to delete old archive logs to free up space.

OPTION 2:  Change the archive log location:

In case you can’t delete the archive logs from existing location, then we can change the archive dest to a new mount point.

After implementing any one of the solutions, the database may take few minutes to resume archiving and normal operation.