vert very urgent problem

Hi Guru's ,

Here is my problem ..One of my disk crashed . It got one datafile trans.dbf . I can't startup my database ..since it is missing . How can I recreate the file . We don't need the objects in that file . We don't have real production objects in that tablespace . This tablespace trans got only one datafile trans.dbf . I know it is my bad management that I don't have backup for this datafile . Can you help to recover my database.

start the database with mount
take the missing datafile offline
open the database

Thanks for the reply . Can you pass the correct syntax to move the datafile offline;

I am trying

alter database datafile ' ' offline;


I am getting error ..nonexistent logfile,datafile,control file

alter database datafile ' / / /tbspace1.dbf' offline

offline/online work if you are in archivelog mode. Otherwise, you receive ORA-01145 error: offline immediate disallowed unless media recovery enabled. I don't believe raghud is in archivelog mode - is that correct?

specify the missing datafile with full path

raghud,

Perform an offline drop of the datafile(s) associated with that datafile and tablespace...

Start the instance

mount the controlfiles

alter database datafile 'fully qualified datafile name' offline drop;

open database

many thanks for the reply .

now I am getting error 'offline immediate disallowed unless media recovery enabled' ...

alter database datafile 'fully qualified datafile name' offline drop;

getting nonexistent datafile,logfile and tempfile

yes true ..It is my another biggest mistake I am not running on archievelog mode ..