| 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: HELP: HD crashed, oracle get Error ORA-00205
How many control files you have? try to remove it from your initSID ora and
start again. Try to remove one by one, if you have more than one
controlfile. Otherwise restore it whole cold back up if you have.
Regards
Rafiq
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Thu, 18 Sep 2003 07:44:41 -0800
Hello,
I am running oracle on Linux as my development server. Somehow, the hard
drive
crashed last night. When I run fsck on the partition that has the oracle
installation and oradata, it always failed with all kind of stuff
(Bad/Duplicate block, short read block, etc), so I assume fsck cannot fully
recovered my drive.
I however can mount it and read some data on in. Then I tried to logon as sysdba and issues startup, and I got the following error.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 235999352 bytes
Fixed Size 450680 bytes Variable Size 201326592 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytesORA-00205: error in identifying controlfile, check alert log for more info
My question: is there any hope at all to recover all or partial of the data
in
the database? Even if I have to redo oracle installation or re-create the
tables, that's fine if I can just recover the data. What can I do? Any help
on this is greatly appreciated.
And no, I don't have backup. This is supposed to be development server and
end
up becoming a semi production server. And no, we don't have a DBA either,
and
I'm newbie on that area (I'm supposed to be a web developer). In a way I a
sorta hope this incident becomes a lesson for the boss. <sigh>
Thanks a lot for any help.
RDB
-- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN ------------------------------------------------- /"\ ASCII Ribbon Campaign against HTML \ / email and proprietary format X attachments. / \ ------------------------------------------------- Have you been used by Microsoft today? Choose your life. Choose freedom. Choose LINUX. ------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: techlist_at_voyager.phys.utk.edu 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-LReceived on Thu Sep 18 2003 - 12:44:47 CDT
(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 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: rafiq9857_at_hotmail.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).
 |
 |