Database Backup and Recovery (MOSC)

MOSC Banner

ORA-01178: file 2 created before last CREATE CONTROLFILE, cannot recreate

edited Dec 31, 2012 2:47AM in Database Backup and Recovery (MOSC) 6 commentsAnswered
Hi,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center