Re: UPDATE - Ora-19906 when restoring user managed backup - stumped!
From: Ravi <ravisista_at_gmail.com>
Date: Mon, 5 Oct 2009 13:00:29 -0700 (PDT)
Message-ID: <2cddfb38-ed06-40e1-adf8-8ed7d66b44c2_at_p36g2000vbn.googlegroups.com>
On Sep 16, 12:56 pm, gs <g..._at_gs.com> wrote:
> gs wrote:
> > Hemant K Chitale wrote:
> >> Check if you rebuilt the controlfile properly and that the newly
> >> created controlfile IS in use for the Recovery, not an older
> >> controlfile.
>
> >> Hemant K Chitale
> >>http://hemantoracledba.blogspot.com
>
> > checked all that, all was ok, done this process many times, just this
> > time I was getting error. Finally was able to apply redo and open
> > database with resetlogs, but only after I set the database incarnation
> > to 1 with and RMAN command. Not sure why this was necessary this
> > particular time though. Opened an SR and uploaded alert logs etc.. from
> > prod and test db's, will see if they come up with any useful info..
>
> Oracles answer was when I try and recreate the controlfile with
> resetlogs (or open database with resetlogs) a new incarnation is
> created, and ends up being an orphan incarnation. Read more about it in
> doc id 577820.1
>
> Setting db incarnation to 1 fixed the problem for me, but the note says
> to recreate the controlfile to get around this error, which I did and
> that alone did not work. In any case I am up and running now, still
> puzzled as to why this never happened before though...- Hide quoted text -
>
> - Show quoted text -
Date: Mon, 5 Oct 2009 13:00:29 -0700 (PDT)
Message-ID: <2cddfb38-ed06-40e1-adf8-8ed7d66b44c2_at_p36g2000vbn.googlegroups.com>
On Sep 16, 12:56 pm, gs <g..._at_gs.com> wrote:
> gs wrote:
> > Hemant K Chitale wrote:
> >> Check if you rebuilt the controlfile properly and that the newly
> >> created controlfile IS in use for the Recovery, not an older
> >> controlfile.
>
> >> Hemant K Chitale
> >>http://hemantoracledba.blogspot.com
>
> > checked all that, all was ok, done this process many times, just this
> > time I was getting error. Finally was able to apply redo and open
> > database with resetlogs, but only after I set the database incarnation
> > to 1 with and RMAN command. Not sure why this was necessary this
> > particular time though. Opened an SR and uploaded alert logs etc.. from
> > prod and test db's, will see if they come up with any useful info..
>
> Oracles answer was when I try and recreate the controlfile with
> resetlogs (or open database with resetlogs) a new incarnation is
> created, and ends up being an orphan incarnation. Read more about it in
> doc id 577820.1
>
> Setting db incarnation to 1 fixed the problem for me, but the note says
> to recreate the controlfile to get around this error, which I did and
> that alone did not work. In any case I am up and running now, still
> puzzled as to why this never happened before though...- Hide quoted text -
>
> - Show quoted text -
Did you happen to upgrade this database to 10g recently? Or has this been at 10g for quite some time? I am just wondering if this is a 10g behavior. Received on Mon Oct 05 2009 - 15:00:29 CDT