Re: Ora-19906 when restoring user managed backup - stumped!

From: gs <>
Date: Thu, 10 Sep 2009 17:23:10 GMT
Message-ID: <2Caqm.43438$Db2.15108_at_edtnps83>

joel garry wrote:
> On Sep 9, 9:33 am, gs <> wrote:
>> joel garry wrote:
>>> On Sep 8, 7:06 pm, GS <> wrote:
>>>> ps. database is on windows 64 bit server.
>>> Wild guess after looking at metalink Note: 824213.1is that you did a
>>> flashback of your prod database at some point, perhaps between when
>>> you took the controlfile backup and the online backup?  Any clues in
>>> the prod alert log?
>>> See
>>> maybe if you specify an until time you can overcome an SCN ambiguity.
>>> jg
>>> --
>>> is bogus.
>>> Cash of the Titans: Amazon, Microsoft and Yahoo versus Google:
>> Nope, no flashback done, and controlfile script is standard script I use
>> using backup controlfile to trace. After digging through the prod alert
>> log I am seeing a few of these:

> OK, I just took a gander at my controlfile trace, and I notice both
> methods have commented out incarnation registry lines. Could this be
> something you need? From the docs:
> "When a log file is from an unknown incarnation, the REGISTER LOGFILE
> clause causes an incarnation record to be added to the V
> $DATABASE_INCARNATION view. If the newly registered log file belongs
> to an incarnation having a higher RESETLOGS_TIME than the current
> RECOVERY_TARGET_INCARNATION# to be changed to correspond to the newly
> added incarnation record."
> So, what's in that incarnation view before you muck with incarnation
> settings?
> jg
> --
> is bogus.
> If at first you don't succeed, use your superpowers.

  On the test/recovered database the view showed two incarnations 1 and 2, so using RMAN I changed it (database) to 2, still got the error, then changed it to 1, and was able to apply redo and open with resetlogs.

Still puzzled as to why this happened this time, I update this test db every month or so with no issues till now. Have an SR open so I'll see what they say, will post back with answer (if I get one) Received on Thu Sep 10 2009 - 12:23:10 CDT

Original text of this message