1.启动报错
ORA-00214: control file '/u01/app/oracle/oradata/PROD/control01.ctl' version 2650 inconsistent with file '/u01/app/oracle/oradata/PROD/control03.ctl' version 2635
2.原因分析
控制版本号不一致,可以看到03的日志比01的日志版本号小
3.解决方法
先将03文件备份,然后将01文件复制一份为03文件名 [oracle@MES PROD]$ mv control03.ctl control03.ctl.bak [oracle@MES PROD]$ cp control01.ctl control03.ctl
4.启动数据库
SYS@PROD> select status from v$instance; STATUS ------------ STARTED SYS@PROD> alter database mount; Database altered. SYS@PROD> alter database open; Database altered. SYS@PROD> select status from v$instance; STATUS ------------ OPEN