oracle 10g rman 备份与恢复 之五

海明老师第七讲

恢复控制文件，日志文件，整库恢复，单个数据文件恢复
nocatalog恢复
    控制文件丢失恢复过程
startup nomount
restore controlfile from autobackup
alter database mount
recover database
alter database open resetlogs

模拟控制文件丢失
RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down

[root@redhat wolf]# ls
control01.ctl  redo01.log  sysaux01.dbf  undotbs01.dbf
control02.ctl  redo02.log  system01.dbf  users01.dbf
control03.ctl  redo03.log  temp01.dbf
[root@redhat wolf]# mv control01.ctl control01.ctl.bak
[root@redhat wolf]# ls
control01.ctl.bak  redo01.log  sysaux01.dbf  undotbs01.dbf
control02.ctl      redo02.log  system01.dbf  users01.dbf
control03.ctl      redo03.log  temp01.dbf

连接rman管理器
[oracle@redhat ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on 星期日 4月 21 10:27:09 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database (not started)
启动数据库到nomount状态
RMAN> startup nomount;
Oracle instance started
Total System Global Area     285212672 bytes
Fixed Size                     1218992 bytes
Variable Size                 92276304 bytes
Database Buffers             188743680 bytes
Redo Buffers                   2973696 bytes
RMAN> restore controlfile from autobackup;
Starting restore at 21-4月 -13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
recovery area destination: /oracle/ora10g/flash_recovery_area
database name (or database unique name) used for search: WOLF
channel ORA_DISK_1: no autobackups found in the recovery area
autobackup search outside recovery area not attempted because DBID was not set
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/21/2013 10:28:26
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece


RMAN> restore controlfile from '/oracle/ora10g/flash_recovery_area/WOLF/backupset/2013_04_21
2> 
3> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signalled during parse
RMAN-02002: unexpected end of input file reached


还原控制文件（这里最好用全路径）
RMAN> restore controlfile from '/oracle/ora10g/flash_recovery_area/WOLF/backupset/2013_04_21/o1_mf_ncsnf_TAG20130421T095042_8q7vtb8b_.bkp';
Starting restore at 21-4月 -13
using channel ORA_DISK_1
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:05
output filename=/oracle/ora10g/oradata/wolf/control01.ctl
output filename=/oracle/ora10g/oradata/wolf/control02.ctl
output filename=/oracle/ora10g/oradata/wolf/control03.ctl
Finished restore at 21-4月 -13


查看控制文件是否恢复
[root@redhat wolf]# ls
control01.ctl      control03.ctl  redo03.log    temp01.dbf
control01.ctl.bak  redo01.log     sysaux01.dbf  undotbs01.dbf
control02.ctl      redo02.log     system01.dbf  users01.dbf
打开数据库到mount状态
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1

恢复数据库
RMAN> recover database;
Starting recover at 21-4月 -13
Starting implicit crosscheck backup at 21-4月 -13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
Crosschecked 2 objects
Finished implicit crosscheck backup at 21-4月 -13
Starting implicit crosscheck copy at 21-4月 -13
using channel ORA_DISK_1
Finished implicit crosscheck copy at 21-4月 -13
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
File Name: /oracle/ora10g/flash_recovery_area/WOLF/backupset/2013_04_21/o1_mf_ncsnf_TAG20130421T095042_8q7vtb8b_.bkp
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 2 is already on disk as file /oracle/ora10g/oradata/wolf/redo01.log
archive log filename=/oracle/ora10g/oradata/wolf/redo01.log thread=1 sequence=2
media recovery complete, elapsed time: 00:00:07
Finished recover at 21-4月 -13
启动数据库
RMAN> alter database open resetlogs;
database opened
sqlplus登录，查看数据库是否正常
[oracle@redhat ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 4月 21 10:46:37 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select * from dual;


D
-
X


=====================================================================================

日志文件的恢复

redolog file 丢失
     shutdown immediate
startup mount
alter database resetlogs

==========================================================================================

全库备份（包括控制文件，参数文件，数据文件等）

RMAN> backup database plus archivelog delete input;
Starting backup at 22-4月 -13
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=134 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=7 recid=1 stamp=789518526
input archive log thread=1 sequence=8 recid=2 stamp=789537831
input archive log thread=1 sequence=9 recid=3 stamp=789537832
input archive log thread=1 sequence=15 recid=4 stamp=790907119
input archive log thread=1 sequence=16 recid=5 stamp=790907334
input archive log thread=1 sequence=17 recid=6 stamp=790907455
input archive log thread=1 sequence=18 recid=7 stamp=812676920
input archive log thread=1 sequence=19 recid=8 stamp=812681195
input archive log thread=1 sequence=20 recid=9 stamp=812682116
input archive log thread=1 sequence=21 recid=10 stamp=812950223
input archive log thread=1 sequence=22 recid=11 stamp=813103853
input archive log thread=1 sequence=23 recid=12 stamp=813402380
channel ORA_DISK_1: starting piece 1 at 22-4月 -13
channel ORA_DISK_1: finished piece 1 at 22-4月 -13
piece handle=/opt/app/oracle/flash_recovery_area/WOLF/backupset/2013_04_22/o1_mf_annnn_TAG20130422T090629_8qbfhfrl_.bkp tag=TAG20130422T090629 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:44
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/opt/app/oracle/flash_recovery_area/WOLF/archivelog/2012_07_24/o1_mf_1_7_80yq7r4g_.arc recid=1 stamp=789518526
archive log filename=/opt/app/oracle/flash_recovery_area/WOLF/archivelog/2012_07_25/o1_mf_1_8_80zb36hh_.arc recid=2 stamp=789537831
archive log filename=/opt/app/oracle/flash_recovery_area/WOLF/archivelog/2012_07_25/o1_mf_1_9_80zb38bb_.arc recid=3 stamp=789537832
archive log filename=/oracle/arch_1_15_788004200.arc recid=4 stamp=790907119
archive log filename=/oracle/arch_1_16_788004200.arc recid=5 stamp=790907334
archive log filename=/oracle/arch_1_17_788004200.arc recid=6 stamp=790907455
archive log filename=/oracle/arch_1_18_788004200.arc recid=7 stamp=812676920
archive log filename=/oracle/arch_1_19_788004200.arc recid=8 stamp=812681195
archive log filename=/opt/app/oracle/archive/arch_1_20_788004200.arc recid=9 stamp=812682116
archive log filename=/opt/app/oracle/archive/arch_1_21_788004200.arc recid=10 stamp=812950223
archive log filename=/opt/app/oracle/archive/arch_1_22_788004200.arc recid=11 stamp=813103853
archive log filename=/opt/app/oracle/archive/arch_1_23_788004200.arc recid=12 stamp=813402380
Finished backup at 22-4月 -13


Starting backup at 22-4月 -13
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/opt/app/oracle/oradata/wolf/system01.dbf
input datafile fno=00003 name=/opt/app/oracle/oradata/wolf/sysaux01.dbf
input datafile fno=00005 name=/opt/app/oracle/oradata/wolf/wolfblock01.dbf
input datafile fno=00002 name=/opt/app/oracle/oradata/wolf/undotbs01.dbf
input datafile fno=00007 name=/opt/app/oracle/oradata/wolf/rman_wolf.dbf
input datafile fno=00006 name=/opt/app/oracle/oradata/wolf/wolf01
input datafile fno=00004 name=/opt/app/oracle/oradata/wolf/users01.dbf
channel ORA_DISK_1: starting piece 1 at 22-4月 -13
channel ORA_DISK_1: finished piece 1 at 22-4月 -13
piece handle=/opt/app/oracle/flash_recovery_area/WOLF/backupset/2013_04_22/o1_mf_nnndf_TAG20130422T091128_8qbfr0t1_.bkp tag=TAG20130422T091128 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:05:46
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 22-4月 -13
channel ORA_DISK_1: finished piece 1 at 22-4月 -13
piece handle=/opt/app/oracle/flash_recovery_area/WOLF/backupset/2013_04_22/o1_mf_ncsnf_TAG20130422T091128_8qbg2x84_.bkp tag=TAG20130422T091128 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-4月 -13


Starting backup at 22-4月 -13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=24 recid=13 stamp=813403039
channel ORA_DISK_1: starting piece 1 at 22-4月 -13
channel ORA_DISK_1: finished piece 1 at 22-4月 -13
piece handle=/opt/app/oracle/flash_recovery_area/WOLF/backupset/2013_04_22/o1_mf_annnn_TAG20130422T091723_8qbg351l_.bkp tag=TAG20130422T091723 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/opt/app/oracle/archive/arch_1_24_788004200.arc recid=13 stamp=813403039
Finished backup at 22-4月 -13
RMAN> 
RMAN> report schema;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    480      SYSTEM               YES     /opt/app/oracle/oradata/wolf/system01.dbf
2    90       UNDOTBS1             YES     /opt/app/oracle/oradata/wolf/undotbs01.dbf
3    240      SYSAUX               NO      /opt/app/oracle/oradata/wolf/sysaux01.dbf
4    5        USERS                NO      /opt/app/oracle/oradata/wolf/users01.dbf
5    100      WOLFBLOCK            NO      /opt/app/oracle/oradata/wolf/wolfblock01.dbf
6    10       WOLF                 NO      /opt/app/oracle/oradata/wolf/wolf01
7    20       RMAN_WOLF            NO      /opt/app/oracle/oradata/wolf/rman_wolf.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /opt/app/oracle/oradata/wolf/temp01.dbf
RMAN> 
模拟数据文件全部丢失
[oracle@test wolf]$ ls
control01.ctl  redo02.log  redo11.log     system01.dbf   wolfblock01.dbf
control02.ctl  redo03.log  redo12.log     temp01.dbf
control03.ctl  redo04.log  redo13.log     undotbs01.dbf
redo010.log    redo05.log  rman_wolf.dbf  users01.dbf
redo01.log     redo06.log  sysaux01.dbf   wolf01
[oracle@test wolf]$ rm -rf *.dbf
[oracle@test wolf]$ ls
control01.ctl  redo010.log  redo03.log  redo06.log  redo13.log
control02.ctl  redo01.log   redo04.log  redo11.log  wolf01
control03.ctl  redo02.log   redo05.log  redo12.log
[oracle@test wolf]$ 


RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down


SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
 
ORACLE instance started.


Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size             113247824 bytes
Database Buffers          167772160 bytes
Redo Buffers                2973696 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/opt/app/oracle/oradata/wolf/system01.dbf'


SQL> SQL> select file#,error from v$recover_file;


     FILE# ERROR
---------- -----------------------------------------------------------------
         1 FILE NOT FOUND
         2 FILE NOT FOUND
         3 FILE NOT FOUND
         4 FILE NOT FOUND
         5 FILE NOT FOUND
         7 FILE NOT FOUND


6 rows selected.


SQL> 
[oracle@test ~]$ rman target /


Recovery Manager: Release 10.2.0.1.0 - Production on 星期一 4月 22 10:05:10 2013


Copyright (c) 1982, 2005, Oracle.  All rights reserved.


connected to target database: WOLF (DBID=3753890021, not open)
RMAN> restore database;


Starting restore at 22-4月 -13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK


channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/app/oracle/oradata/wolf/system01.dbf
restoring datafile 00002 to /opt/app/oracle/oradata/wolf/undotbs01.dbf
restoring datafile 00003 to /opt/app/oracle/oradata/wolf/sysaux01.dbf
restoring datafile 00004 to /opt/app/oracle/oradata/wolf/users01.dbf
restoring datafile 00005 to /opt/app/oracle/oradata/wolf/wolfblock01.dbf
restoring datafile 00006 to /opt/app/oracle/oradata/wolf/wolf01
restoring datafile 00007 to /opt/app/oracle/oradata/wolf/rman_wolf.dbf
channel ORA_DISK_1: reading from backup piece /opt/app/oracle/flash_recovery_area/WOLF/backupset/2013_04_22/o1_mf_nnndf_TAG20130422T091128_8qbfr0t1_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/opt/app/oracle/flash_recovery_area/WOLF/backupset/2013_04_22/o1_mf_nnndf_TAG20130422T091128_8qbfr0t1_.bkp tag=TAG20130422T091128
channel ORA_DISK_1: restore complete, elapsed time: 00:05:03
Finished restore at 22-4月 -13
RMAN> recover database;


Starting recover at 22-4月 -13
using channel ORA_DISK_1


starting media recovery
media recovery complete, elapsed time: 00:00:19


Finished recover at 22-4月 -13
RMAN> alter database open;


database opened
查看日志信息
Additional information: 3
Mon Apr 22 10:07:20 2013
Full restore complete of datafile 4 /opt/app/oracle/oradata/wolf/users01.dbf.  Elapsed time: 0:00:10 
  checkpoint is 762512
Mon Apr 22 10:07:38 2013
Full restore complete of datafile 6 /opt/app/oracle/oradata/wolf/wolf01.  Elapsed time: 0:00:30 
  checkpoint is 762512
Mon Apr 22 10:07:52 2013
Full restore complete of datafile 7 /opt/app/oracle/oradata/wolf/rman_wolf.dbf.  Elapsed time: 0:00:44 
  checkpoint is 762512
Mon Apr 22 10:09:11 2013
Full restore complete of datafile 2 /opt/app/oracle/oradata/wolf/undotbs01.dbf.  Elapsed time: 0:02:04 
  checkpoint is 762512
Mon Apr 22 10:09:26 2013
Full restore complete of datafile 5 /opt/app/oracle/oradata/wolf/wolfblock01.dbf.  Elapsed time: 0:02:19 
  checkpoint is 762512
Mon Apr 22 10:11:13 2013
Full restore complete of datafile 3 /opt/app/oracle/oradata/wolf/sysaux01.dbf.  Elapsed time: 0:04:08 
  checkpoint is 762512
Mon Apr 22 10:11:52 2013
Full restore complete of datafile 1 /opt/app/oracle/oradata/wolf/system01.dbf.  Elapsed time: 0:04:47 
  checkpoint is 762512
Mon Apr 22 10:18:43 2013
db_recovery_file_dest_size of 3072 MB is 19.94% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Apr 22 10:24:40 2013
alter database recover datafile list clear
Mon Apr 22 10:24:40 2013
Completed: alter database recover datafile list clear
Mon Apr 22 10:24:40 2013
alter database recover datafile list
 1 , 2 , 3 , 4 , 5 , 6 , 7
Completed: alter database recover datafile list
 1 , 2 , 3 , 4 , 5 , 6 , 7
Mon Apr 22 10:24:40 2013
alter database recover if needed
 start
Media Recovery Start
Mon Apr 22 10:24:45 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 24 Reading mem 0
  Mem# 0 errs 0: /opt/app/oracle/oradata/wolf/redo01.log
  Mem# 1 errs 0: /oracle/redo12.rdo
Mon Apr 22 10:24:53 2013
Recovery of Online Redo Log: Thread 1 Group 2 Seq 25 Reading mem 0
  Mem# 0 errs 0: /opt/app/oracle/oradata/wolf/redo02.log
Mon Apr 22 10:24:56 2013
Media Recovery Complete (wolf)
Completed: alter database recover if needed
 start
Mon Apr 22 10:25:22 2013
alter database open
Mon Apr 22 10:25:22 2013
LGWR: STARTING ARCH PROCESSES
ARC1 started with pid=20, OS id=16105
ARC0 started with pid=19, OS id=16103
Mon Apr 22 10:25:23 2013
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC2 started with pid=21, OS id=16107
Mon Apr 22 10:25:23 2013
ARC0: STARTING ARCH PROCESSES
Mon Apr 22 10:25:23 2013
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Mon Apr 22 10:25:23 2013
ARC2: Becoming the heartbeat ARCH
Mon Apr 22 10:25:23 2013
Thread 1 opened at log sequence 25
  Current log# 2 seq# 25 mem# 0: /opt/app/oracle/oradata/wolf/redo02.log
Successful open of redo thread 1
Mon Apr 22 10:25:23 2013
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC3 started with pid=22, OS id=16109
Mon Apr 22 10:25:24 2013
SMON: enabling cache recovery
Mon Apr 22 10:25:28 2013
Successfully onlined Undo Tablespace 1.
Mon Apr 22 10:25:28 2013
SMON: enabling tx recovery
Mon Apr 22 10:25:29 2013
Re-creating tempfile /opt/app/oracle/oradata/wolf/temp01.dbf
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Mon Apr 22 10:25:40 2013
Starting background process QMNC
QMNC started with pid=23, OS id=16115
Mon Apr 22 10:25:57 2013
Completed: alter database open
[oracle@test ~]$ tail 100 /opt/app/oracle/admin/wolf/bdump/alert_wolf.log
tail: cannot open `100' for reading: No such file or directory
==> /opt/app/oracle/admin/wolf/bdump/alert_wolf.log <==
SMON: enabling tx recovery
Mon Apr 22 10:25:29 2013
Re-creating tempfile /opt/app/oracle/oradata/wolf/temp01.dbf
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Mon Apr 22 10:25:40 2013
Starting background process QMNC
QMNC started with pid=23, OS id=16115
Mon Apr 22 10:25:57 2013
Completed: alter database open
[oracle@test ~]$ tail 50 /opt/app/oracle/admin/wolf/bdump/alert_wolf.log
tail: cannot open `50' for reading: No such file or directory
==> /opt/app/oracle/admin/wolf/bdump/alert_wolf.log <==
SMON: enabling tx recovery
Mon Apr 22 10:25:29 2013
Re-creating tempfile /opt/app/oracle/oradata/wolf/temp01.dbf
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Mon Apr 22 10:25:40 2013
Starting background process QMNC
QMNC started with pid=23, OS id=16115
Mon Apr 22 10:25:57 2013
Completed: alter database open
[oracle@test ~]$ tail 30 /opt/app/oracle/admin/wolf/bdump/alert_wolf.log
tail: cannot open `30' for reading: No such file or directory
==> /opt/app/oracle/admin/wolf/bdump/alert_wolf.log <==
SMON: enabling tx recovery
Mon Apr 22 10:25:29 2013
Re-creating tempfile /opt/app/oracle/oradata/wolf/temp01.dbf
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Mon Apr 22 10:25:40 2013
Starting background process QMNC
QMNC started with pid=23, OS id=16115
Mon Apr 22 10:25:57 2013
Completed: alter database open
[oracle@test ~]$ 


===================================================================================================
恢复单个数据文件
模拟system文件丢失
[oracle@test wolf]$ ls
control01.ctl  redo02.log  redo11.log     system01.dbf   wolfblock01.dbf
control02.ctl  redo03.log  redo12.log     temp01.dbf
control03.ctl  redo04.log  redo13.log     undotbs01.dbf
redo010.log    redo05.log  rman_wolf.dbf  users01.dbf
redo01.log     redo06.log  sysaux01.dbf   wolf01

[oracle@test wolf]$ mv system01.dbf system01.dbf.bak

RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down
RMAN> startup
connected to target database (not started)
Oracle instance started
database mounted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 04/22/2013 10:35:35
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/opt/app/oracle/oradata/wolf/system01.dbf'


RMAN>  restore datafile 1;
Starting restore at 22-4月 -13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/app/oracle/oradata/wolf/system01.dbf
channel ORA_DISK_1: reading from backup piece /opt/app/oracle/flash_recovery_area/WOLF/backupset/2013_04_22/o1_mf_nnndf_TAG20130422T091128_8qbfr0t1_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/opt/app/oracle/flash_recovery_area/WOLF/backupset/2013_04_22/o1_mf_nnndf_TAG20130422T091128_8qbfr0t1_.bkp tag=TAG20130422T091128
channel ORA_DISK_1: restore complete, elapsed time: 00:03:57

Finished restore at 22-4月 -13

RMAN> recover datafile 1;
Starting recover at 22-4月 -13
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 22-4月 -13
RMAN> alter database open;
database opened