Re: RMAN Restore Failure ORA-01180 and ORA_01110

From: gazzag <gareth_at_jamms.org>
Date: Tue, 6 Oct 2009 07:24:49 -0700 (PDT)
Message-ID: <77a96db6-fa44-4da6-951e-9a555d4abfd0_at_k26g2000vbp.googlegroups.com>



On 6 Oct, 15:14, trub3101 <trub3..._at_sky.com> wrote:
> 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 non-
> existent drive, G: ?
>
> Thanks in advance for any assistance received.
>
> tb3101

Could we see the script please?

HTH -g Received on Tue Oct 06 2009 - 09:24:49 CDT

Original text of this message