ORA-01181: file string created before last known RESETLOGS,
cannot recreate



ORA-01181: file string created before last known RESETLOGS, cannot recreate..

Answer / guest

Cause: Attempted to use ALTER DATABASE CREATE DATAFILE to
recreate a datafile that existed before the last known
RESETLOGS.

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 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL-02128: Sessions still exist, not logged off

1 Answers  


ORA-30393: a query block in the statement did not rewrite

1 Answers  


PCC-02358: Identifier following ARRAYLEN must be the name of an array

1 Answers  


ORA-00215: must be at least one controlfile

1 Answers  


ORA-10638: Index status is invalid

1 Answers  


NNL-00918: Time until server restart: string

1 Answers  


ORA-25455: evaluation error for rule set: string.string, evaluation context: string.string

1 Answers  


LFI-01516: read() failed (OSD return value = string) in string.

1 Answers  


ORA-12024: materialized view log on "string"."string" does not have primary key columns

1 Answers  


ORA-16014: log string sequence# string not archived, no available destinations

1 Answers  


ORA-15185: Could not close dynamic library string, error [string]

1 Answers  


DRG-11517: error when validating text objects

1 Answers  


Categories