rman异地恢复遇到ORA-01180错误

hexun007

环境：操作系统 Redhat linux AS 4 U 7 64位
        数据库    oracle 10g R2 64位 (10.2.0.4)
        两台主机一样的环境
操作步骤：1、在生产数据库做rman备份，生成的备份文件和控制文件ftp上传到备份服务器；
             2、在备份服务器上操作如下：
/home/oracle/>rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Mon Aug 24 09:42:21 2009
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
Oracle instance started
Total System Global Area     599785472 bytes
Fixed Size                     2085776 bytes
Variable Size                209718384 bytes
Database Buffers             381681664 bytes
Redo Buffers                   6299648 bytes
RMAN> restore controlfile from '/home/oracle/rmanbackup/20090821/c-3616526356-20090821-00';
Starting restore at 2009-08-24 09:43:22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=321 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/oradata/ytdb/control01.ctl
output filename=/oradata/ytdb/control02.ctl
output filename=/oradata/ytdb/control03.ctl
Finished restore at 2009-08-24 09:43:25
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> restore database;
Starting restore at 2009-08-24 09:43:40
Starting implicit crosscheck backup at 2009-08-24 09:43:40
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=321 devtype=DISK
Crosschecked 125 objects
Finished implicit crosscheck backup at 2009-08-24 09:43:43
Starting implicit crosscheck copy at 2009-08-24 09:43:43
using channel ORA_DISK_1
Finished implicit crosscheck copy at 2009-08-24 09:43:43
searching for all files in the recovery area
cataloging files...
cataloging done
……
using channel ORA_DISK_1
creating datafile fno=1 name=/oradata/ytdb/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/24/2009 09:43:51
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/oradata/ytdb/system01.dbf'

在网上搜过一些网友的办法，如在生产数据库上生成pfile文件，上传到备份服务器，用pfile启动，然后执行恢复就可以了，但是我试过了，还是不行。

zhen917

ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/oradata/ytdb/system01.dbf'
目录文件的属性，还有目录是否都存在。ytdb下是否存在system01.dbf？？

hexun007

存在system01.dbf，需要先删除system01.dbf吗？不是从备份集里恢复数据文件，可以直接覆盖吗？

山野村夫

有权限的话，应该是覆盖