Re: Ora-19906 when restoring user managed backup - stumped!
From: joel garry <joel-garry_at_home.com>
Date: Wed, 9 Sep 2009 09:12:52 -0700 (PDT)
Message-ID: <0a7074cb-1821-4ed6-871e-9333c8c2001b_at_v15g2000prn.googlegroups.com>
On Sep 8, 7:06 pm, GS <g..._at_gs.com> wrote:
> ps. database is 10.2.0.4 on windows 64 bit server.
Date: Wed, 9 Sep 2009 09:12:52 -0700 (PDT)
Message-ID: <0a7074cb-1821-4ed6-871e-9333c8c2001b_at_v15g2000prn.googlegroups.com>
On Sep 8, 7:06 pm, GS <g..._at_gs.com> wrote:
> ps. database is 10.2.0.4 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 http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr005.htm#sthref646 maybe if you specify an until time you can overcome an SCN ambiguity.
jg
-- _at_home.com is bogus. Cash of the Titans: Amazon, Microsoft and Yahoo versus Google: http://www3.signonsandiego.com/stories/2009/sep/09/sparring-rises-over-googles-book-deal/?uniontribReceived on Wed Sep 09 2009 - 11:12:52 CDT