Re: ora-600 diff between SCNs

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Wed, 5 Nov 2008 11:05:39 -0800 (PST)
Message-ID: <905458.21547.qm@web38904.mail.mud.yahoo.com>


Complete RMAN Script used for the restore? Did you restore the control file too?

RF

 Robert G. Freeman
Author:
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Other various titles out of print now... Blog: http://robertgfreeman.blogspot.com The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-)



From: Joe Smith <joe_dba_at_hotmail.com>
To: kaygopal_at_gmail.com
Cc: oracle-l_at_freelists.org
Sent: Wednesday, November 5, 2008 11:36:44 AM Subject: RE: ora-600 diff between SCNs

 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_at_gmail.com
> To: joe_dba_at_hotmail.com
> Subject: Re: ora-600 diff between SCNs
> CC: oracle-l_at_freelists.org
>
> 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_at_hotmail.com> 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. Sign up today.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 05 2008 - 13:05:39 CST

Original text of this message