RMAN恢复数据库报ORA-19573错误

恢复数据库报ORA-19573错误，错误信息如下：

RMAN> RESTORE DATABASE; Starting restore at 15-JUL-15 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=9 device type=DISK channel ORA_DISK_1: restoring datafile 00001 input datafile copy RECID=2 STAMP=884555266 file name=E:\APP\TIANPAN\FLASH_RECOVERY_AREA\PTIAN\DATAFILE\O1_MF_SYSTEM_BSTBH904_.DBF destination for restore of datafile 00001: E:\APP\TIANPAN\ORADATA\PTIAN\SYSTEM01.DBF RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 07/15/2015 10:36:55 ORA-19573: cannot obtain exclusive enqueue for datafile 1 ORA-19600: input file is datafile-copy 2 (E:\APP\TIANPAN\FLASH_RECOVERY_AREA\PTIAN\DATAFILE\O1_MF_SYSTEM_BSTBH904_.DBF) ORA-19601: output file is datafile 1 (E:\APP\TIANPAN\ORADATA\PTIAN\SYSTEM01.DBF) RMAN>

原因：

SQL> SELECT STATUS FROM V$INSTANCE;

STATUS
------------
OPEN

整库恢复的话需要在MOUNT状态操作（表空间或数据文件级的恢复也可以在OPEN状态下操作）。而我的数据库实际处于OPEN状态，所以做整库恢复当然会失败。

解决方法：

很简单，关闭数据库，然后启动数据库到MOUNT状态，即可。

RMAN>  shutdown immediate;

database closed
database dismounted
Oracle instance shut down

RMAN> STARTUP MOUNT;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area    1071333376 bytes

Fixed Size                     1375792 bytes
Variable Size                637534672 bytes
Database Buffers             427819008 bytes
Redo Buffers                   4603904 bytes

RMAN> restore database;

Starting restore at 15-JUL-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK

channel ORA_DISK_1: restoring datafile 00001
input datafile copy RECID=2 STAMP=884555266 file name=E:\APP\TIANPAN\FLASH_RECOVERY_AREA\PTIAN\DATAFILE\O1_MF_SYSTEM_BSTBH904_.DBF
destination for restore of datafile 00001: E:\APP\TIANPAN\ORADATA\PTIAN\SYSTEM01.DBF
channel ORA_DISK_1: copied datafile copy of datafile 00001
output file name=E:\APP\TIANPAN\ORADATA\PTIAN\SYSTEM01.DBF RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00002
input datafile copy RECID=3 STAMP=884555292 file name=E:\APP\TIANPAN\FLASH_RECOVERY_AREA\PTIAN\DATAFILE\O1_MF_SYSAUX_BSTBJDFQ_.DBF
destination for restore of datafile 00002: E:\APP\TIANPAN\ORADATA\PTIAN\SYSAUX01.DBF
channel ORA_DISK_1: copied datafile copy of datafile 00002
output file name=E:\APP\TIANPAN\ORADATA\PTIAN\SYSAUX01.DBF RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00003
input datafile copy RECID=4 STAMP=884555305 file name=E:\APP\TIANPAN\FLASH_RECOVERY_AREA\PTIAN\DATAFILE\O1_MF_UNDOTBS1_BSTBK5V1_.DBF
destination for restore of datafile 00003: E:\APP\TIANPAN\ORADATA\PTIAN\UNDOTBS01.DBF
channel ORA_DISK_1: copied datafile copy of datafile 00003
output file name=E:\APP\TIANPAN\ORADATA\PTIAN\UNDOTBS01.DBF RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00004
input datafile copy RECID=7 STAMP=884555314 file name=E:\APP\TIANPAN\FLASH_RECOVERY_AREA\PTIAN\DATAFILE\O1_MF_USERS_BSTBKKVB_.DBF
destination for restore of datafile 00004: E:\APP\TIANPAN\ORADATA\PTIAN\USERS01.DBF
channel ORA_DISK_1: copied datafile copy of datafile 00004
output file name=E:\APP\TIANPAN\ORADATA\PTIAN\USERS01.DBF RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00005
input datafile copy RECID=5 STAMP=884555312 file name=E:\APP\TIANPAN\FLASH_RECOVERY_AREA\PTIAN\DATAFILE\O1_MF_EXAMPLE_BSTBKF80_.DBF
destination for restore of datafile 00005: E:\APP\TIANPAN\ORADATA\PTIAN\EXAMPLE01.DBF
channel ORA_DISK_1: copied datafile copy of datafile 00005
output file name=E:\APP\TIANPAN\ORADATA\PTIAN\EXAMPLE01.DBF RECID=0 STAMP=0
Finished restore at 15-JUL-15

RMAN>