Re: ora-600 diff between SCNs

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@xxxxxxxxxxx>
To: kaygopal@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@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. 
Sign up today.

Other related posts: