Oracle 11g RMAN備份-備份標籤
--備份映象 backup as copy.... copy datafile... --備份集 backup database... backup tablespace... backup datafile... --檢查所有歸檔日誌 MAN> crosscheck archivelog all;
released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=26 device type=DISK validation succeeded for archived log archived log file name=/archive1/1_93_813665348.dbf RECID=1 STAMP=823320816 validation succeeded for archived log archived log file name=/archive2/1_93_813665348.dbf RECID=2 STAMP=823320816 ..... --備份所有歸檔日誌 RMAN> backup archivelog all;
Starting backup at 2013-08-14 04:30:04 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=93 RECID=2 STAMP=823320816 input archived log thread=1 sequence=94 RECID=8 STAMP=823322447 input archived log thread=1 sequence=95 RECID=9 STAMP=823322447 input archived log thread=1 sequence=96 RECID=12 STAMP=823322448 channel ORA_DISK_1: starting piece 1 at 2013-08-14 04:30:09 channel ORA_DISK_1: finished piece 1 at 2013-08-14 04:30:16 piece handle=/pooldisk02/backup03/1eoh8dih_1_1 tag=TAG20130814T043008 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=1 RECID=14 STAMP=823323373 input archived log thread=1 sequence=2 RECID=15 STAMP=823323515 input archived log thread=1 sequence=4 RECID=18 STAMP=823328120 input archived log thread=1 sequence=5 RECID=20 STAMP=823328120 input archived log thread=1 sequence=6 RECID=21 STAMP=823328120 channel ORA_DISK_1: starting piece 1 at 2013-08-14 04:30:16 channel ORA_DISK_1: finished piece 1 at 2013-08-14 04:30:17 piece handle=/pooldisk02/backup03/1foh8dio_1_1 tag=TAG20130814T043008 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=1 RECID=24 STAMP=823349716 input archived log thread=1 sequence=2 RECID=26 STAMP=823363531 input archived log thread=1 sequence=3 RECID=28 STAMP=823363532 input archived log thread=1 sequence=4 RECID=30 STAMP=823363534 input archived log thread=1 sequence=5 RECID=32 STAMP=823363729 input archived log thread=1 sequence=6 RECID=34 STAMP=823363769 input archived log thread=1 sequence=7 RECID=36 STAMP=823363777 input archived log thread=1 sequence=8 RECID=37 STAMP=823363948 input archived log thread=1 sequence=9 RECID=39 STAMP=823363951 input archived log thread=1 sequence=10 RECID=42 STAMP=823363954 input archived log thread=1 sequence=11 RECID=43 STAMP=823364155 input archived log thread=1 sequence=12 RECID=45 STAMP=823364156 input archived log thread=1 sequence=13 RECID=47 STAMP=823364158 input archived log thread=1 sequence=14 RECID=50 STAMP=823364525 input archived log thread=1 sequence=15 RECID=52 STAMP=823364546 input archived log thread=1 sequence=16 RECID=53 STAMP=823365806 input archived log thread=1 sequence=17 RECID=56 STAMP=823367914 input archived log thread=1 sequence=18 RECID=57 STAMP=823384872 input archived log thread=1 sequence=19 RECID=60 STAMP=823392030 input archived log thread=1 sequence=20 RECID=61 STAMP=823408208 channel ORA_DISK_1: starting piece 1 at 2013-08-14 04:30:18 channel ORA_DISK_1: finished piece 1 at 2013-08-14 04:30:43 piece handle=/pooldisk02/backup03/1goh8dip_1_1 tag=TAG20130814T043008 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25 Finished backup at 2013-08-14 04:30:43
Starting Control File and SPFILE Autobackup at 2013-08-14 04:30:43 piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823408243_90pml4cv_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 2013-08-14 04:30:46
|
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30633755/viewspace-2127655/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11g RMAN備份-增量備份Oracle
- Oracle 11g RMAN備份-一致備份Oracle
- Oracle 11g RMAN備份-基本操作Oracle
- oracle之rman備份Oracle
- Oracle RMAN 增量備份Oracle
- oracle rman備份命令Oracle
- 【轉】Oracle rman備份Oracle
- Oracle裡邏輯備份、物理備份、Rman備份的區別Oracle
- Oracle 11G 備份與恢復 使用RMAN建立備份集舉例Oracle
- Oracle備份及備份策略及基於Linux下 Oracle 備份策略(RMAN)OracleLinux
- Backup And Recovery User's Guide-備份RMAN備份-使用RMAN備份備份集GUIIDE
- Oracle 11g RMAN multiplexing 備份指令碼Oracle指令碼
- Oracle RMAN備份實戰Oracle
- Oracle OCP(60):RMAN 備份Oracle
- oracle RMAN備份指令碼Oracle指令碼
- 揭祕ORACLE備份之----RMAN之二(備份方式)Oracle
- RMAN說,我能備份(9)--RMAN增量備份與備份保留策略
- Backup And Recovery User's Guide-備份RMAN備份-用RMAN備份映象拷貝備份GUIIDE
- oracle rman備份驗證和備份進度監控Oracle
- Oracle RMAN中全備份與0級備份區別Oracle
- 【原】Oracle學習系列—資料庫備份—RMAN備份Oracle資料庫
- rman備份和增量備份指令碼指令碼
- RMAN說,我能備份(14)--實戰RMAN備份
- [Oracle] rman備份指令碼(2)Oracle指令碼
- ORACLE RMAN備份及還原Oracle
- Oracle備份之RMAN工具(四)Oracle
- Oracle備份之RMAN工具(三)Oracle
- Oracle備份之RMAN工具(二)Oracle
- Oracle備份之RMAN工具(一)Oracle
- oracle rman備份指令碼收集Oracle指令碼
- RMAN說,我能備份(3)--RMAN全庫備份和表空間備份
- rman 備份策略
- RMAN備份原理
- oracle聯機熱備份的原理,及rman增量備份原理Oracle
- Oracle聯機熱備份的原理及rman增量備份原理Oracle
- Backup And Recovery User's Guide-備份RMAN備份-關於備份的備份GUIIDE
- Backup And Recovery User's Guide-RMAN備份概念-RMAN備份的多個拷貝-備份的備份GUIIDE
- exp備份和rman備份的區別