19815, 00000, "WARNING: %s of %s bytes is %s%% used, and has %s remaining bytes available." // *Cause: DB_RECOVERY_FILE_DEST is running out of disk space. // *Action: One of the following: // 1. Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE. // 2. Backup files to tertiary device using RMAN. // 3. Consider changing RMAN retention policy. // 4. Consider changing RMAN archivelog deletion policy. // 5. Delete files from recovery area using RMAN.
Mohammed Taj wrote:Ok, I've set the ORACLE_SID, and connected to the instance and catalog.
You have following choices to free up space from flash recovery area:
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.
This is the warning message saying you don't have free space in FRA (parameter) either Increase the area or following the above mention solution.
user4487322 wrote:Please do not hijack someone else's thread, even if it looks like it's the same issue.
my data base hangs because of this issue.RMAN backup destination (local drive) was full.could you help me to modify my RMAN scripts so my drive will not get filled by having many backups.like to delete the previous days backup before taking a new backup.