欢迎投稿

今日深度:

重建控制文件时提示ORA-01189:fileis from a different

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


 

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.

 

www.htsjk.Com true http://www.htsjk.com/oracle/23254.html NewsArticle 重建控制文件时提示ORA-01189:fileis from a different RESETLOGS than previous files CREATE CONTROLFILE REUSE DATABASE EDWPROD RESETLOGS ARCHIVELOG*ERROR at line 1:ORA-01503: CREATE CONTROLFILE failedORA-01189: file is from a differen...
评论暂时关闭