ORA-00257:archiver error, connect internal only until freed

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

First check  in alert log

Following is error is 

Errors in file u01oracleproduct11.2.0diagrdbmsTESTPRODtestprodtracetest_arc1_1010.trc


ORA-16038: log 3 sequence# 1459 cannot be archived

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 3 thread 1: ‘u01oracleoradataTESTPRODredo03.LOG’

Cause of this message is because archive log file destination was changed or someone deleted/moved the archive log files manually using OS commands.

Use “DELETE EXPIRED ARCHIVELOG ALL” will alleviate the VALIDATION FAILED messages.


ARC1: Failed to archive thread 1 sequence 1459 (1809)

ARCH: Archival stopped, error occurred. Will continue retryi



How to resolve ORA-00257 errors

Solution:

1.first check the archive log file location


 i ) SQL> archive log list;

Database log mode Archive Mode 

Automatic archival Enabled 

Archive Destination USE_DB_RECOVERY_FILE_DEST 

Oldest online log sequence 384 

Next log sequence to archive 386 

Current log sequence 386


  ii ) show parameter db_recovery_file_dest;

2. If get location , then removed unwanted old files


check du -sch

remove unwanted file rm -rh <filename >

archive log file stored in FLASHBACK_RECOVERY_AREA

check the size of the

Also get the size of the db_recovery_file_dest

show parameter db_recovery_file_dest_size; 


and also check the RMAN BACKUP details

RMAN> crosscheck archivelog all;


RMAN> delete expired archivelog all;
 
 
If using flashback recovery area, then u can check the usage 

SQL>show parameter db_recovery_file_dest_size; 

db_recovery_file_dest_size=100G


SQL> alter system set db_recovery_file_dest_size=150G  scope=both;

The issue has been resolved

 
 

 
 

 

Leave a Comment

Your email address will not be published. Required fields are marked *