HI All,

VERSION 8.0.6 oracle running in Archive Mode.

Its Urgent my production system has some probs.....I will tell the the situation,,,first my junior dba added a datafile to a tablespace and which lead to the status of the datafile in RECOVER Mode....So what he did is ,,he gave a statement to Recover the datafile

Recover datafile '/path'

While it what recovering he cancled it seems...

So after that he called me and now i used the give the RECOVER DATAFILE '/path' which leads to error saying cancled during Recovery and its no not recovering it.

and what i didnt is gave alter database datafile 'path' offline drop.

and checked the status in the v$datafile but still it is RECOVER mode.

So i took the control file back and removed the entry of the newly added datafile and RECREATE the control file with RESETLOGS.

Then now i checked the status of the datafile and found its '/path/Missing00066'

Then i gave alter database RENAME file '/path/MISSING00066' to the old '/path'

But the entry in the datafile got changed from MISSING00066 to the path and the file name i gave.....but still the datafile is in RECOVER mode...Please Let me know the solution...ITS VERY VERY URGENT.

Thanks & Regards,
Vinod Kumar.