202: The backup retention policy is configured as RECOVERY WINDOW 2. You
executed the following
command in Recovery Manager (RMAN) against your database:
RMAN> REPORT OBSOLETE;
What would you see in the output?
A.a list of all the expired backups and copies
B.a list of all those files that have been deleted in the last two days
C.a list of all those files that have been recovered within the last two
days
D.a list of backups and copies that are outside the range covered by the
current retention policy
Answer: D
常常混淆RMAN中EXPIRED和OBSOLETE两个状态，其实如果理解了两者是如何产生
的，区别也就出来了。
对于EXPIRED状态的产生，与crosscheck命令是密切相关的，RMAN通过crosscheck命令
检查备份是否存在于备份介质上，如果不存在，则状态由AVAILABLE改为EXPIRED。
可以用delete (noprompt) expired backup of controlfile来删除catalog中expired的备份信息：
对于obsolete状态，是针对MAN备份保留策略来说的，超过了这个保留策略的备份，会
被标记为obsolete，但其状态依旧为AVAILABLE，我们可以使用report obsolete来查看已废弃
的备份。
要真正地删除废弃的备份，可以使用delete noprompt obsolete命令（noprompt是指无需确
认）：RMAN> delete noprompt obsolete;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718257/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
