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: [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:
