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

Post Views: 1,277