How to fix the Oracle error ORA-01189: file is from a different RESETLOGS than previous files?

In this post, you’ll learn more about the Oracle ErrorORA-01189: file is from a different RESETLOGS than previous files with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01189: file is from a different RESETLOGS than previous files

Reason for the Error ORA-01189: file is from a different RESETLOGS than previous files

In a CREATE CONTROLFILE command either this file or all previous files were backups from before the last RESETLOGS. This may also occur if this is a file that is offline and has been offline since before the last RESETLOGS.

How to fix the Error ORA-01189: file is from a different RESETLOGS than previous files ?

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

If the file was taken offline normal before the last RESETLOGS, and is still offline, omit it from the CREATE CONTROLFILE command. Rename and online the file after the database is open. Otherwise find the version of the mentioned file consistent with the rest of the datafiles and resubmit the command.