Originally posted by pnrdba
I may be wrong, but you can try like this, (only if you can mount the DB).

Recreate the control file by doing:
Alter database backup control file to trace.
Edit the control file, remove the entries of the deleted .dbf, recreate a new one, and then open the database.

But any how, as your DB is in no-archive mode, to be safer side, you have to drop that tablespace and recreate it again cleanly (ofcourse, take export of that before doing) for the complete recovery in future.

Gurus , please correct me if i'm wrong.

Thanks

wrong and non-working, look the thread I posted