理解RMAN backup database plus archivelog delete all input命令
相關文章:
《理解RMAN backup database plus archivelog命令》http://space.itpub.net/?uid-23135684-action-viewspace-itemid-747999
RMAN> run {
2> backup as compressed backupset incremental level 1 database plus archivelog delete all input;
3> }//RMAN備份指令碼
Starting backup at 28-APR-10
#切換線上日誌(sql 'alter system archive log current';)
current log archived//發生日誌切換
#備份之前所有的歸檔日誌
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=33 recid=6 stamp=717527999 //這是剛剛歸檔的日誌
channel ORA_DISK_1: starting piece 1 at 28-APR-10
channel ORA_DISK_1: finished piece 1 at 28-APR-10
piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_annnn_TAG20100428T172000_5xhvxkcy_.bkp tag=TAG20100428T172000 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)//刪除輸入的歸檔日誌
archive log filename=/u01/app/oracle/flash_recovery_area/YTHDB/archivelog/2010_04_28/o1_mf_1_33_5xhvxhjl_.arc recid=6 stamp=717527999
Finished backup at 28-APR-10
#備份資料檔案
Starting backup at 28-APR-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=/dev/rdcdb_data01
input datafile fno=00006 name=/dev/rdcdb_data02
input datafile fno=00007 name=/dev/rdcdb_data03
input datafile fno=00008 name=/dev/rdcdb_data04
input datafile fno=00009 name=/dev/rdcdb_data05
input datafile fno=00010 name=/dev/rdcdb_data06
input datafile fno=00011 name=/dev/rdcdb_data07
input datafile fno=00012 name=/dev/rdcdb_data08
input datafile fno=00013 name=/dev/rdcdb_data09
input datafile fno=00014 name=/dev/rdcdb_data10
input datafile fno=00015 name=/dev/rdcdb_data11
input datafile fno=00016 name=/dev/rdcdb_data12
input datafile fno=00017 name=/dev/rdcdb_data13
input datafile fno=00018 name=/dev/rdcdb_data14
input datafile fno=00019 name=/dev/rdcdb_data15
input datafile fno=00020 name=/dev/rdcdb_data16
input datafile fno=00021 name=/dev/rdcdb_data17
input datafile fno=00022 name=/dev/rdcdb_data18
input datafile fno=00001 name=/dev/rdcdb_system01
input datafile fno=00023 name=/dev/rdcdb_data19
input datafile fno=00003 name=/dev/rdcdb_sysaux01
input datafile fno=00002 name=/dev/rdcdb_undotbs01
input datafile fno=00004 name=/dev/rdcdb_user
channel ORA_DISK_1: starting piece 1 at 28-APR-10
channel ORA_DISK_1: finished piece 1 at 28-APR-10
piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_nnnd1_TAG20100428T172003_5xhvxqn1_.bkp tag=TAG20100428T172003 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
#備份控制檔案和SPFILE(AUTOBACKUP OFF)
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 28-APR-10
channel ORA_DISK_1: finished piece 1 at 28-APR-10
piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_ncsn1_TAG20100428T172003_5xhvxv6b_.bkp tag=TAG20100428T172003 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 28-APR-10
Starting backup at 28-APR-10
#再次切換線上日誌(sql 'alter system archive log current';)
current log archived//發生日誌切換
#備份執行備份命令期間產生的歸檔日誌
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=34 recid=7 stamp=717528012//這是剛剛歸檔的日誌
channel ORA_DISK_1: starting piece 1 at 28-APR-10
channel ORA_DISK_1: finished piece 1 at 28-APR-10
piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_annnn_TAG20100428T172012_5xhvxy7k_.bkp tag=TAG20100428T172012 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)//刪除輸入的歸檔日誌
archive log filename=/u01/app/oracle/flash_recovery_area/YTHDB/archivelog/2010_04_28/o1_mf_1_34_5xhvxwgz_.arc recid=7 stamp=717528012
Finished backup at 28-APR-10
命令中的關鍵字all個人理解有2層含義:
1.表示當前歸檔日誌之前的所有日誌。所以我們在備份執行要先加入一句crosscheck archivelog all;以免在比對老的歸檔時發現沒有而報錯。
2.如果有多個歸檔的目的地,表示所有的歸檔目的地,在執行刪除歸檔日誌的時候才會在所有的目的地上全部刪除。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31520497/viewspace-2156763/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- recover database using backup controlfile理解Database
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- rman 還原歸檔日誌(restore archivelogRESTHive
- rman備份archivelog出現ORA-19625Hive
- Crunchy PostgreSQL database backup via pgo commandSQLDatabaseGo
- Flashback database必須要有之前的archivelog嗎?DatabaseHive
- Using V$BACKUP_ASYNC_IO / V$BACKUP_SYNC_IO to Monitor RMAN PerformanceORM
- Converting Oracle Database from Linux to Windows using RMANOracleDatabaseLinuxWindows
- RMAN restore validate database報ORA-19693RESTDatabase
- 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
- TypeError: TF_SessionRun_wrapper: expected all values in input dict to be ndarrayErrorSessionAPP
- duplicate遇到RMAN-05535: warning: All redo log files were not defined
- RMAN命令LIST操作總結
- 透過RMAN備份standby database成功恢復還原Database
- RMAN中的 debug調式命令
- 理解BERT Transformer:Attention is not all you need!ORM
- <七>深入理解new和delete的原理delete
- [重慶思莊每日技術分享]-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
- 【轉】恢復archivelog介紹Hive
- PG 自動刪除archivelogHive
- 【RMAN】Oracle使用rman將11.2.0.4資料庫遷移至Oracle12c命令參考Oracle資料庫
- Linux命令curl去操作delete去刪除資源Linuxdelete
- 我們在講的 Database Plus,到底能解決什麼樣的問題?Database
- MySQL防止delete命令刪除資料的兩種方法MySqldelete
- 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