Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> datafile corrupted..ora600 ???

datafile corrupted..ora600 ???

From: Dilip <dilip7772002_at_indiatimes.com>
Date: Tue, 15 Apr 2003 02:58:54 -0800
Message-ID: <F001.0058133C.20030415025854@fatcity.com>


--=_MAILER_ATTACH_BOUNDARY1_20034152151936424238335 Content-Type: text/plain; charset=us-ascii

Hi List,

Database 8.1.7.4 on Sun Sparc solaris 2.6

Yesterday our sysadm tried to remove mirroring of one the hard disk on which we have our test database. At that time, instance crashed.

Then when I tried to restart the database, it gave me error that it needs media recovery for datafile rbs01.dbf. This database is in noarchive log mode. So I mounted the database and I dropped that datafile. Now it is giving me error for system datafile when I am opening the database. The error is

SVRMGR&gt; alter database recover datafile '/datacrp_itw/crpitwdata/system04.dbf'; alter database recover datafile '/datacrp_itw/crpitwdata/system04.dbf' *
ORA-00283: recovery session canceled due to errors ORA-00600: internal error code, arguments: [3020], [16777403], [1], [2541], [161 41], [16], [], []
SVRMGR&gt;

Tried to search metalink with ora-600 arguments but no luck. Any idea on this ?  

Regards,

~Dilip     

Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now !

--=_MAILER_ATTACH_BOUNDARY1_20034152151936424238335 Content-Type: text/html; charset=us-ascii

<P>Hi List,</P>
<P>Database 8.1.7.4 on Sun Sparc solaris 2.6</P>
<P>Yesterday our sysadm tried to remove mirroring of one the hard disk on which we have our test database. At that time, instance crashed.</P>
<P>Then when I tried to restart the database, it gave me error that it needs media recovery for datafile rbs01.dbf. This database is in&nbsp;noarchive log mode. So I mounted the database and I dropped that datafile. Now it is giving me error for system datafile when I am opening the database. The error is </P>
<P>SVRMGR&gt; alter database recover datafile '/datacrp_itw/crpitwdata/system04.dbf';<BR>alter database recover datafile '/datacrp_itw/crpitwdata/system04.dbf'<BR>*<BR>ORA-00283: recovery session canceled due to errors<BR>ORA-00600: internal error code, arguments: [3020], [16777403], [1], [2541], [161<BR>41], [16], [], []<BR>SVRMGR&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P>
<P>Tried to search metalink&nbsp;with ora-600 arguments but no luck.&nbsp;Any idea on this ?</P>
<P>&nbsp;</P>
<P>Regards,</P>
<P>~Dilip</P>
<P>&nbsp; </P>
<P>&nbsp;</P>
<hr><font face="Arial" size="2"><b>Get Your Private, Free E-mail from Indiatimes at </font>http://email.indiatimes.com</b><br>Buy The Best In <b>BOOKS</b> at http://www.bestsellers.indiatimes.com<br>Bid for <b>Air Tickets @ Re.1</b> on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now !</font>

--=_MAILER_ATTACH_BOUNDARY1_20034152151936424238335--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dilip
  INET: dilip7772002_at_indiatimes.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Apr 15 2003 - 05:58:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US