RMAN delete expired & delete obsolete

数据库管理：理解'expired'与'obsolete'的区别

最新推荐文章于 2025-02-05 13:48:44 发布

最新推荐文章于 2025-02-05 13:48:44 发布 · 131 阅读

本文详细解析了数据库管理中'expired'与'obsolete'的概念，阐述了它们在备份和副本记录状态上的不同，并讨论了如何使用RMAN命令删除过期备份和不再需要的文件。

先看官方文档解释：

delete exipired

If you run CROSSCHECK, and if RMAN cannot locate the files, then it updates their records in the RMAN repository to EXPIRED status. You can then use the DELETE EXPIRED command to remove records of expired backups and copies from the RMAN repository

delete obsolete

The RMAN DELETE command supports an OBSOLETE option, which deletes backups that are no longer needed to satisfy specified recoverability requirements. You can delete files obsolete according to the configured default retention policy, or another retention policy that you specify as an option to the DELETE OBSOLETE command. As with other forms of the DELETE command, the files deleted are removed from backup media, deleted from the recovery catalog, and marked as DELETED in the control file

简言之、就是“在不在”和“要不要”的区别

expired 是不在了、obsolete 是不要了

不在并不一定是不需要的
不需要的也并不一定不在

数据库管理的时候、痛苦的是不需要的还在、比这更痛苦的是、需要的已经不在了