rman中obsolete&expired

目录

obsolete

expired

---

这两个概念容易搞混，单独记录下

obsolete

超过备份策略期限的将标记为obsolete，过期的

CONFIGURE RETENTION POLICY TO REDUNDANCY 3; -- 3份
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS; -- 3天
CONFIGURE RETENTION POLICY CLEAR; --     还原默认

一些处理命令：

report obsolete ;  --根据你当前的保留策略 列出那些不需要的
delete noprompt obsolete ;--删除不需要的备份

expired

expired官网解释如下：

A backup whose status in the RMAN repository is EXPIRED,
which means that the backup was not found. RMAN marks backups and copies as expired
when you run a CROSSCHECK command and the files are absent or inaccessible.

比如直接在OS上删除了备份文件，rman将标记为expired

crosscheck backup ;  --检查备份是否有效；
delete noprompt expired backup;  ---删除失效的备份；

crosscheck archivelog all; -- 检查归档
delete noprompt expired archivelog all;--删除失效的归档备份；