I know I have the following options to fix the issue;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03015: error occurred in stored script daily_backup RMAN-03009: failure of backup command on d4_disk_backup channel at 01/25/2013 19:38:40 ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 37702598656 bytes disk space from 5497558138880 limit RMAN-03009: failure of backup command on d4_disk_backup channel at 01/25/2013 19:38:15 ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 37959499776 bytes disk space from 5497558138880 limit
But, since we did catalogued this DB 3 days ago, Recovery catalogue doesn 't know anything about previous backups taken so delete expired didn't helped much. Also, the flash recovery area is getting full and we cannot add disk space to ASM. How can I fix the problem?
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.
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
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>
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 ).