利用dbms_backup_restore恢复数据库(二)
1: starting piece 1 at 22-SEP-13
channel ORA_DISK_1: finished piece 1 at 22-SEP-13
piece handle=/u/oracle/flash_recovery_area/ORCL2/backupset/2013_09_22/o1_mf_annnn_TAG20130922T000600_93vk29cw_.bkp tag=TAG20130922T000600 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 22-SEP-13
Starting backup at 22-SEP-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oradata/orcl2/system01.dbf
input datafile file number=00002 name=/oradata/orcl2/undotbs01.dbf
input datafile file number=00003 name=/oradata/orcl2/sysaux01.dbf
input datafile file number=00005 name=/oradata/orcl2/seven.dbf
input datafile file number=00004 name=/oradata/orcl2/users01.dbf
channel ORA_DISK_1: starting piece 1 at 22-SEP-13
channel ORA_DISK_1: finished piece 1 at 22-SEP-13
piece handle=/backup/orcl_04okeoqa_1_1 tag=TAG20130922T000738 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:05
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 22-SEP-13
channel ORA_DISK_1: finished piece 1 at 22-SEP-13
piece handle=/backup/orcl_05okeou7_1_1 tag=TAG20130922T000738 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 22-SEP-13
Starting backup at 22-SEP-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=2 RECID=24 STAMP=826762186
channel ORA_DISK_1: starting piece 1 at 22-SEP-13
channel ORA_DISK_1: finished piece 1 at 22-SEP-13
piece handle=/u/oracle/flash_recovery_area/ORCL2/backupset/2013_09_22/o1_mf_annnn_TAG20130922T000946_93vk6b6o_.bkp tag=TAG20130922T000946 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 22-SEP-13
RMAN>
查看备份文件：
[oracle@DBA2 backup]$ ls
-rw-r----- 1 oracle oinstall 1182695424 Sep 22 00:09 orcl_04okeoqa_1_1
-rw-r----- 1 oracle oinstall 10158080 Sep 22 00:09 orcl_05okeou7_1_1
orcl_04okeoqa_1_1是数据文件的备份集，orcl_05okeou7_1_1是控制文件和参数文件的备份集。
制造实验场景
删除数据文件和控制文件：
[oracle@DBA2 oradata]$ cd /oradata/orcl2/
[oracle@DBA2 orcl2]$ ls
control01.ctl redo02.log seven.dbf system01.dbf temp02.dbf users01.dbf
redo01.log redo03.log sysaux01.dbf temp01.dbf undotbs01.dbf
[oracle@DBA2 orcl2]$ rm *
[oracle@DBA2 orcl2]$ ls
[oracle@DBA2 orcl2]$ cd /u/oracle/flash_recovery_area/orcl2/
[oracle@DBA2 orcl2]$ ls
control02.ctl
[oracle@DBA2 orcl2]$ rm *
[oracle@DBA2 orcl2]$
数据文件和控制文件现已全部删除，数据库也会随之崩溃；
开始恢复
如果之前有参数文件，就用之前的参数文件，如果没有就自己手动修改init.ora文件，先将实例启动到nomount状态；
[oracle@DBA2 dbs]$ sql
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 22 00:18:50 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/u/or