At least one of your control files is corrupted, or the disk it
is on is bad:
00204, 00000, "error in reading (block %s, # blocks %s) of controlfile"
// *Cause: A disk I/O failure was detected on reading the controlfile.
// *Action: Check if the disk is online, if it is not, bring it online and
try
// a warm start again. If it is online, then you need to recover
// the disk.
Jared
"Nguyen, David M" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/14/2002 05:19 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: How to fix ORA-03113 error
I could not start database due to ORA-03113 error, someone please advise
what it means and how to fix it ASAP. I really appreciate your help.
Thanks,
David
SVRMGR> startup
ORACLE instance started.
Total System Global Area 285236752 bytes
Fixed Size 48656 bytes
Variable Size 75390976 bytes
Database Buffers 209715200 bytes
Redo Buffers 81920 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
***Alert.log:
Mon Oct 14 17:57:27 2002
Database mounted in Exclusive Mode.
Completed: alter database mount
Mon Oct 14 17:57:27 2002
alter database open
Picked broadcast on commit scheme to generate SCNs
Mon Oct 14 17:57:27 2002
Rolling back half complete log switch of thread 1
LGWR: terminating instance due to error 204
Instance terminated by LGWR, pid = 483
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).