Re: RMAN Restore Failure ORA-01180 and ORA_01110
From: gazzag <gareth_at_jamms.org>
Date: Wed, 7 Oct 2009 07:58:25 -0700 (PDT)
Message-ID: <e48522f4-6c11-4671-8c21-79ee71479b51_at_p36g2000vbn.googlegroups.com>
On 7 Oct, 14:42, trub3101 <trub3..._at_sky.com> wrote:
> 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- Hide quoted text -
>
Date: Wed, 7 Oct 2009 07:58:25 -0700 (PDT)
Message-ID: <e48522f4-6c11-4671-8c21-79ee71479b51_at_p36g2000vbn.googlegroups.com>
On 7 Oct, 14:42, trub3101 <trub3..._at_sky.com> wrote:
> 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- Hide quoted text -
>
Perhaps I'm misunderstanding you, what do you mean by "original control files"? Received on Wed Oct 07 2009 - 09:58:25 CDT