Re: RMAN Restore Failure ORA-01180 and ORA_01110

From: trub3101 <trub3101_at_sky.com>
Date: Wed, 7 Oct 2009 06:42:47 -0700 (PDT)
Message-ID: <379c2447-df15-4f0f-b2f5-d51dbdfd93ea_at_p15g2000vbl.googlegroups.com>

On 7 Oct, 13:06, gazzag <gar..._at_jamms.org> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Hi Gazzag,

So having managed to restore my original control files i.e. as they were before any rename/restore/switch datafile/recover attempts, I cannot now just rename/restore/switch datafile and recover?

Sorry to bleat on about this.

Thanks,

tb3101 Received on Wed Oct 07 2009 - 08:42:47 CDT