Oracle database error code ORA-01181 – file string created before last known RESETLOGS, cannot recreate

Oracle Database Error Code ORA-1181 Description :
file string created before last known RESETLOGS, cannot recreate
Error Cause:
Attempted to use ALTER DATABASE CREATE DATAFILE to recreate a datafile that existed before the last known RESETLOGS.

How to Solve :
Find a backup of the file, and recover it. Do incomplete recovery to time before file was originally created.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , , ,
No Comment Yet   
«
»