RMAN Restore Failure ORA-01180 and ORA_01110

From: trub3101 <trub3101_at_sky.com>
Date: Tue, 6 Oct 2009 07:14:34 -0700 (PDT)
Message-ID: <8cb42371-60c6-46cc-809a-8f089e9b6bd5_at_j9g2000vbp.googlegroups.com>

Hi all,

I am trying to restore database a to another server. However, after including a script to change the datafile and redo log locations from drive G: to drive E:, restore database, switch datafile all and recover database commands in the RMAN run command and run it, I get the following error message:

creating datafile fno=1 name=E:\ORACLE\ORADATA\LIVE\SYSTEM01.DBF RMAN-00571:

---

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

---

RMAN-00571:

---

RMAN-03002: failure of restore command at 10/06/2009 14:51:44 ORA-01180: can not create datafile 1
ORA-01110: data file 1: 'G:\ORACLE\ORADATA\LIVE\SYSTEM01.DBF'

The server which I am restoring database a to does not have a drive G:

I have checked the permissions for the RMAN backup files, there is more than enough room on the E: drive I have even set the database incarnation to 1 hoping this might help.

Why is restore attempting to create the system datafile on the a nonexistent  drive, G: ?

Thanks in advance for any assistance received.

tb3101 Received on Tue Oct 06 2009 - 09:14:34 CDT