Oracle Database Discussions

Hi all,
DB_VERSION:10.2.0.4
OS_VERSION:Windows 2003 server

I got following error message in the alert log :

ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 99.79% used, and has 4587520 remaining bytes available.

Tue Jan 04 09:23:37 2011
************************************************************************
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.
************************************************************************


Though the alter gave me the casue and the solution over the same, i do not understand ,How to deal with the db_recovery_file_dest parameter.

As earlier, the size was 2GB , and when i encountered above message i increased the size to 4GB ,but again it was full :-(

The RMAN backup goes to tape on daily basis.

Following is the output of SHOW ALL ;

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'J:\RMAN_BACKUP\backups\%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'J:\RMAN_BACKUP\backups\DB_%U.%r';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'J:\RMAN_BACKUP\BACKUPS\SNCDB.ORA';

rman.rcv

run
{
change archivelog all crosscheck;
crosscheck backup;
backup database plus archivelog;
backup as copy current controlfile;
}
exit

rman_del_obsolete.rcv

allocate channel for maintenance type disk;
delete force noprompt obsolete device type disk;
exit

Any suggetion on how can i deal with the flashback area ? As i can not delete these RMAN backup pieces generating in Flash_Area_Location manually ..
Do i need to PURGE it on regualar basis ??

Regards

Edited by: user12000301 on Jan 10, 2011 1:52 AM