Hello,
My database version is 11.2.0.3.0 , Oracle Linux 6. We use ASM to store FRA.
Because, We had some backup issues 3 days ago, we needed to uncatalog the database and catalog it again to the recovery catalog.
SInce then backups arfe running fine until we start getting the following error;
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
I know I have the following options to fix the issue;
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, 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?