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

From: <Christopher.Taylor2@xxxxxxxxxxxx>
To: <gajav@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 26 Feb 2013 12:48:58 -0600

I think its an ASSM issue in the affected tablespace and support doesn't have 
any events related to this particular bug that might allow me to skip anything.

Good idea though.

Chris

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Gaja Krishna Vaidyanatha
Sent: Tuesday, February 26, 2013 12:46 PM
To: Oracle-L List
Subject: Re: Need some ideas to recover object - ORA-00600: internal error 
code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []

Hey Chris,
Just wondering if there is something SIMILAR to event 10231 (skips corrupted 
blocks in a scan) that will work here. This seems to be a control file 
corruption issue. At any rate, have you tried re-creating your control files 
(alter database backup control file to trace, and doing the rest during the 
startup no mount)?
 
Cheers,

Gaja

Gaja Krishna Vaidyanatha,
CEO & Founder, DBPerfMan LLC
http://www.dbperfman.com
http://www.dbcloudman.com

Phone - +1 (650) 743-6060
LinkedIn - http://www.linkedin.com/in/gajakrishnavaidyanatha

Co-author: Oracle Insights:Tales of the Oak Table - 
http://www.apress.com/9781590593875
Primary Author: Oracle Performance Tuning 101 - http://www.amzn.com/0072131454 
Enabling Cloud Deployment & Management for Oracle & Big Data


________________________________
 From: "Christopher.Taylor2@xxxxxxxxxxxx" <Christopher.Taylor2@xxxxxxxxxxxx>
To: martin.a.berger@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Tuesday, February 26, 2013 10:23 AM
Subject: RE: Need some ideas to recover object - ORA-00600: internal error 
code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []
 
Interesting - I'll check the data unloader.
Right now I'm running a DUPLICATE DATABASE SKIP TABLESPACE to try to attempt to 
restore the tablespace I need into a dup database and copy the data out from 
there.

We'll see if that works.  (fingers crossed?)

Chris


From: Martin Berger [mailto:martin.a.berger@xxxxxxxxx]
Sent: Tuesday, February 26, 2013 12:22 PM
To: Taylor Christopher - Nashville
Cc: Oracle-L oracle-l
Subject: Re: Need some ideas to recover object - ORA-00600: internal error 
code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []

Hi Chris,

I have never seen this error, so everything below are just assumptions:
In case the BUG only affects the write into the data file, but not it's 
corresponding data in redo / archive, you have a chance you can export the data 
there. - Please ask Oracle Support for details on this BUG.

there is a tool called BBED to edit blocks in data files directly. I don't know 
if it can handle your problem - I've never done it.

there are some DUL (Data UnLoader) [e.g. http://www.ora600.be/ ] tools 
available which export data directly from datafiles. maybe they can unload data 
even with broken ASSM data.

There are probably more ways to address this problem.

hth
Martin

On Tue, Feb 26, 2013 at 4:40 PM, 
<Christopher.Taylor2@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>> 
wrote:
Env: 10.2.0.4 64bit 3 node RAC on RH Linux 5.6

Question: what is the 2nd argument? [58759497]

Situation:
- No nightly exports/datapumps - we have nightly RMAN backups.
- There is a known Oracle Bug 11791664 with inconsistent metadata in ASSM 
segments with NO workarounds listed
- The object is in a specific tablespace (REPORTING) separate from our main 
tablespaces
- DBMS_REPAIR.CHECK_OBJECT fails with the same error
- Exp fails with the same error
- create table as select from fails with same error

I know I can restore the production database to a copy on another server but 
other than that what are my options here?  Can I recover just the tablespace or 
will that regenerate the same problem once the tablespace is recovered?

Any suggestions are much appreciated.

Regards,

Chris Taylor
Oracle DBA
Parallon IT&S

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

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

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


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

Follow-Ups:
- Re: Need some ideas to recover object - ORA-00600: internal error code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []
  - From: Gaja Krishna Vaidyanatha

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], [], [], [], [], [], []

Other related posts: