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來刪除)
change backup of database tag='whole_db' unavailable;
change backup of database like '%DB%' 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-51640/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29987/viewspace-51640/