理解RMAN backup database plus archivelog命令
相關文章:
《理解RMAN backup database plus archivelog delete all input命令》http://space.itpub.net/?uid-23135684-action-viewspace-itemid-661575
官方描述:
Backing Up Logs with BACKUP ... PLUS ARCHIVELOG
You can add archived redo logs to a backup of other files by using the BACKUP ...
PLUS ARCHIVELOG clause. Adding BACKUP ... PLUS ARCHIVELOG causes RMAN to do the following:
1. Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command.
2. Runs BACKUP ARCHIVELOG ALL. Note that if backup optimization is enabled, then RMAN skips logs that it has already backed up to the specified device.
3. Backs up the rest of the files specified in BACKUP command.
4. Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command.
5. Backs up any remaining archived logs generated during the backup.This guarantees that datafile backups taken during the command are recoverable to a consistent state.To back up archived redo logs with BACKUP ... PLUS ARCHIVELOG:
After starting RMAN, run the BACKUP ... PLUS ARCHIVELOG command at the RMAN prompt . This example backs up the database and all archived logs:
RMAN> BACKUP DEVICE TYPE sbt
DATABASE PLUS ARCHIVELOG;
轉載自:http://bkeep.blog.163.com/blog/static/1234142902009744926822/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23135684/viewspace-747999/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- recover database using backup controlfile理解Database
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- rman備份archivelog出現ORA-19625Hive
- rman 還原歸檔日誌(restore archivelogRESTHive
- Crunchy PostgreSQL database backup via pgo commandSQLDatabaseGo
- Flashback database必須要有之前的archivelog嗎?DatabaseHive
- Using V$BACKUP_ASYNC_IO / V$BACKUP_SYNC_IO to Monitor RMAN PerformanceORM
- RMAN restore validate database報ORA-19693RESTDatabase
- Converting Oracle Database from Linux to Windows using RMANOracleDatabaseLinuxWindows
- RMAN-03009: failure of backup command on ORA_DISK_1 channelAI
- 使用RMAN複製資料庫 active database資料庫Database
- PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.16.00.00 in TARGET database isSQLPackageRESTDatabase
- 【RMAN】Oracle rman 常用命令參考Oracle
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another NoRESTDatabase
- RMAN正確地刪除Archivelog以及設定有備庫的歸檔刪除策略Hive
- RMAN命令LIST操作總結
- 透過RMAN備份standby database成功恢復還原Database
- RMAN中的 debug調式命令
- [重慶思莊每日技術分享]-ORA-1142 signalled during: ALTER DATABASE END BACKUPDatabase
- 【RMAN】Oracle12c以後rman 備份恢復命令參考Oracle
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid不同UXDatabaseOracle
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid相同UXDatabaseOracle
- Oracle OCP(58):ARCHIVELOG 管理OracleHive
- 【RMAN】Oracle使用rman將11.2.0.4資料庫遷移至Oracle12c命令參考Oracle資料庫
- PG 自動刪除archivelogHive
- 【轉】恢復archivelog介紹Hive
- 我們在講的 Database Plus,到底能解決什麼樣的問題?Database
- 1.3.3.5.1. SQL*Plus 連線命令語法SQL
- md_backup
- 【主流技術】Mybatis Plus的理解與應用MyBatis
- ORA-19599 When Backing up an Archivelog that is CorruptHive
- Abp框架之執行Update-Database 命令系列錯誤框架Database
- 【RMAN】RMAN備份至ASMASM
- 理解 go mod init 命令Go
- 理解shell的eval命令
- 【DG】備庫RMAN還原方式搭建DG(不使用duplicate命令)
- Oracle 11G RAC複製備庫RMAN-03002 RMAN-05501 RMAN-03015 RMAN-03009 RMAN-10038Oracle
- 【RMAN】RMAN的備份保留策略