ORA-19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used

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;

Leave a Reply