ORA-19809: limit exceeded for recovery files - During RMAN backup
We have a 2 node 11g R2 RAC database with following settings related to FRA
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 100G
Current database size is
SQL> select sum(bytes)/1024/1024/1024 GB from dba_Data_files;
GB
------
191.53
We have nightly RMAN backup configured as follows (with a 1 day retention window)
run
{
delete noprompt obsolete;
backup database plus archivelog delete input;
}
While running the RMAN backup, we got the following error:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 53477376 bytes disk space from 107374182400 limit
Querying FRA
SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
0