If you are lucky and the file is still in use you can try the lsof command to get the file descriptor and recover the file from the /proc directory. Please see the following for more info: Recover Deleted Script file from Memory
Otherwise the only feasible option is to restore and recover the datafile from rman backup.
If you are wondering about options to recover the physical datafile from the physical device blocks or file system level you can usually forget it. According to http://en.wikipedia.org/wiki/Ext3: there is no support of deleted file recovery in file system design. Ext3 driver actively deletes files by wiping file inodes for crash safety reasons. This is why an accidental 'rm -rf ...' command may cause permanent data loss.
Hello. Thanks a lot for replying. I removed the .dbf file a few days ago and have restart the Operating System quite a few times. I don't think the .dbf file is in Memory.
However, in /proc directory, I try to run the command:
# lsof | grep psimage2.dbf
Its output: command not found.
My questions are:
Does Oracle Linux 5 support command " lsof " ?
What is the exact command to recover the removed file ?