Re: RMAN Restore Failure ORA-01180 and ORA_01110

From: gazzag <gareth_at_jamms.org>
Date: Wed, 7 Oct 2009 05:06:26 -0700 (PDT)
Message-ID: <994b6534-19ea-4f1a-9ebd-cca54508470f_at_o36g2000vbl.googlegroups.com>

On 7 Oct, 12:22, trub3101 <trub3..._at_sky.com> wrote: <snip>
> Thanks for your reply and input gazzag!
>
> I managed to restore the original controlfiles and went back through
> the restore process. However, I am still getting the same error this
> time on the 'E:' drive which is present on this host!
>
> 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/07/2009 12:05:44
> ORA-01180: can not create datafile 1
> ORA-01110: data file 1: 'E:\ORACLE\ORADATA\LIVE\SYSTEM01.DBF'
>
> Having successfully performed RMAN database duplication before I am in
> no doubt that what you have suggested will work. Still I am more than
> curious as to why the restore option should be failing in this manner.
>
> Many thanks again,
>
> tb3101

You shouldn't be restoring your control files. That's your problem. You should be using RMAN's DUPLICATE DATABASE functionality.

HTH -g Received on Wed Oct 07 2009 - 07:06:26 CDT