Backing Up Logs with BACKUP … PLUS ARCHIVELOG
You can add archived redo logs to a backup of other files by the BACKUP … PLUS ARCHIVELOG clause.Adding BACKUP … PLUS ARCHIVELOG causes RMAN to do the following:
- Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command.
- Runs BACKUP ARCHIVELOG ALL. Note that if backup optimization is enabled,then RMAN skips logs that it has alreadly backed up to the specified device.
- Backs up the rest of the files specified in BACKUP command.
- Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command.
- Backs up any remaining archived logs generated during the backup.
This guarantees that datafile backups taken during the command ared recoverable to a consistent state.
e.g.
RMAN> BACKUP DEVICE TYPE sbt DATABASE PLUS ARCHIVELOG;
Note: If backup optimization is enabled,then RMAN skips backups of archived logs that have alreadly been backed up to the specified device.[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25834554/viewspace-1054413/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-19599 When Backing up an Archivelog that is CorruptHive
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- Backing up the tailAI
- 理解RMAN backup database plus archivelog命令DatabaseHive
- Backing Up Individual Tablespaces with RMAN
- Backing Up Server Parameter Files with RMANServer
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- Backing Up Control Files with RMAN
- backup database plus archivelog 不同寫法導致備份集位置不同...DatabaseHive
- backup database plus archivelog 不同寫法導致備份集位置不同問題DatabaseHive
- ''Sbt Error = 7011, Errno = 959'' Error When Backing Up To TapeError
- crosscheck archivelog all;crosscheck backup of區別ROSHive
- BACKUP ARCHIVELOG with DELETE INPUT or DELET all..Hivedelete
- Oracle 11g RMAN備份-RMAN的backup database plus archivelog命令背後的操作OracleDatabaseHive
- backup archivelog delete input 與delete all input 區別Hivedelete
- RMAN database plus archivelog實現順序DatabaseHive
- [20180228]archivelog backup?log switch?Hive
- recover database using backup controlfile利用archivelog files.DatabaseHive
- backup archivelog like 報rman-20242錯誤處理過程Hive
- oracle10g rac(rhel4)_rman備份歸檔出錯_backup archivelog allOracleHive
- netbakcup備份時遇到 status 6: the backup failed to back up the requested files 問題解決AI
- Restore ArchivelogRESTHive
- Delete Dataguard ArchivelogdeleteHive
- 配置ARCHIVELOG 模式Hive模式
- wake up
- Level Up
- housekeep arch logs (tested on AIX)AI
- Extents in Materialized Views and Their Logs (18)ZedView
- Materialized View Logs (190)ZedView
- rman restore archivelog logRESTHive
- [zt] crosscheck archivelog allROSHive
- 轉至archivelog模式Hive模式
- day day up
- www/wwwroot/storage/logs" and its not b
- How Logs Work On MySQL With InnoDB TablesMySql
- flush logs時做的操作
- Oracle OCP(58):ARCHIVELOG 管理OracleHive
- Archivelog & Noarchivelog mode in RMANHive