Oracle Database Discussions

Hi

I am running 10gR2.
For a test I have corrupted the header of an test datafile of a non system tablespace when instance was closed.

Now when I started the instance it does not open with an alert entry

Errors in file c:\oracle\oracle\product\10.2.0\db_1\admin\orcl\bdump\orcl_dbw0_512.trc:
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: 'C:\ORACLE\ORADATA\ORCL\DAMAGE_DATA.DBF'
ORA-27046: file size is not a multiple of logical block size

Now how to proceed?
When I tried to set the tablespace offline I got:

SQL> alter tablespace damage_data_ts offline;
alter tablespace damage_data_ts offline
*
ERROR at line 1:
ORA-01109: database not open

Can I just drop the datafile ?


I forgot to include, that the datafile is the only file the tablespace got.

But even the dropping the tablespace giving error, saying the database is not open

SQL> DROP TABLESPACE damage_data_ts INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE damage_data_ts INCLUDING CONTENTS AND DATAFILES
*
ERROR at line 1:
ORA-01109: database not open

Thanks