Home > Database > Mysql Tutorial > body text

Rman备份中obsolete和expired的区别

WBOY
Release: 2016-06-07 17:14:56
Original
976 people have browsed it

obsolete:与retention policy相关,当备份或者副本根据保存策略而被丢弃的时候,就会被标记为该状态。比如你设置恢复窗口为7天,

obsolete:与retention policy相关,当备份或者副本根据保存策略而被丢弃的时候,就会被标记为该状态。比如你设置恢复窗口为7天,今天10号,那2号之前(包括2号)的都被认为是“过期的”。

expired:使用crosscheck对备份进行校验,当备份或者副本被存储在rman目录中,,但是并没有物理存在于备份介质上时,就会被标记为该状 态;在操作系统层删除备份集后,用crosscheck 检测后就标志为X(expired)。通常指丢失(被删除)的备份。

#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;
}

linux

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template