Oracle-L: RE: How to fix ORA-03113 error

From: Johnston, Tim <TJohnston_at_quallaby.com>
Date: Mon, 14 Oct 2002 16:58:22 -0800
Message-ID: <F001.004E8BFE.20021014165822@fatcity.com>

Your instance crashed because the lgwr died... There should be a trace file for lgwr in the bdump directory... What does it say in the trace file? Are you having any filesystem issues? The "LGWR: terminating instance due to error 204" means that there is an I/O error when accessing the controlfile... What version is your database... What O/S are you on... etc... There seems to be some known bugs in this area... Check Note:1069812.6 on Metalink...

Tim

-----Original Message-----
Sent: Monday, October 14, 2002 8:19 PM
To: Multiple recipients of list ORACLE-L

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: david.m.nguyen_at_xo.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.com
--

Author: Johnston, Tim
INET: TJohnston_at_quallaby.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------