Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: error 204 how identify corrupted file?

Re: error 204 how identify corrupted file?

From: <maierh_at_myself.com>
Date: Mon, 14 Apr 2003 13:50:01 +0200
Message-ID: <uptnpjo2e.fsf@myself.com>

dcurtolo_at_metgroup.it writes:

> I've got a read error on some control file that cause oracle instance
> going on 3113 error at startup -> open.
>
> trace on startup process tell me more:
>
> from alertTESTDDL.log:
> -------------------------------------------------
> Tue Apr 8 11:38:25 2003
> Rolling back half complete log switch of thread 1
> LGWR: terminating instance due to error 204
> Instance terminated by LGWR, pid = 2287
> -------------------------------------------------
>
> from lgwr_2287.trc
> -------------------------------------------------
> ...
> WAIT #0: nam='control file sequential read' ela= 0 p1=0 p2=40 p3=1
> error 204 detected in background process
> -------------------------------------------------
>
> How do I identify that control file oracle can't read?

The people here need too information about the OS and the Oracle version. Personally I noticed the problem with Oracle 8.1.7 on Linux if I have not installed the glibc_*stubs. You will find a tarball and a description how to install it on otn.oracle.com.

Harald Received on Mon Apr 14 2003 - 06:50:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US