I m working on RHEL4 U5 & Oracle 9i U8.
Oracle control files show 4 files user21, 22, 23, 24 but when checked on O/S it just reflects user21 file & rest of the 3 files weren't reflecting,
but the space shown in df -h, showed for all 4 files.
After a lot of checks we were not able to find anything, y its happening.
we tried to shutdown the database, but weren't able to do so, as 3 files did not reflect.
so we forcibly shut down the database & instantaneously got the space back on the O/S.
we did the restore from backup & database was up.
can any one tell me y this happened.