RMAN Restore Failure ORA-01180 and ORA_01110
Date: Tue, 6 Oct 2009 07:14:34 -0700 (PDT)
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-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