ORA-01178: file 2 created before last CREATE CONTROLFILE, cannot recreate
I have cloned a database and its giving me this error.
SQL> alter database create datafile '/soft/oracle/product/11.2.0/dbs/MISSING00002' as '/oradata/test02/sysaux01.dbf';
alter database create datafile '/soft/oracle/product/11.2.0/dbs/MISSING00002' as '/oradata/test02/sysaux01.dbf'
*
ERROR at line 1:
ORA-01178: file 2 created before last CREATE CONTROLFILE, cannot recreate
ORA-01111: name for data file 2 is unknown - rename to correct file
ORA-01110: data file 2: '/soft/oracle/product/11.2.0/dbs/MISSING00002'
SQL> select file#,status from v$datafile;
FILE# STATUS
---------- -------
1 SYSTEM
2 RECOVER
3 ONLINE
4 ONLINE
5 ONLINE
6 ONLINE
7 ONLINE
7 rows selected.