ORA-01177: data file does not match dictionary

ORA-01177: data file does not match dictionary - probably
old incarnation

Question Posted / guest

1 Answers
3234 Views
I also Faced
E-Mail Answers

ORA-01177: data file does not match dictionary - probably old incarnation..

Answer / guest

Cause: When comparing the controlfile 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: Do a CREATE CONTROLFILE with the correct file or
none at all.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer