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

RMAN-08150: created global script string

1 Answers  


ORA-02196: PERMANENT/TEMPORARY option already specified

1 Answers  


ORA-07284: sksaprd: volume size specification not terminated properly.

1 Answers  


PLS-00151: Expression or Variable is an illegal type to PLS/QL: string

1 Answers  


ORA-09752: pw_attachPorts: port_allocate failed.

1 Answers  


ORA-08193: Flashback Table operation is not allowed on temporary tables

1 Answers  


ORA-29894: base or varray datatype does not exist

1 Answers  


ORA-01153: an incompatible media recovery is active

1 Answers  


ORA-24055: cannot delete propagation status rows that are in prepared state

1 Answers  


PLS-00565: %s must be completed as a potential REF target (object type)

1 Answers  


ORA-24151: no evaluation context is associated with rule string.string or rule set string.string

1 Answers  


PLS-00162: Pragma string expects 4th argument to be a positive integer literal

1 Answers  


Categories