在rman中change命令允許 用戶修改備份的狀態,如果某備份當前為不可用,則在還原和恢復時不會被考慮的
1. list backup of database;
2. change backupset 2 keep forever logs; --備份集2不受冗余策略的影響永遠有效()
change backupset 2 keep until time 'sysdate+7' logs; --備份集2不受冗余策略的影響在超出正常日期7天內有效
change backupset 2 nokeep; --變更備份集2為廢棄狀態(為無效狀態可以用delete obsete來刪除)
3. delete obsolete; --刪除所有無效的備份集
4. backup database keep forever;
backup database keep unitl time "to_date('01/01/05','mm/dd/yy')";
backup database keep 5 days;
5. change backup of database tag='whole_db' unavailable;
change backup of database like '%GOLD%' unavailable;
change backupset 2 unavailable;
change backupset 2 available;
change archivelog '/cfs01/oradata/archive/2_8.log' unavailable;
change archivelog all backed up 5 times to device type disk unavailable;
change backup of database device type disk unavailable;
change backupset 2,3 delete; --刪除指定的備份集(物理刪除備份文件)
change backuppiece 3 delete; --刪除備份片3(物理刪除備份文件)
change archivelog until logseq=3 thead=1 delete;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29987/viewspace-51771/,如需转载,请注明出处,否则将追究法律责任。