All Oracle errors
ORA-00257space

Archive log destination full

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

Why it happens

The fast recovery area (FRA) or archive log destination ran out of disk space, so archivelog mode can no longer keep up.

How to fix it

Check FRA usage (v$recovery_area_usage), delete backed-up archived logs or old RMAN backups, enlarge DB_RECOVERY_FILE_DEST_SIZE, and fix the database before normal users connect again.

A note on ORA-00257

This entry is part of a hand-curated set of ORA-, FRM-, REP- and TNS- codes that actually turn up in production Oracle estates — SQL*Plus, APEX, 19c/21c, ODP.NET apps, Oracle Forms 6i/12c and Reports included. The message text above is the canonical wording; the cause and fix are written in plain language so a developer or DBA can act without digging through pages of Oracle reference docs first.

Codes outside this list of 44 are far less common. If you hit one, the official Oracle error reference and your instance's alert or listener log remain the authoritative source.

Build custom software with us

From internal tools to full platforms — we deliver end to end.

Was this tool useful?