| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: datafile corrupted..ora600 ???
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> 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>
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 onwhich 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 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>
[3020], [16777403], [1], [2541], [161<BR>41], [16], [], []<BR>SVRMGR> </P> <P>Tried to search metalink with ora-600 arguments but no luck. Any idea on this ?</P>
<P> </P> <P>Regards,</P> <P>~Dilip</P> <P> </P> <P> </P> <hr><font face="Arial" size="2"><b>Get Your Private, Free E-mail fromIndiatimes 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
 |
 |