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.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /archive/POCD
Oldest online log sequence     12
Next log sequence to archive   14
Current log sequence           14

There are different solution for this.

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

rman target /
delete archivelog all completed before 'sysdate-1';

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.

SQL> show parameter log_archive_dest_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      LOCATION=/archive/POCD

SQL> alter system set log_archive_dest_1='LOCATION=/dumparch/POCD' scope=both;

System altered.

SQL> show parameter log_archive_dest_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      LOCATION=/dumparch/POCD


-- Switch logfile

alter system switch logfile;

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