I faced this problem on Jul3 . Alert.log showed
Tue Jul 3 09:59:03 2001
Errors in file /ora1/app/oracle/admin/fprod/bdump/pmon_19273.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01115: IO error reading block from file 2 (block # 46478)
ORA-01110: data file 2: '/ora11/oradata/fprod/fprodrbs1.dbf'
ORA-27041: unable to open file
HP-UX Error: 2: No such file or directory
Additional information: 3
Tue Jul 3 09:59:04 2001
--------------------
Alert log was showing problem in only one datafile. But there were 3 datafiles and 1 control file missing from the above directory. Has anybody faced such problems? Is it a hardware problem when suddenly u find files missing?