0.删除之前通常先进行检查
RMAN> crosscheck copy;
RMAN> crosscheck backup;
RMAN> crosscheck backupset;
RMAN> crosscheck archivelog all;
1.删除过期备份。当使用RMAN命令执行备份操作时,RMAN会根据备份冗余策略确定备份是否过期。
RMAN> delete obsolete;
2.删除无效备份。首先执行CROSSCHECK命令核对备份集,如果发现备份无效(比如备份对应的数据文件损坏或丢失),RMAN会将该备份集标记为 EXPIRED状态。要删除相应的备份记录,可以执行DELETE EXPIRED BACKUP命令:
RMAN> delete expired backup;
3.删除EXPIRED副本:
RMAN> delete expired copy;
4.删除特定备份集:
RMAN> delete backupset 19;
5.删除特定备份片:
RMAN> delete backuppiece 'd:/backup/demo_19.bak';
6.删除特定映像副本:
RMAN> delete datafile copy 'd:/backup/demo_19.bak';
7.删除所有备份集:
RMAN> delete backup;
8.删除所有映像副本:
RMAN> delete copy;
9.在备份后删除输入对象:
RMAN> backup archivelog all delete input;
RMAN> delete backupset 22 format = "d:/backup/%u.bak" delete input;