BACKUP ARCHIVELOG with DELETE INPUT or DELET all..

season0891發表於2014-03-07

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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章