Re: Re: datafile corrupted..ora600 ???

I have already removed rollback segments entry in init.ora file. After that I was able to drop rbs01.dbf file in mount stage. Now while opening it is giving error on system datafile.

~Dilip

ORACLE-L_at_fatcity.com wrote:

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"

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

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
="Arial" size="2">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"http://airsahara.indiatimes.com and Bid Now !

--=_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).




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 for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now !

-- 
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).