Re: Ora-19906 when restoring user managed backup - stumped!
Date: Wed, 09 Sep 2009 16:33:13 GMT
joel garry wrote:
> 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.
> _at_home.com 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:
Wed Sep 09 10:07:31 2009
Thread 1 cannot allocate new log, sequence 3255 Private strand flush not complete
Current log# 5 seq# 3254 mem# 0: E:\ORACLE\ORADATA\MYDB\MYDB\REDO5.LOG
Current log# 5 seq# 3254 mem# 1: D:\ORACLE\ORADATA\MYDB\REDO5A.LOG
Wed Sep 09 10:07:32 2009
Thread 1 advanced to log sequence 3255 (LGWR switch)
Current log# 6 seq# 3255 mem# 0: E:\ORACLE\ORADATA\MYDB\MYDB\REDO6.LOG Current log# 6 seq# 3255 mem# 1: D:\ORACLE\ORADATA\MYDB\REDO6A.LOG
so I am wondering if this is somehow related.. looking at ways now to cure this particular error, it happens when I do a manual logfile switch as well. Received on Wed Sep 09 2009 - 11:33:13 CDT