RMAN中deleteexipired和deleteobsolete的区别

delete expired
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

创新互联建站2013年至今,先为兴文等服务建站,兴文等地企业,进行企业商务咨询服务。为兴文企业网站制作PC+手机+微官网三网同步一站式服务解决您的所有建站问题。

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.

delete expired删除的是那些本来RMAN以为存在但是实际上在磁盘或者磁带上已经被删除了的信息,删除的只是RMAN资料库中的记录;delete obsolete则删除旧于备份保留策略定义的备份数据同时也更新RMAN资料库以及控制文件。

 

=========================================================================================

EG:

#delete obsolete and expired backup and archivelog
run {
delete noprompt obsolete;
crosscheck archivelog all;
delete noprompt expired archivelog all;
crosscheck backup;
delete noprompt expired backup;
}


网页题目:RMAN中deleteexipired和deleteobsolete的区别
当前URL:http://www.hxwzsj.com/article/gdpdei.html

其他资讯

Copyright © 2025 青羊区翔捷宏鑫字牌设计制作工作室(个体工商户) All Rights Reserved 蜀ICP备2025123194号-14
友情链接: 高端网站设计推广 专业网站设计 手机网站制作 泸州网站建设 成都网站设计 网站制作 成都网站建设 网站建设 商城网站建设 成都网站建设推广 重庆网站设计 成都做网站建设公司 重庆网站建设 成都网站建设公司 成都网站设计 成都商城网站建设 企业网站设计 四川成都网站设计 重庆手机网站建设 H5网站制作 成都营销网站制作 攀枝花网站设计