We are taking RMAN full backup on disk every day. But right now we don’t have enough space on RMAN backup mount point. So we want to delete all AVAILABLE valid RMAN backup by RMAN command.
Please guide to delete all AVAILABLE valid RMAN backup by RMAN command.
Edited by: Fazlul Kabir Mahfuz on May 13, 2013 11:06 AM
Haven't you tried :
I suggest that you also run
which will list backups that are expected to be present on disk but not found. You can then delete those with
DELETE EXPIRED BACKUP
Hemant K Chitale
Delete all backups:
delete obsolete backup;
are you using FRA ? If you have ArchivelogMode, you can delete archives:
delete archivelog all;
delete archivelog from logseq [numer] to logseq [number]
You can do it by manually delete the backups and archivelogs from OS location. Then use below commands
It will give status as EXPIRED for backups which are valid but not available at OS level.
RMAN>delete expired backup;
Delete all the backups whose status are EXPIRED from database level.
Similarly for archivelogs
RMAN>crosscheck archivelog all;
RMAN>delete expired archivelog all;