cannot identify data file 1

From: Steve Rafferty <sraffert_at_umabnet.umab.edu>
Date: 13 Apr 1999 17:05:16 GMT
Message-ID: <7evtgc$k4t$1@list.umaryland.edu>

Hello --

I have a database (Oracle 8.0.3 running on Solaris2.6) which suddenly refuses to open with the message

cannot identify data file 1 - file not found

it then provides the full path to the file it can't find -- the path and filename are correct and the file is there.

A colleague has suggested that the problem may be that the datafile has become too large

2215428096 Apr 12 07:01 system01.dbf

and that fstat is failing to get the file status and thus the database fails to open.

Autoextend was on -- but I didn't suspect that Oracle would extend the file beyond its capacity to open.

Does this sound like a reasonable explanation of why the database won't open? other thoughts?

and . . . most importantly (since I don't have a good backup) . . . am I hosed? ;-)

Thanks in advance.

Steve Received on Tue Apr 13 1999 - 12:05:16 CDT