ORA-19815: warning: db_recovery_file_dest_size
                                                 Last update (2008-05-31 22:14:58)
                                                                                                                   Date added (2008-05-13 16:00:30)

Summary
When the space used in the flash recovery area goes above 85% then will get the following warning in the alert log:

ORA-19815: WARNING: db_recovery_file_dest_size of 1073741824 bytes is 86.07% used

You have following choices to free up space from flash recovery area:

1. Consinder 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.
BACKUP RECOVERY AREA;
SELECT * FROM V$RECOVERY_FILE_DEST;
Other links
Enabling and disabling Archivelog mode
Unix script to avoid the 'archive directory full' error
Archivelog produced calendar
Backup calendar
Reviews
Filters
Search