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



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

Answer / guest

Cause: Attempted to use ALTER DATABASE CREATE DATAFILE to
recreate a datafile that existed at the last CREATE CONTROL
file command. The information needed to recreate the file
was lost with the controlfile that existed when the file was
added to the database.

Action: Find a backup of the file, and recover it. Do
incomplete recovery to time before file was originally created.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

TNS-04235: Trace Assistant WARNING: Unknown TTC protocol

1 Answers  


PCC-02206: Host variables are not permitted within a DDL statement

1 Answers  


ORA-38730: Invalid SCN/TIMESTAMP expression.

1 Answers  


QSM-01097: Materialized view with grouping sets has too long key

1 Answers  


ORA-01033: ORACLE initialization or shutdown in progress

2 Answers  






ORA-01104: number of controlfiles (string) does not equal string

1 Answers  


ORA-24191: the property name string has existed

1 Answers  


ORA-02773: Invalid maximum client wait time

1 Answers  


RMAN-06709: No scripts in recovery catalog

1 Answers  


ORA-26716: message limit reached

1 Answers  


DRG-50933: parser hash insert failure

1 Answers  


RMAN-10040: asynchronous support not detected, RMAN will run synchronously

1 Answers  


Categories