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的区别
文章起源:http://csruizhi.cn/article/gdpdei.html

其他资讯

Copyright © 2007-2024 成都优众联杰科技有限公司 All Rights Reserved 蜀ICP备2024116266号
友情链接: 成都网站建设公司 成都模版网站建设 重庆企业网站建设 手机网站制作 网站建设 企业网站建设 成都网站制作 成都网站建设 重庆网站制作 网站设计制作 成都网站制作 网站制作报价 高端定制网站设计 自适应网站设计 网站制作公司 企业网站设计 重庆网站建设 网站建设推广 网站设计制作报价 重庆外贸网站建设 成都网站制作 网站制作公司