BACKUP ARCHIVELOG with DELETE INPUT or DELET all..
http://blog.sina.com.cn/s/blog_5fbb16590100l56m.html
rman中backup archivelog all delete input和delete all input,還是有區別的,如果你有多個archive_dest的設定,1,2,3,4,5。後者帶著all的,能夠刪除掉所有歸檔位置的歸檔日誌,而前者不帶all的,可能無法刪除所有節點的。
4.3.7.1.2 Using BACKUP ARCHIVELOG with DELETE INPUT or DELETE ALL INPUT
You can specify the DELETE INPUT or DELETE ALL INPUT clauses for the BACKUP ARCHIVELOG command to delete archived logs after they are backed up, eliminating the separate step of manually deleting the archived redo logs. With DELETE INPUT, RMAN only deletes the specific copy of the archived redo log chosen for the backup set. With DELETE ALL INPUT, RMAN will delete each backed-up archived redo log file from all log archiving destinations.
For example, assume that you archive to /arc_dest1, /arc_dest2, and /arc_dest3, and you run the following command:
BACKUP DEVICE TYPE sbt
ARCHIVELOG ALL
DELETE ALL INPUT;
In this case RMAN backs up only one copy of each log sequence number in these directories, and then deletes all copies of any log that it backed up from the archiving destinations. If you had specified DELETE INPUT rather than DELETE ALL INPUT, then RMAN would only delete the specific archived redo log files that it backed up (for example, it would delete the archived redo log files in /arc_dest1 if those were the files used as the source of the backup, but it would leave the contents of the /arc_dest2 and /arc_dest3 intact) .
If you issue BACKUP ARCHIVELOG ALL or BACKUP ARCHIVELOG LIKE '...', and there are no archived redo log files to back up, then RMAN does not signal an error.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/90618/viewspace-1102887/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- backup archivelog delete input 與delete all input 區別Hivedelete
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- delete input 與 delete all inputdelete
- Delete Dataguard ArchivelogdeleteHive
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- 測試RMAN的backup archivelog all delete input會不會刪除還未傳輸到備庫的歸檔日誌Hivedelete
- rman 中的 delete all input 和 delete input 的區別delete
- crosscheck archivelog all;crosscheck backup of區別ROSHive
- 理解RMAN backup database plus archivelog命令DatabaseHive
- Backing Up Logs with BACKUP … PLUS ARCHIVELOGHive
- How to delete SLP after backup with storage fundationdelete
- Rman 中的delete input的用法delete
- 歸檔的備份之delete all inputdelete
- [20180228]archivelog backup?log switch?Hive
- recover database using backup controlfile利用archivelog files.DatabaseHive
- ASM 中使用RMAN delete archivelog until time刪除歸檔檔案ASMdeleteHive
- backup database plus archivelog 不同寫法導致備份集位置不同...DatabaseHive
- oracle實驗記錄 (恢復-rman操作delete(all) input )Oracledelete
- Oracle歸檔空間不足,delete archivelog all;命令失效時解決方法OracledeleteHive
- ASM+RMAN使用delete input備份日誌的問題ASMdelete
- backup database plus archivelog 不同寫法導致備份集位置不同問題DatabaseHive
- backup archivelog like 報rman-20242錯誤處理過程Hive
- RMAN delete archivelog命令刪除歸檔日誌及歸檔日誌拷貝deleteHive
- Oracle 11g RMAN備份-RMAN的backup database plus archivelog命令背後的操作OracleDatabaseHive
- oracle10g rac(rhel4)_rman備份歸檔出錯_backup archivelog allOracleHive
- Restore ArchivelogRESTHive
- 配置ARCHIVELOG 模式Hive模式
- rman restore archivelog logRESTHive
- [zt] crosscheck archivelog allROSHive
- 轉至archivelog模式Hive模式
- delete OBSOLETE 與 delete expirieddelete
- $(":input")和$("input")區別
- deletedelete
- delete 和 delete [] 的真正區別delete
- Oracle OCP(58):ARCHIVELOG 管理OracleHive
- Archivelog & Noarchivelog mode in RMANHive
- input
- delete與delete[]需要注意的地方delete