RMAN进行备份恢复(十一)
ta/orcl/users01.dbf
5 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_DATA01.DBF
6 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_IDX01.DBF
7 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/oradata/orcl/tbs_data.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 6.89M DISK 00:00:03 12-JUN-13
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20130612T125054
Piece Name: /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_ncsnf_TAG20130612T125054_8vhzxlf2_.bkp
Control File Included: Ckp SCN: 13229464106126 Ckp time: 12-JUN-13
SPFILE Included: Modification time: 12-JUN-13
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 2.30G DISK 00:06:17 12-JUN-13
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20130612T125054
Piece Name: /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_nnndf_TAG20130612T125054_8vhzkgdt_.bkp
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf
2 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf
3 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/oradata/orcl/sysaux01.dbf
4 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/oradata/orcl/users01.dbf
5 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_DATA01.DBF
6 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_IDX01.DBF
7 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/oradata/orcl/tbs_data.dbf
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 6.89M DISK 00:00:03 12-JUN-13
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20130612T125054
Piece Name: /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_ncsnf_TAG20130612T125054_8vhzxlf2_.bkp
Control File Included: Ckp SCN: 13229464106126 Ckp time: 12-JUN-13
RMAN> list backup of spfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 6.89M DISK 00:00:03 12-JUN-13
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20130612T125054
Piece Name: /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_ncsnf_T