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

PCC-02364: Host struct and its indicator must have the same number of fields

1 Answers  


DRG-11116: value of string must be less than or equal to value of string

1 Answers  


ORA-21501: program could not allocate memory

1 Answers  


NNL-00804: Queries received, type META-DATA: number

1 Answers  


TNS-00557: unsupported wallet retrieval method

1 Answers  






PLS-00213: package STANDARD not accessible

1 Answers  


PLS-00337: "string" matches too many object table aliases

1 Answers  


NNO-00703: checkpoint interval changed to number seconds

1 Answers  


ORA-24150: evaluation context string.string does not exist

1 Answers  


ORA-01521: error in adding data files

1 Answers  


ORA-22807: cannot resolve to a scalar type or a collection type

1 Answers  


TNS-03505: Failed to resolve name

1 Answers  


Categories