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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- Oracle OCP(58):ARCHIVELOG 管理OracleHive
- 【轉】恢復archivelog介紹Hive
- PG 自動刪除archivelogHive
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- md_backup
- ORA-19599 When Backing up an Archivelog that is CorruptHive
- rman 還原歸檔日誌(restore archivelogRESTHive
- rman備份archivelog出現ORA-19625Hive
- JavaScript deleteJavaScriptdelete
- URLSearchParams delete()delete
- FormData delete()ORMdelete
- Using V$BACKUP_ASYNC_IO / V$BACKUP_SYNC_IO to Monitor RMAN PerformanceORM
- Flashback database必須要有之前的archivelog嗎?DatabaseHive
- Python -- raw_input() and input() -- ACMPythonACM
- Map delete() 方法delete
- WeakMap delete() 方法delete
- WeakSet delete() 方法delete
- SQL__DELETESQLdelete
- Set delete() 方法delete
- JavaScript delete用法JavaScriptdelete
- URLSearchParams delete() 方法delete
- git delete and revertGitdelete
- MySQL Delete PHPMySqldeletePHP
- input
- DBMS_BACKUP_RESTORE.DBMS_BACKUP_RESTORE用於特殊情況下的恢復REST
- BACKUP PENDING狀態的解除
- milvus-backup安裝部署
- recover database using backup controlfile理解Database
- Veritas Backup Exec™ 21.3 Multilingual (Windows)Windows
- OUTLOOK - Unable to Delete Meetingsdelete
- 740. Delete and Earndelete
- [20190228]Backup Restore Throttle sleep.txtREST
- PostgreSQL xlog格式之no backup full pageSQL
- PostgreSQL xlog格式之backup full pageSQL
- clickhouse-backup(RPM方式安裝)
- Mac Backup Guru for Mac(備份工具)Mac
- Crunchy PostgreSQL database backup via pgo commandSQLDatabaseGo
- 【YashanDB知識庫】archivelog磁碟滿導致資料庫abnormalHive資料庫ORM