RMAN进行备份恢复(十二)
AG20130612T125054_8vhzxlf2_.bkp
SPFILE Included: Modification time: 12-JUN-13
--RMAN可以使用恢复预览：
RMAN> restore preview database;
Starting restore at 12-JUN-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
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
using channel ORA_DISK_1
--这里提示出错，实际上并没有问题，只是有部分日志并未归档，但是在日志文件中还是存在的。
archive logs generated after SCN 13229464105956 not found in repository
Media recovery start SCN is 13229464105956
Recovery must be done beyond SCN 13229464105956 to clear data files fuzziness
Finished restore at 12-JUN-13
--开始恢复
RMAN> restore database;
Starting restore at 12-JUN-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf
restoring datafile 00002 to /home/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /home/oracle/oracle/product/10.2.0/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /home/oracle/oracle/product/10.2.0/oradata/orcl/users01.dbf
restoring datafile 00005 to /home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_DATA01.DBF
restoring datafile 00006 to /home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_IDX01.DBF
restoring datafile 00007 to /home/oracle/oracle/product/10.2.0/oradata/orcl/tbs_data.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_nnndf_TAG20130612T125054_8vhzkgdt_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_nnndf_TAG20130612T125054_8vhzkgdt_.bkp tag=TAG20130612T125054
channel ORA_DISK_1: restore complete, elapsed time: 00:04:37
Finished restore at 12-JUN-13