重建控制文件时提示ORA-01189: file is from a different RESETLOGS than previous files

原创于 2015-04-22 12:14:49 发布 · 3.1k 阅读

0 ·

CC 4.0 BY-SA版权

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文介绍了解决在尝试重新创建控制文件时遇到的ORA-01503和ORA-01189错误的方法。当所有数据文件不在同一重置日志时间点时会出现这些错误。

CREATE CONTROLFILE REUSE DATABASE "EDWPROD" RESETLOGS  ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01189: file is from a different RESETLOGS than previous files
ORA-01110: data file 2: '/ora/prod/edwprod/data/EDWPROD/datafile/o1_mf_undotbs1_334h0kxm_.dbf’

原因：

In order to recreate the controlfile, all datafiles must be at the same incarnation, or resetlogs time.
We cannot allow datafiles to be at different incarnations.

参考自：ORA-01503 ORA-01189 When trying to Recreate Controlfile (Doc ID 1918706.1)