This content has been marked as final. Show 15 replies
Did I understand your problem right:
You have old backups in the recovery area, but no more information about them in the recovery catalog.
Therefore DELETE commands won't help.
These old backups consume too much space in the recovery area now.
You can register all files inside the recovery area with the RMAN command CATALOG RECOVERY AREA
Then DELETE what you want to.
"Don't believe it, test it!"
I have another 3 databases in the same host using the same recovery area destination.
All 4 databases in the same host have this value;
I want to double check with you if I run "catalog recovery area" command from one database, this command doesn't catalog also the files that belong to the other 3 databases?
SQL> show parameter db_rec NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string +FLASH_DG
It should not. On my system for example the FRA is
But each database has its own folder under "/u01/app/oracle/flash_recovery_area/"
So if I run "catalog recovery area" it will only do the database I'm connected with.
If you have to catalog multiple files in a directory you can use "catalog start with"
RMAN> catalog start with '/u01/app/oracle/backuparea' noprompt;
Good your help. Can I instead delete the FRA directory files from ASM? OR it must be deleted from RMAN-?
I want to delete those as RMAN doesn't know anything about them and delete expired or obsolete doesn't delete them ..
ASMCMD> cd +FLASH_DG/DB1/BACKUPSET ASMCMD> ls 2013_01_14/ 2013_01_15/ 2013_01_16/ 2013_01_17/ 2013_01_18/ 2013_01_19/ 2013_01_20/ 2013_01_21/ 2013_01_22/ 2013_01_23/ 2013_01_24/ 2013_01_25/ 2013_01_26/ ASMCMD>
If RMAN doesn't know anything about them then it OK to delete them.
On my system empty folders ( Oracle 11 ) stay around several days in the FRA before Oracle removes them.
For Oracle 1o refer to this note :
Flash Recovery Area Housekeeping of empty directories [ID 305970.1]
is it correct to delete them from ASMCMD like this ?
*rm -rf +FLASH_DG/DB1/BACKUPSET/2013_01_14/*
*rm -rf +FLASH_DG/DB1/BACKUPSET/2013_01_15/*
*rm -rf +FLASH_DG/DB1/BACKUPSET/2013_01_16/*
*rm -rf +FLASH_DG/DB1/BACKUPSET/2013_01_17/*
*rm -rf +FLASH_DG/DB1/BACKUPSET/2013_01_18/*
or it must be done through sqlplus?
mseberg wrote:Thank you. I am sorry not understand you; What it means it no update database if I use sqlplus?
SQL Plus Example :
ALTER DISKGROUP <DISK_GROUP_NAME>
DROP FILE '+FLASH_DG/DB1/BACKUPSET/2013_01_14/';
Beware, if you use SQL Plus but it will not update database ( if that is needed ).