| 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
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:
a.. 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... b.. Have you performed the "cksum" (checksum) command against all of the control files to verify that they are exactly identical? c.. Are there any other ".trc" files in the BDUMP directory created around the same time? What does it say? d.. Are there any other ".trc" files in the UDUMP directory created around the same time? e.. 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?
> 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: 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
> ---------------------------------------------------------------------
> 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: 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: Tim Gorman INET: Tim_at_SageLogix.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).Received on Tue Oct 15 2002 - 13:59:21 CDT
 |
 |