| 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: How to fix ORA-03113 error
I have oracle8.0.5 running on Solaris8. Here's trace file. I don't think
there is problem with I/O. How do I recover this error?
$more ssdb_lgwr_272.trc
Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_lgwr_272.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /export/home/oracle/product/8.0.5
System name: SunOS
Node name: plab1 Release: 5.8 Version: Generic_108528-03 Machine: sun4u
-----Original Message-----
Sent: Monday, October 14, 2002 7:58 PM
To: Multiple recipients of list ORACLE-L
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).
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).
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). Received on Tue Oct 15 2002 - 10:54:08 CDT
 |
 |