oracle 10g rman备份与恢复之一(五)
_8q4gt34k_.bkp
List of Datafiles in backup set 18
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 Full 476267 20-4月 -13 /oracle/ora10g/oradata/wolf/system01.dbf
2 Full 476267 20-4月 -13 /oracle/ora10g/oradata/wolf/undotbs01.dbf
3 Full 476267 20-4月 -13 /oracle/ora10g/oradata/wolf/sysaux01.dbf
4 Full 476267 20-4月 -13 /oracle/ora10g/oradata/wolf/users01.dbf
5 Full 476267 20-4月 -13 /oracle/ora10g/oradata/wolf/rmanwolf.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19 Full 6.80M DISK 00:00:01 20-4月 -13
BP Key: 19 Status: AVAILABLE Compressed: NO Tag: TAG20130420T025747
Piece Name: /oracle/ora10g/flash_recovery_area/WOLF/autobackup/2013_04_20/o1_mf_s_813207467_8q4h3cvp_.bkp
Control File Included: Ckp SCN: 476395 Ckp time: 20-4月 -13
SPFILE Included: Modification time: 20-4月 -13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20 Incr 0 529.64M DISK 00:05:25 20-4月 -13
BP Key: 20 Status: AVAILABLE Compressed: NO Tag: TAG20130420T032742
Piece Name: /oracle/ora10g/flash_recovery_area/WOLF/backupset/2013_04_20/o1_mf_nnnd0_TAG20130420T032742_8q4jvgyw_.bkp
List of Datafiles in backup set 20
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 0 Incr 477469 20-4月 -13 /oracle/ora10g/oradata/wolf/system01.dbf
2 0 Incr 477469 20-4月 -13 /oracle/ora10g/oradata/wolf/undotbs01.dbf
3 0 Incr 477469 20-4月 -13 /oracle/ora10g/oradata/wolf/sysaux01.dbf
4 0 Incr 477469 20-4月 -13 /oracle/ora10g/oradata/wolf/users01.dbf
5 0 Incr 477469 20-4月 -13 /oracle/ora10g/oradata/wolf/rmanwolf.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
21 Full 6.80M DISK 00:00:00 20-4月 -13
BP Key: 21 Status: AVAILABLE Compressed: NO Tag: TAG20130420T033318
Piece Name: /oracle/ora10g/flash_recovery_area/WOLF/autobackup/2013_04_20/o1_mf_s_813209598_8q4k5yqq_.bkp
Control File Included: Ckp SCN: 477636 Ckp time: 20-4月 -13
SPFILE Included: Modification time: 20-4月 -13
RMAN>
一级增量备份（controlfile和spfile都是全备份，没有增量仔细观测）
backup incremental level 1 database 速度也是很慢，因为里面要和0级对比一些信息
RMAN> backup incremental level 1 database
2> ;
Starting backup at 20-4月 -13
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/oracle/ora10g/oradata/wolf/system01.dbf
input datafile fno=00003 name=/oracle/ora10g/oradata/wolf/sysaux01.dbf
input datafile fno=00002 name=/oracle/ora10g/oradata/wolf/undotbs01.dbf
input datafile fno=00005 name=/oracle/ora10g/oradata/wolf/rmanwolf.dbf
input datafile fno=00004 name=/oracle/ora10g/oradata/wolf/users01.dbf
channel ORA_DISK_1: starting piece 1 at 20-4月 -13
channel ORA_DISK_1: finished piece 1 at 20-4月 -13
piece handle=/oracle/ora10g/flash_recovery_area/WOLF/backupset/20