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

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

Re: datafile corrupted..ora600 ???

From: ManojKr Jha <jmanoj_at_delhi.tcs.co.in>
Date: Tue, 15 Apr 2003 04:38:36 -0800
Message-ID: <F001.005813EA.20030415043836@fatcity.com>

Before opening database please be sure that there should not be entry in INIT.ora filefor that instance for specified rollback segment .

With Regards,
Manoj Kumar Jha
C-56 , Phase-2
NOIDA -201305, UP(INDIA)
Tata Consultancy Services
Ph No: (+91-120) 4461001 ext : 1037 (Off.) Mobile No : 9810090974


A transcendentalist engaged in auspicious activities does not meet with destruction either in this world or in the spiritual world; one who does good, is never overcome by evil.


                                                                                                                         
                    "Dilip"                                                                                              
                    <dilip7772002_at_india        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    times.com>                 cc:                                                                       
                    Sent by:                   Subject:     datafile corrupted..ora600 ???                               
                    root_at_fatcity.com                                                                                     
                                                                                                                         
                                                                                                                         
                    04/15/03 04:28 PM                                                                                    
                    Please respond to                                                                                    
                    ORACLE-L                                                                                             
                                                                                                                         
                                                                                                                         




--=_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><a href="http://email.indiatimes.com"><font face ="Arial" size="2">http://email.indiatimes.com</a></b><br>Buy The Best In <b>BOOKS</b> at <A href="http://www.bestsellers.indiatimes.com ">http://www.bestsellers.indiatimes.com</A><br>Bid for <b>Air Tickets @ Re.1</b> on Air Sahara Flights. Just log on to <a href=" http://airsahara.indiatimes.com">http://airsahara.indiatimes.com</a> 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).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: ManojKr Jha
  INET: jmanoj_at_delhi.tcs.co.in

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 - 07:38:36 CDT

Original text of this message

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