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 ..

What alapps wrote will work for you - you need to add "drop" after offline.

alter database open;
select name, status from v$datafile; will show that your datafile is now offline.

Thanks for all the guys that helped me to solve the problem .

alapps advise worked , I am just typing wrong full name (wrong drive) ..

offline drop worked .. Now I can open my database .

Thanks stecal
worked greate ...