ORA-00257: Archiver Error ,Connect Internal Only Until Freed
Problem
when an application users using database unable to connect to the database aplication log shows the error
ORA-00257:archiver error, connect internal only untill freed
ORA-16014:log1 sequence# 280 not archived,no available destinations
ORA-00312:online log1 thread 1:'/oradata/prod/redo01.log'
Solution
This error comes ,when the archive destination is full and there is no space availability in the destination location archivelogs
Check archivelog destination location
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /archive/PROD
Oldest online log sequence 14
Next log sequence to archive 18
Current log sequence 18
There are different solution for this Error rectification
Option-1: Delete old archive logs to free up space using Rman utility
rman target /
delete archivelog all completed before 'sysdate-1';
Option-2: Change the archive log location
incase you cannot delete the archive logs from the destination location or existing location,then we can change the archive destination to some other mount point
SQL>show parameter log_achive_dest;
NAME TYPE VALUE
log_archive_dest string LOCATION =/archive/prod
SQL>alter system set log_archive_dest= 'LOCATION=/u03/backupdest/archive/prod' scope=both;
SQL>show parameter log_achive_dest;
NAME TYPE VALUE
log_archive_dest string LOCATION =u03/backupsest/archive/prod
switch log file
alter sytem switch logfile;
THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME OR SUBSCRIBE ME
