ORA-19804: cannot reclaim 52428800 bytes disk space from 1073741824 limit
Error:
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/15/2024 22:30:00
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 1073741824 limit
Check the reclaimable space from the recovery flash area
space_limit AS quota,
space_used AS used,
space_reclaimable AS reclaimable,
number_of_files AS files
FROM V$RECOVERY_FILE_DEST ;
Solution:
The first solution is to check the size of the allocation and increase the size.
Show parameter db_recovery_file_dest_Size;
alter system set db_recovery_file_dest_size=xG SCOPE=BOTH;
Second, DELETE for any files that have been removed with an operating system utility.
RMAN>CROSSCHECK BACKUP;
RMAN>CROSSCHECK ARCHIVELOG ALL;
RMAN>Delete expired backup;
RMAN>Delete expired archivelog all;
RMAN>Delete force obsolete;
Third, Check the retention policy and change it according to your requirements:
RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
Fourth, you can also disable if not required
Alter database FLASHBACK OFF;