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
Instance name: SSDB
Redo thread mounted by this instance: 1
Oracle process number: 4
Unix process pid: 272, image: ora_lgwr_SSDB
*** SESSION ID:(3.1) 2002.10.13.02.19.02.000
error 204 detected in background process
-----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: [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: Johnston, Tim
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: 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).
