Re: cannot identify data file 1 - file not found

Steve Rafferty wrote:
>
> 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

Things to check:

1. permissions on directory and the file
2. is the size of the file on disk the same as the file in v$datafile --

   ---

   Connor McDonald BHP Information Technology Perth, Western Australia "Never wrestle a pig - you both get dirty and the pig likes it..."