-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|