oracle 10g rman备份与恢复之一(四)
s: AVAILABLE Compressed: NO Tag: TAG20130420T025250
Piece Name: /oracle/ora10g/flash_recovery_area/WOLF/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T025250_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
backup set（备份集）
backup piece （备份片）
0级备份和全备份几乎一样，唯一的区别是全备份不能作为一级备份的基础。
参考：
增量备份0级与全备份都是全备份,但是增量备份0级使用rman备份的话就只备份了used block,而全备份备份了used and unused block
总结一下,二者有两个地方不同
1、全备份不能被用作1级增量备份的基础
2、使用rman备份的时候,全备份备份了used and unused block,0级使用rman备份的话就只备份了used block
http://www.2cto.com/database/201304/205041.
html
backup incremental level=0 database；
RMAN> backup incremental level=0 database；
Starting backup at 20-4月 -13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: starting incremental level 0 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/2013_04_20/o1_mf_nnnd0_TAG20130420T032742_8q4jvgyw_.bkp tag=TAG20130420T032742 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:05:36
Finished backup at 20-4月 -13
Starting Control File and SPFILE Autobackup at 20-4月 -13
piece handle=/oracle/ora10g/flash_recovery_area/WOLF/autobackup/2013_04_20/o1_mf_s_813209598_8q4k5yqq_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 20-4月 -13
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18 Full 529.59M DISK 00:04:53 20-4月 -13
BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20130420T025250
Piece Name: /oracle/ora10g/flash_recovery_area/WOLF/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T025250