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

From: <Christopher.Taylor2_at_parallon.net>
Date: Mon, 4 Mar 2013 15:55:22 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E88582C47D64_at_NADCWPMSGCMS10.hca.corpad.net>

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_SIZE�92
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_at_gmail.com] 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_at_freelists.org<javascript:;> [mailto:oracle-l-bounce_at_freelists.org<javascript:;>] On Behalf Of Andrew Kerber Sent: Tuesday, February 26, 2013 1:10 PM To: gajav_at_yahoo.com<javascript:;>
Cc: oracle-l_at_freelists.org<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_at_yahoo.com<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.'


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


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


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

Received on Mon Mar 04 2013 - 22:55:22 CET