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

ORA-27064: cannot perform async I/O to file

1 Answers  


SQL*Loader-00906: Error executing SQL statement for upi: [number]

1 Answers  


ORA-33223: (CMOVE03) You cannot move a session-only dimension value.

1 Answers  


RMAN-07521: cannot create recovery catalog in database version string; version string required

1 Answers  


SQL*Loader-00800: %s specified and ignored

1 Answers  






ORA-22306: type "string"."string" already exists

1 Answers  


ORA-24160: name string already exists in the name value pair list

1 Answers  


PCB-00635: This attribute is only valid for Internal LOB types

1 Answers  


ORA-01019: unable to allocate memory in the user side

2 Answers  


PCB-00633: Invalid host variable and attribute pairing

1 Answers  


ORA-06252: NETNTT: cannot open address file

1 Answers  


ORA-22317: typecode number is not legal as a number type

1 Answers  


Categories