Oracle error
ORA-19815
ORA-19815: WARNING: db_recovery_file_dest_size of %s bytes is %s%% used, and has %s remaining bytes available.
What usually causes it
An alert log warning that the Fast Recovery Area is filling up.
What to check first
Act before it reaches 100%: check what's using the FRA and whether backups are deleting archived logs.
Scripts that help
- Fast Recovery Area usageFRA size, used and reclaimable space, then what's using it by file type. Real used % is the number that matters: at 100% the database stops archiving…
- Archived redo generated per dayCount and size of archived logs for the last 14 days, from the local destination only so standby copies aren't double-counted. Useful for sizing the…
- RMAN backup jobs in the last 7 daysStatus, duration and output size of each RMAN job, newest first.