Backup And Recovery User's Guide-從RMAN開始-維護RMAN備份-刪除過期的備份
DELETE命令會從磁碟或磁帶刪除備份和拷貝,在控制檔案庫中更新檔案的狀態為DELETED
(如果使用catalog,還會從recovery catalog中刪除相應的記錄)
如果你是互動地執行RMAN,並且沒有指定NOMPROMPT選項,則DELETE命令會顯示檔案列表,在刪除之前要求確認。
RMAN> delete obsolete;
RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 using channel ORA_DISK_1 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Archive Log 1 06-JUL-13 /u01/app/oracle/fast_recovery_area/TESTDB12/archivelog/2013_07_06/o1_mf_1_9_8xkf4h9k_.arc Backup Set 1 06-JUL-13 Backup Piece 1 06-JUL-13 /u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_nnndf_TAG20130706T192144_8xk9n8of_.bkp Backup Set 3 06-JUL-13 Backup Piece 3 06-JUL-13 /u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_annnn_TAG20130706T202136_8xkf4jno_.bkp
Do you really want to delete the above objects (enter YES or NO)? y deleted archived log archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB12/archivelog/2013_07_06/o1_mf_1_9_8xkf4h9k_.arc RECID=1 STAMP=820095695 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_nnndf_TAG20130706T192144_8xk9n8of_.bkp RECID=1 STAMP=820092104 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_annnn_TAG20130706T202136_8xkf4jno_.bkp RECID=3 STAMP=820095696 Deleted 3 objects |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17013648/viewspace-1081008/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Backup And Recovery User's Guide-從RMAN開始-維護RMAN備份-cross-checking備份GUIIDEROS
- Backup And Recovery User's Guide-備份RMAN備份-使用RMAN備份備份集GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-備份資料庫-增量備份GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-備份資料庫GUIIDE資料庫
- Backup And Recovery User's Guide-備份RMAN備份-用RMAN備份映象拷貝備份GUIIDE
- Backup And Recovery User's Guide-RMAN備份概念-備份保留期策略-過期備份的批量刪除GUIIDE
- Backup And Recovery User's Guide-備份RMAN備份-關於備份的備份GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-備份資料庫-典型的備份選項GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-RMAN操作報表-列表顯示備份GUIIDE
- Backup And Recovery User's Guide-備份RMAN備份-備份保留期對備份的備份的影響GUIIDE
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-RMAN備份的目的GUIIDE資料庫
- Backup And Recovery User's Guide-備份RMAN備份-備份集的多重拷貝GUIIDE
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-為RMAN備份指定TAGGUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-為RMAN備份指定格式GUIIDE資料庫
- Backup And Recovery User's Guide-RMAN備份概念-備份保留期策略GUIIDE
- Backup And Recovery User's Guide-RMAN備份概念-增量備份GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-驗證資料庫檔案和備份GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-使用RMAN備份控制檔案GUIIDE資料庫
- Backup And Recovery User's Guide-RMAN備份概念-備份保留期策略-備份冗餘GUIIDE
- Backup And Recovery User's Guide-RMAN備份概念-RMAN備份的多個拷貝-備份的備份GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-備份資料庫-備份處於歸檔模式的資料庫GUIIDE資料庫模式
- Backup And Recovery User's Guide-從RMAN開始-RMAN操作報表-資料庫檔案和備份報告GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-進行壓縮備份GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-練習:對資料庫進行增量備份GUIIDE資料庫
- Backup And Recovery User's Guide-RMAN備份概念-RMAN備份的多個拷貝GUIIDE
- Backup And Recovery User's Guide-RMAN備份概念-備份undo(備份集加密)GUIIDE加密
- Backup And Recovery User's Guide-從RMAN開始-備份處於非歸檔模式的資料庫GUIIDE模式資料庫
- Backup And Recovery User's Guide-使用RMAN備份歸檔重做日誌GUIIDE
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-指定備份輸出選項GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-使用RMAN備份歸檔重做日誌GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-使用RMAN備份資料庫檔案GUIIDE資料庫
- Backup And Recovery User's Guide-RMAN備份概念-備份集-備份集和備份片GUIIDE
- Backup And Recovery User's Guide-RMAN備份概念-增量備份-累積增量備份GUIIDE
- Backup And Recovery User's Guide-RMAN備份概念-增量備份-差異增量備份GUIIDE
- Backup And Recovery User's Guide-RMAN備份概念-增量備份-多級增量備份GUIIDE
- Backup And Recovery User's Guide-RMAN備份概念-聯機備份和備份模式GUIIDE模式
- Backup And Recovery User's Guide-RMAN備份概念-備份片的檔名GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-指令碼化RMAN操作GUIIDE指令碼