oracle 10g rman备份与恢复之一(六)
13_04_20/o1_mf_nnnd1_TAG20130420T034525_8q4kwod7_.bkp tag=TAG20130420T034525 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:56
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_813210622_8q4l5yy1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 20-4月 -13
RMAN> list backupset;
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_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
BS Key Type LV Siz