Unanswered: Recover a lost datafile without using rman
I have no backup taken in my oracle server.
Today morning i created a data file and unknowingly deleted it.
Now i need to restore the datafile with its contents without using RMAN. Iam confused could anyone help me in figuring out.
My database version is 10.2.0.1.0
my database is in archivelog mode
i created tablespace with a datafile in it. and i unknowingly dropped that datafile in unix prompt today morning. I noticed it in evening.