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
