Re: ora-600 diff between SCNs
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: joe_dba@xxxxxxxxxxx, kaygopal@xxxxxxxxx
- Date: Wed, 5 Nov 2008 11:05:39 -0800 (PST)
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: , , , > > , , , ,  > > > > > > This is 126.96.36.199.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.