Hi,

I mistakenly added a datafile to tablespace CWMLITE. Since I'm running in archive mode, I took the datafile offline (like Oracle mentions in note: 111316.1).

ALTER DATABASE DATAFILE OFFLINE;

Now the datafile is still 1G in size (i took it immediately offline, so no data is in it). When I try to put it online again to resize I get ora-01113: needs mediarecovery (which I think is normal for every datafile you want to put online again).

How can I get the datafile back online ? I do not have the archives anymore, but would I need them anyway to get it back online ?

If I can not get it back online, would there be any problem when I startup the database again ?
The status in v$datafile is RECOVER and in dba_data_files the status is AVAILABLE, shouldn't that be OFFLINE ?

Thanks,
Kris