Thursday, September 11, 2008

If the db recovery file dest fills up.

************************************************************************
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.
************************************************************************

rman
connect target /
crosscheck archivelog all;
delete expired archivelog all;

delete archivelog all completed before 'sysdate -10';

delete noprompt force archivelog all completed before "sysdate-3" backed up 2 times to device type 'SBT_TAPE';