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

From: <Christopher.Taylor2@xxxxxxxxxxxx>
To: <shastry17@xxxxxxxxx>
Date: Mon, 4 Mar 2013 15:55:22 -0600

What I did was create an AUXILIARY database on my primary database cluster 
server.  The Auxiliary database only lived on 1 node and wrote the datafiles 
out to a EXT3 filesystem on the local node.
DB_NAME=AUX1
DB_UNIQUE_NAME=AUX1
CONTROL_FILES=/datatransn1/MYPROD_DBNAME/aux1/control01.ctl
DB_FILE_NAME_CONVERT=('+DG_MYPROD_DBNAME_DATA_01/MYPROD_DBNAME/datafile/','/datatransn1/MYPROD_DBNAME/aux1/',

'+DG_MYPROD_DBNAME_UNDO_TEMP_01/MYPROD_DBNAME/datafile/','/datatransn1/MYPROD_DBNAME/aux1/',
 '+DG_MYPROD_DBNAME_UNDO_TEMP_01/MYPROD_DBNAME/tempfile/', 
'/datatransb/MYPROD_DBNAME/aux1/')
LOG_FILE_NAME_CONVERT=('+DG_MYPROD_DBNAME_REDO_01/MYPROD_DBNAME/datafile/','/datatransn1/MYPROD_DBNAME/aux1/')
REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'
COMPATIBLE .2.0.3.0
DB_BLOCK_SIZE92
SGA_MAX_SIZE=5G
local_listener='MYPROD_DBNAMEN1'
audit_file_dest=/datatransn1/MYPROD_DBNAME/aux1/
audit_trail='db'
skip_unusable_indexes=TRUE
undo_tablespace='UNDOTBS01'
background_dump_dest='/datatransn1/MYPROD_DBNAME/aux1/'
user_dump_dest='/datatransn1/MYPROD_DBNAME/aux1/'
core_dump_dest='/datatransn1/MYPROD_DBNAME/aux1/'
_no_recovery_through_resetlogs=true
processes00

Startup the AUX1 instance NOMOUNT

Then did an RMAN DUPLICATE TO AUXILIARY DATABASE using the SKIP TABLESPACE 
argument to skip all the tablespaces I wasn't interested in.  You must have 
SYSTEM, SYSAUX so you can't skip them.

Chris

From: Shastry(DBA) [mailto:shastry17@xxxxxxxxx]
Sent: Thursday, February 28, 2013 9:00 PM
To: Taylor Christopher - Nashville
Subject: Re: Need some ideas to recover object - ORA-00600: internal error 
code, arguments: [ktspScanInit-d], [58759497], [], [], [], [], [], []

Hi Chris,

Can you please share me the document on RMAN partial restoration you did? Also 
I have a scenario where I have to restore only required data files out of my TB 
size database and do create a new control file and open the DB with reset logs 
and export finally the required tables. Please suggest and share.

Thanks
Shastry

On Wednesday, February 27, 2013, wrote:
Yep I did actually.

No reported issues there.

Chris

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx<javascript:;> 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<javascript:;>] On Behalf Of Andrew Kerber
Sent: Tuesday, February 26, 2013 1:10 PM
To: gajav@xxxxxxxxx<javascript:;>
Cc: oracle-l@xxxxxxxxxxxxx<javascript:;>
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<javascript:;>>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

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

Other related posts: