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

Home -> Community -> Usenet -> c.d.o.server -> Re: Emergency! system01.dbf too large

Re: Emergency! system01.dbf too large

From: <karsten_schmidt8891_at_my-deja.com>
Date: Tue, 02 Nov 1999 15:43:59 GMT
Message-ID: <7vn0ru$2f6$1@nnrp1.deja.com>


Jeff,
 sounds like this file has been corrupted.  any messages in your alert<SID>.log file ?

 you may have to perform media recovery for that file.

Karsten

In article <7vj05g$kd1$1_at_justice.csc.cuhk.edu.hk>,   "Jeff Lee" <kit_at_cintec.cuhk.edu.hk> wrote:
> Hi,
>
> When I logon my oracle server today it saids:
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01115: IO error reading block from file 1 (block # 229)
> ORA-01110: data file 1: '/opt/u02/oradata/acc/system01.dbf'
> ORA-27041: unable to open file
> SVR4 Error: 79: Value too large for defined data type
> Additional information: 3
>
> What should I do to revive my daily operation?
>
> Jeff
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 02 1999 - 09:43:59 CST

Original text of this message

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