Oracle DB Error ORA-01177 data file does not match dictionary - probably old incarnation

The following is the cause of this error:

When comparing the control file with the data dictionary after a CREATE CONTROLFILE or OPEN RESETLOGS, it was noted that this datafile was inconsistent with the dictionary. Most likely the file is a backup of a file that was dropped from the database, and the same file number was reused for a new file. It may also be that an incomplete recovery stopped at a time when this file number was used for another datafile.

Action you can take to resolve this issue: Do a CREATE CONTROLFILE with the correct file or none at all.

Tags: Database, Education, Software

Related