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

Reply via email to