oracle超级管理员账号密码重建控制文件时提示ORA-01189:fileis from a different RESETLOGS than previous files

发表于2020年3月6日由oracle

 

CREATE CONTROLFILE REUSE DATABASE "EDWPROD" RESETLOGS  ARCHIVELOG*ERROR at line 1:ORA-01503: CREATE CONTROLFILE failedORA-01189: file is from a different RESETLOGS than previous filesORA-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 oracle账号incarnations.

 

此条目发表在oracle metalink账号分类目录，贴了标签。将固定链接加入收藏夹。