Hi Folks,
I made a bit of a woopsy with adding a datafile to the wrong tablespace. In my initial panic as soon as i did it then i placed the datafile offline so no data would be written to it (this is a live database). I then thought to drop the datafille but i can't
Code:
ERROR at line 1:
ORA-03264: cannot drop offline datafile of locally managed tablespace
So i have to take it back online to do the drop but if i try and place online it tells me i need more media recovery (presuming just because the SCN has changed as there is no data in this file).

Now, it just so happens that RMAN is currently not operational on this database due to the version of Netbackup we are on not supporting 11g.

can i recover the datafile while the database is open?

Code:
alter database recover datafile '/ifs/dpp/live/data/IFSLIVEdts03.dbf';
alter database recover datafile '/ifs/dpp/live/data/IFSLIVEdts03.dbf'
*
ERROR at line 1:
ORA-00279: change 32018552 generated at 03/25/2011 14:28:22 needed for thread 1
ORA-00289: suggestion : /ifs/dpp/archivelogs/1_2544_741693934.dbf
ORA-00280: change 32018552 for thread 1 is in sequence #2544