Re: ora-600 diff between SCNs
Date: Wed, 5 Nov 2008 11:05:39 -0800 (PST)
Complete RMAN Script used for the restore? Did you restore the control file too?
Robert G. Freeman
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>
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
> 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
> Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
> 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: , , ,
> > , , , , 
> > This is 184.108.40.206.0 and I have looked at the metalink note: 28929.1
> > there is a difference between SCNs :  - 
> > ________________________________
> > 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. Received on Wed Nov 05 2008 - 13:05:39 CST