Problem in Recovery

[seelan]

Hi all,

By mistake I deleted one datafile from users tablespace. But I don't have any backup for that.


I am doing recovery in my database.

I have created a new controlfile using trace file without adding that deleted datafile

Database mounted and controlfile created

When I am issuing the command

select name from v$datafile in the mounting stage it shows me all the valid datafile name.


But after issuing the command

alter database open;

If I am giving select name from v$datafile in the open stage

it shows me one extra file

ie) c:\oracle\ora81\database\missing0008.ora

But the database is working properly! But I can't take the hot backup for users tablespace because of this missing file

Can anyone solve my problem


Seelan

[marist89]

http://download-west.oracle.com/docs...ackup.htm#5820

[pando]

well if you think you can fool Oracle by creating a dummy file .....