Re: ora-600 diff between SCNs

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: joe_dba@xxxxxxxxxxx, kaygopal@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 5 Nov 2008 18:58:07 +0000

I have seen this when a file from an incorrect backups was restored
along with files from a newer backup. Well worth working through with
support. Incidentally i have always found support for recovery
excellent. This is not always the case for feature usage:)

On 11/5/08, Joe Smith <joe_dba@xxxxxxxxxxx> wrote:
>
> A hotbackup thru RMAN and a disk crash happened.  They replaced the disk and
> when they try to restore and open this is the error that was returned.
>> Date: Wed, 5 Nov 2008 10:17:03 -0800> From: kaygopal@xxxxxxxxx> To:
>> joe_dba@xxxxxxxxxxx> Subject: Re: ora-600 diff between SCNs> CC:
>> oracle-l@xxxxxxxxxxxxx> > JoetheDBA,> > > OERI-2662 is an error where
>> there is a SCN mismatch between the block> SCN to current SCN. This could
>> happen when you use the> _allow_resetlogs or some kind of parameters to
>> ask oracle to ignore> the verification phase during database open
>> process.> > Can you pls exactly tell me what you were doing before opening
>> the DB?> > > Best Regards,> K Gopalakrishnan> Co-Author: Oracle Wait
>> Interface, Oracle Press 2004>
>> http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/> > Author:
>> Oracle Database 10g RAC Handbook, Oracle Press 2006>
>> http://www.amazon.com/gp/product/007146509X/> > > > On Wed, Nov 5, 2008 at
>> 8:27 AM, Joe Smith <joe_dba@xxxxxxxxxxx> wrote:> > Has anybody ever dealt
>> with this error upon starting a db:> >> > ORA-00600: internal error code,
>> arguments: [2662], [1922], [3602121928],> > [1922], [3607967151],
>> [8389130], [], []> >> >> > This is 8.1.7.4.0 and I have looked at the
>> metalink note: 28929.1> >> > there is a difference between SCNs :
>> [3607967151] - [3602121928]> >> >> >> > ________________________________>
>> > Color coding for safety: Windows Live Hotmail alerts you to suspicious>
>> > email. Sign up today.
> _________________________________________________________________
> Color coding for safety: Windows Live Hotmail alerts you to suspicious
> email.
> http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_safety_112008

-- 
Sent from Google Mail for mobile | mobile.google.com

Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l


Other related posts: