Database Backup and Recovery (MOSC)

MOSC Banner

ORA-19809: limit exceeded for recovery files - During RMAN backup

edited Oct 25, 2010 1:11AM in Database Backup and Recovery (MOSC) 6 commentsAnswered
 

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center