Hi all,
I have an oracle database in 11.0.2.4 which contains about 4000 tables and 8800 indexes. A few days ago, I created a file and I made a mistake on his name.
And instead of removing it right away, I put it offline. It is since in recover mode.
So I recreated the controlfile (alter database backup controlfile to trace) by removing the part concerning this recordir recover. Unfortunately, he went "missing".
FILE # ---------- NAME -------------------------------------------------- ------------------------------ STATUS -------
7 /opt/oracle/product/11.2.0/dbhome_2/dbs/MISSING00007 RECOVER
and on the shell:
ORA-01673: data file 7 has not been identified
ORA-01111: name for data file is unknown - rename to correct file
ORA-01110: data file 7: '/opt/oracle/product/11.2.0/dbhome_2/dbs/MISSING00007'
Since, I can not make consistent backup, and most importantly, I can not switch to a standby (this database must be migrated to ODA).
I am proposed to rebuild in tablespace where this file is filled by moving all datafiles to a new tablespace.
Each manipulation leads to a new problem.
Do you have any idea how I can migrate this now incoherent base to a cleaner base on my ODA?