Please don't "think" about whether there is I/O
trouble -- test it. There is no sense in eliminating possible clues based
on hoping. To paraphrase Thomas Edison, troubleshooting is 98%
perspiration and 2% inspiration...
Please chase down *all* of the clues
you've been provided:
- Have you attempted to read your control files? Just use the UNIX "dd" or "od" commands to make sure that a read can be performed without an error...
- Have you performed the "cksum" (checksum) command against all of the control files to verify that they are exactly identical?
- Are there any other ".trc" files in the BDUMP directory created around the same time? What does it say?
- Are there any other ".trc" files in the UDUMP directory created around the same time?
- Are there any "core" files in the CDUMP directory created around the same time?
Hopefully, the first thing you did was log a TAR on
MetaLink, right?
----- Original Message -----
From: "Nguyen, David M" <[EMAIL PROTECTED]>
To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 9:54
AM
Subject: RE: How to fix ORA-03113
error
> 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).