RMAN備份資料檔案+控制檔案+歸檔日誌
RMAN> backup database include current controlfile plus archivelog;
Starting backup at 09-APR-14
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=11 recid=9 stamp=844197561
input archive log thread=1 sequence=12 recid=10 stamp=844206816
input archive log thread=1 sequence=13 recid=11 stamp=844219881
input archive log thread=1 sequence=14 recid=12 stamp=844259634
input archive log thread=1 sequence=15 recid=13 stamp=844363185
input archive log thread=1 sequence=16 recid=15 stamp=844396883
channel ORA_DISK_1: starting piece 1 at 09-APR-14
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=1 sequence=3 recid=2 stamp=844124125
channel ORA_DISK_2: starting piece 1 at 09-APR-14
channel ORA_DISK_3: starting archive log backupset
channel ORA_DISK_3: specifying archive log(s) in backup set
input archive log thread=1 sequence=17 recid=14 stamp=844396868
input archive log thread=1 sequence=18 recid=16 stamp=844396885
input archive log thread=1 sequence=19 recid=17 stamp=844396887
input archive log thread=1 sequence=20 recid=18 stamp=844396888
input archive log thread=1 sequence=21 recid=19 stamp=844396888
input archive log thread=1 sequence=22 recid=20 stamp=844400067
channel ORA_DISK_3: starting piece 1 at 09-APR-14
channel ORA_DISK_3: finished piece 1 at 09-APR-14
piece handle=/u02/rman/SAFE/set/disk3/1/SAFE_0np591e4_1_1.bak tag=TAG20140409T033427 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:17
channel ORA_DISK_3: starting archive log backupset
channel ORA_DISK_3: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=1 stamp=844124109
input archive log thread=1 sequence=5 recid=3 stamp=844124132
input archive log thread=1 sequence=6 recid=4 stamp=844124144
input archive log thread=1 sequence=7 recid=5 stamp=844124772
input archive log thread=1 sequence=8 recid=6 stamp=844124773
input archive log thread=1 sequence=9 recid=7 stamp=844124785
input archive log thread=1 sequence=10 recid=8 stamp=844124795
channel ORA_DISK_3: starting piece 1 at 09-APR-14
channel ORA_DISK_3: finished piece 1 at 09-APR-14
piece handle=/u02/rman/SAFE/set/disk3/1/SAFE_0op591el_1_1.bak tag=TAG20140409T033427 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:10
channel ORA_DISK_1: finished piece 1 at 09-APR-14
piece handle=/u02/rman/SAFE/set/disk1/SAFE_0lp591e4_1_1.bak tag=TAG20140409T033427 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:57
channel ORA_DISK_2: finished piece 1 at 09-APR-14
piece handle=/u02/rman/SAFE/set/disk2/SAFE_0mp591e4_1_1.bak tag=TAG20140409T033427 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:01:58
Finished backup at 09-APR-14
Starting backup at 09-APR-14
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/SAFE/system01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/SAFE/users01.dbf
channel ORA_DISK_1: starting piece 1 at 09-APR-14
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=/u01/app/oracle/oradata/SAFE/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/SAFE/undotbs01.dbf
channel ORA_DISK_2: starting piece 1 at 09-APR-14
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_3: starting piece 1 at 09-APR-14
channel ORA_DISK_3: finished piece 1 at 09-APR-14
piece handle=/u02/rman/SAFE/set/disk3/1/SAFE_0rp591hu_1_1.bak tag=TAG20140409T033627 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:01:07
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_3: starting piece 1 at 09-APR-14
channel ORA_DISK_3: finished piece 1 at 09-APR-14
piece handle=/u02/rman/SAFE/set/disk3/1/SAFE_0sp591k9_1_1.bak tag=TAG20140409T033627 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:21
channel ORA_DISK_2: finished piece 1 at 09-APR-14
piece handle=/u02/rman/SAFE/set/disk2/SAFE_0qp591hr_1_1.bak tag=TAG20140409T033627 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:03:27
channel ORA_DISK_1: finished piece 1 at 09-APR-14
piece handle=/u02/rman/SAFE/set/disk1/SAFE_0pp591hr_1_1.bak tag=TAG20140409T033627 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:17
Finished backup at 09-APR-14
Starting backup at 09-APR-14
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=23 recid=21 stamp=844400444
channel ORA_DISK_1: starting piece 1 at 09-APR-14
channel ORA_DISK_1: finished piece 1 at 09-APR-14
piece handle=/u02/rman/SAFE/set/disk1/SAFE_0tp591ps_1_1.bak tag=TAG20140409T034044 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 09-APR-14
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29802484/viewspace-1418453/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rman全庫備份備份歸檔日誌檔案
- 備份歸檔日誌檔案
- 不完全恢復(資料檔案備份--新建表空間--控制檔案備份--日誌歸檔檔案)
- RMAN備份與恢復(新舊控制檔案及歸檔日誌)測試
- 控制檔案/歸檔日誌
- RMAN說,我能備份(4)--RMAN備份資料檔案和控制檔案
- Oracle RMAN 不完全恢復(只有資料檔案備份,丟失歸檔日誌備份)Oracle
- RMAN備份與恢復(新舊控制檔案及歸檔日誌)測試(敘)
- 使用logmnr,在RMAN備份檔案中恢復備份的歸檔日誌檔案進行分析
- RMAN備份歸檔日誌多份 %c
- RMAN備份歸檔日誌指令碼指令碼
- RMAN說,我能備份(5)--RMAN備份歸檔檔案
- 用RMAN備份歸檔日誌時檢查歸檔日誌是否存在
- rman備份-(1) 利用備份級恢復資料檔案和控制檔案
- rman備份但丟失一個資料檔案,但有歸檔備份
- Oracle使用備份檔案集恢復歸檔日誌Oracle
- 沒備份,歸檔日誌存在,丟失資料檔案的恢復
- 備份歸檔日誌
- Backup And Recovery User's Guide-備份資料庫-備份歸檔重做日誌檔案GUIIDE資料庫
- 驗證控制檔案、歸檔檔案、不同BLOCK大小的資料檔案對應的RMAN備份集不在同一PIECEBloC
- oracle中移動控制檔案、資料檔案、日誌檔案Oracle
- 歸檔模式有備份丟失控制檔案和資料檔案後恢復模式
- oracle資料庫移動資料檔案、日誌檔案和控制檔案Oracle資料庫
- RMAN恢復表空間,資料檔案,歸檔檔案,控制檔案等介紹
- Oracle設定多個歸檔路徑生成多份歸檔日誌,Rman備份時也只備份其中的一份歸檔日誌Oracle
- RMAN備份整庫和歸檔日誌的方法
- oracle rman備份歸檔日誌需要先切換日誌嗎Oracle
- rman備份後為什麼要同時備份歸檔日誌
- 在Oracle中移動資料檔案、控制檔案和日誌檔案Oracle
- 備份之歸檔重做日誌備份
- 資料檔案重建,從歸檔日誌中回退資料
- 歸檔日誌大小 與使用rman 備份後的歸檔日誌產生的備份集大小的關係
- rman恢復資料庫--用備份的控制檔案資料庫
- 第5章:從開啟的資料庫備份與恢復之備份歸檔日誌檔案資料庫
- 【備份恢復】恢復 丟失已歸檔重做日誌檔案
- Backup And Recovery User's Guide-備份歸檔重做日誌檔案GUIIDE
- 非歸檔資料庫RMAN備份資料庫
- 日誌檔案和歸檔管理