Oracle 11g RMAN備份-備份標籤

yuntui發表於2016-11-03
參考《Backup and recover user’s guid-2.2.4.2》,詳見之前發過的與備份恢復相關的博文。

--備份映象

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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章