RE: Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []

From: "Dimensional DBA" <dimensional.dba@xxxxxxxxxxx>
To: <Christopher.Taylor2@xxxxxxxxxxxx>, <andrew.kerber@xxxxxxxxx>, <gajav@xxxxxxxxx>
Date: Tue, 26 Feb 2013 20:27:49 -0800

You might try the solution in Metalink Article 787031.1.
It fixes a lot (not all) of ASSM metadata block corruptions.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Christopher.Taylor2@xxxxxxxxxxxx
Sent: Tuesday, February 26, 2013 11:25 AM
To: andrew.kerber@xxxxxxxxx; gajav@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Need some ideas to recover object - ORA-00600: internal error
code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []

Yep I did actually.

No reported issues there.

Chris


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Andrew Kerber
Sent: Tuesday, February 26, 2013 1:10 PM
To: gajav@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Need some ideas to recover object - ORA-00600: internal error
code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []

This is kind of a shot in the dark, but did you try running dbverify on the
data file(s)?
On Tue, Feb 26, 2013 at 1:02 PM, Gaja Krishna Vaidyanatha
<gajav@xxxxxxxxx>wrote:

> So, did you try re-creating the control file :) ? And did that help :) ?
>
> Gaja Krishna Vaidyanatha,
> CEO & Founder, DBPerfMan LLC
> http://www.dbperfman.com
> <SNIP> <http://www.dbcloudman.com>
>
--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l

References:
- Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []
  - From: Christopher.Taylor2
- Re: Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []
  - From: Martin Berger
- RE: Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []
  - From: Christopher.Taylor2
- Re: Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []
  - From: Gaja Krishna Vaidyanatha
- RE: Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []
  - From: Christopher.Taylor2
- Re: Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []
  - From: Gaja Krishna Vaidyanatha
- Re: Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []
  - From: Andrew Kerber
- RE: Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []
  - From: Christopher.Taylor2

RE: Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []

Other related posts: