ORA-19815: WARNING: db_recovery_file_dest_size
maheshmDec 14 2010 — edited Dec 14 2010Hi,
We recently upgraded the database from 9i to 11R2 and we have enabled FASH RECOVERY AREA also.
When am checking the alert log am getting the below error
ORA-19815: WARNING: db_recovery_file_dest_size of 10737418240 bytes is 100.00% used, and has 0 remaining bytes available.
**************************************************************************
You have following choices to free up space from recovery area:
*1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,*
then consider changing RMAN ARCHIVELOG DELETION POLICY.
*2. Back up files to tertiary device such as tape using RMAN*
BACKUP RECOVERY AREA command.
*3. Add disk space and increase db_recovery_file_dest_size parameter to*
reflect the new space.
*4. Delete unnecessary files using RMAN DELETE command. If an operating*
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
But we are still using the cold backup method and not RMAN for backing up the database.
So is it possible to manually remove the old files from FASH RECOVERY AREA
SQL Output
select name,floor(space_limit / 1024 / 1024) "Size MB",ceil(space_used / 1024 / 1024) "Used MB"
from v$recovery_file_dest order by name;
NAME
--------------------------------------------------------------------------------
Size MB Used MB
---------- ----------
/fast_rec_area
10240 10240
Regards,
Mahesh