设置保留最近的7次备份
RMAN> configure retention policy to redundancy 3; 保留三分备份
RMAN> configure retention policy to recovery window of 7 days; 备份策略保留7天内的备份
查看过期的RMAN备份
RMAN> report obsolete;
遍历检索备份集
RMAN> crosscheck backup;
查看所有RMAN备份
RMAN> list backup;
删除过期RMAN备份
RMAN> delete obsolete;
删除介质中不存在的备份信息
RMAN> delete expired backup；
遍历检索归档信息
crosscheck archivelog all；
删除作废的备份信息
delete expired archivelog all；
删除7天前的归档
delete archivelog all completed before 'sysdate-7';
删除1小时前的归档
delete archivelog all completed before 'sysdate-1/24'