Accidentally deleted a Datafile.
Hello everybody,
I was actually resizing datafiles, and removing unwanted datafiles. I have deleted a users (non-system, non-temporary) datafile accidentally 2 days before, and i have not taken any backup so far since the creation of this database.
Today, by the time when I have noticed that the tablespace to the corresponding datafile was still present, its too late.
I tried to create a new datafile ALTER DATABASE CREATE DATAFILE 9 AS ' /home/oracle/product/10.1.0/db_1/oradata/MYDATABASE/datafile/o1_mf_aswin_ut_3mo2pcgx_.dbf';, but it resulted in an error ORA-01276, (File has an oracle managed files file name).
RMAN is not starting with the command rman target / .
Error is
rman: can't open target.
Some one pls help me get out of this situation.
Thanks,
Aswin.