Greetings.
My RMAN backup failed last night:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on oem_disk_backup channel at 05/18/2010 23:05:53
ORA-19504: failed to create file "/opt/oracle/flash/<directory_name_here>/datafile/o1_mf_users_%u_.dbf"
ORA-27044: unable to write the header block of file
Linux-x86_64 Error: 28: No space left on device
When I run the following:
select * from v$flash_recovery_area_usage;
I get the following output:
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 2.7 .02 61
BACKUPPIECE .37 0 1
IMAGECOPY 77.58 44.81 22
FLASHBACKLOG 3.86 0 144
How do I identify and delete those files taking up the <tt>PERCENT_SPACE_RECLAIMABLE</tt>?
Thanks,
Jeff