Delete old ASM files
markr3Mar 7 2008 — edited Mar 8 2008Due to an improper setting in the control_file_record_keep_time parameter, I have a bunch of old backup sets that are on an ASM array. Unfortunately, the array is now about 75% full and I need to clean it up before it is completely full.
These files are no longer listed with any of the commands in RMAN and the only way I've been able to find them is through the web based Oracle Enterprise Manager and going to the ASM manager in there (Automatic Storage Management: +ASM_FLEXDATA > Disk Group: FRA Files tab). Unfortunately, it only lets me delete 1 file at a time and it'll take quite a while to delete everything.
Is there a sql statement or something that would identify all these files and allow me to delete them? On the ASM management screen, they are in a folder called BACKUPSET and then subfoldered by date.
Thanks in advance for any help on this issue.