Deleted datafile by mistake

[tpclouis]

Hi All,


I had some unwanted tablespaces . I dropped all of them except one. I deleted all the datafiles aasociated with these tablespaces including the datafile of the tablespace which I forgot to drop;

I did'nt notice this , but when I restarted the database , it gives the error
ORA-01110: data file 24: '/oradata/oradata/MAPS/MAP_RBS_GEN_DF01.DBF'
ORA-01115: IO error reading block from file 24 (block # 1)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file

I tried through server manager but , not able to make the tablespace offline without opening the database.


Can anybody suggest me which way can I open the database.

Thanks in Advance.

Louis.

[kgb]

In this case try to drop datafile from database:
ALTER DATABASE DATAFILE '/oradata/oradata/MAPS/MAP_RBS_GEN_DF01.DBF' OFFLINE DROP;

After that try to open database,
alter tablespace offline immediate;
drop tablespace 'ts';

[anandkl]

In which mode r u running ur database.If its in noarchive log mode,use alter database datafile 'filename' offline drop;
else if ur database is running in archive log mode.
start ur database in mount phase, take the datafile offline.And then take the tablespace offline and then drop it.