ORA-19809: limit exceeded for recovery files

ORA-19809: limit exceeded for recovery files

The flash recovery area is full:

To verify this run the following query. It will show the size of the recovery area and how full it is:

set lines 100
col name format a60
select name
, floor(space_limit / 1024 / 1024) "Size MB"
, ceil(space_used / 1024 / 1024) "Used MB"
from v$recovery_file_dest
order by name
/

To fix the problem, you need to either make the flash recovery area larger, or remove some files from it.

If you have the disk space available, make the recovery area larger:

alter system set db_recovery_file_dest_size= scope=both
/

To remove files you must use RMAN.
Manually moving or deleting files will have no effect as oracle will be unaware.
The obvious choice is to backup and remove some archive log files.
However, if you usually write your RMAN backups to disk, this could prove tricky.

RMAN will attempt to write the backup to the flash recovery area...which is full.

You could try sending the backup elsewhere using a command such as this:

rman target / catalog user/pass@rmancat

run {allocate channel t1 type disk;
backup archivelog all delete input
format '//arch_%d_%u_%';
release channel t1;
}

This will backup all archive log files to a location of your choice and then remove them.