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

ORA-01177: data file does not match dictionary - probably old incarnation
Cause: 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: Do a CREATE CONTROLFILE with the correct file or none at all.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01177：数据文件不匹配字典 - 可能是老化身,
.原因：在CREATE CONTROLFILE或OPEN RESETLOGS之后将控制文件与数据字典进行比较时，会注意到此数据文件与字典不一致。很可能该文件是从数据库中删除的文件的备份，并且相同的文件编号被重新用于一个新文件。也可能是在此文件编号用于另一个数据文件时停止不完全恢复。,
.操作：使用正确的文件或不使用CREATE CONTROLFILE。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题