RMAN 中delete exipired 和 delete obsolete 的差別

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

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;

}

版權聲明：原創作品，如需轉載，請注明出處。否則将追究法律責任

本文轉自    鵬愛   51CTO部落格，原文連結:http://blog.51cto.com/pengai/1896081