datafile needs media recovery
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