deleted datafile. How do I recover?

[dev]

Please help!

I have deleted a physical datafile space on Unix box before dropping the tablespace in Oracle. After the fact, when I try to drop Oracle tablespace the Instance crashed. I started the instance in mount mode, try to alter the tablespace offline Oracle tell me db is not open. I then tried to alter db open, I receive error 01157 cannot identify/lock datafile and ora 01110 datafile /oracle/----/----/ datafile"name".
How do I recover Oracle without having to do a backup of the datafile? This datafile has no useful purpose.
Is their a way to recover form this?
THanks
Dev

[rsuri]

did you try either of the following at the mount stage --

alter database datafile 3 offline;

or

alter database datafile 3 offline drop;

you can use the datafile name also with the full path

- Rajeev

[jgmagnus]

you need to take the datafile offline, not the tablespace.

- mount the database

- then issue:
alter database datafile
'/disk2/data/datafile_name.dbf' offline;

try that.

- Magnus

[dev]

Thank Rajeev
When I tried datafile offline the following message occur>
ORA-01145: offline immediate disallowed unless media recovery enabled. Any suggestion how to do this. I am reading up on this. I am a Newbie in Oracle and a have been in MSSQL.
thanks
dev

[dev]

Magnus. Thank you too! Please read my reply to Rajeev and see how you can assist.
Dev

[dev]

Thanks fells the off line drop methos work.
cheers
Dave

[jgmagnus]

WHOO-HOOO!