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

时间:2015-04-22 13:56:09   收藏:0   阅读:951

 

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)

 

原文:http://blog.csdn.net/msdnchina/article/details/45193351

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!