# ORA-00257: archiver error. Connect internal only, until freed

**Code:** `ORA-00257` · **Category:** SQL · **Seen on:** Oracle, Linux

The archive log destination is full, so the database can't archive redo logs and blocks work.

## Meaning

Free space in the archive destination or the Fast Recovery Area: delete obsolete archive logs with RMAN (`DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1'` after backup), increase `db_recovery_file_dest_size`, and fix the backup job that normally removes them.

## Common causes

- Archive destination or FRA full
- RMAN backups failing so logs aren't deleted
- `db_recovery_file_dest_size` too small
- Heavy redo generation
- Disk full

## Quick fix

1. Check `v$recovery_file_dest` usage
2. Back up and delete archived logs with RMAN
3. Increase the FRA size or disk

## Detailed fix by platform

### SQL

1. 

```sql
SELECT space_limit/1024/1024 mb_limit, space_used/1024/1024 mb_used FROM v$recovery_file_dest;
RMAN> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
```


## How to diagnose

1. **FRA** — Full?
2. **RMAN** — Backing up?
3. **Redo** — Spiking?

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/ora-00257-archiver-error-connect-internal-only)
