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

ORA-36691: (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.

1 Answers  


ORA-28602: statement not permitted on tables containing bitmap indexes

1 Answers  


ORA-26711: remote table does not contain a primary key constraint

1 Answers  


ORA-02330: datatype specification not allowed

1 Answers  


ORA-19598: can not backup SPFILE because the instance was not started with SPFILE

1 Answers  






ORA-09265: spwat: error temporarily suspending process

1 Answers  


RMAN-06551: error while looking up datafilecopy for file number: string

1 Answers  


ORA-25409: failover happened during the network operation,cannot continue

1 Answers  


ORA-24195: attemp to retrieve the name list of a map message with size exceeding 1024

1 Answers  


ORA-31693: Table data object string failed to load/unload and is being skipped due to error: string

1 Answers  


ORA-07474: snclrd: close error, unable to close sgadef.dbf file.

1 Answers  


RMAN-06515: archived logs required to recover from this copy will expire when this copy expires

1 Answers  


Categories