设置保留最近的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'
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29320885/viewspace-1735845/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29320885/viewspace-1735845/