How to fix the Oracle error ORA-01181: file string created before last known RESETLOGS, cannot recreate?

In this post, you’ll learn more about the Oracle ErrorORA-01181: file string created before last known RESETLOGS, cannot recreate with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-01181: file string created before last known RESETLOGS, cannot recreate

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

How to fix the Error ORA-01181: file string created before last known RESETLOGS, cannot recreate ?

You can fix this error in Oracle by following the below steps

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