ora 00214 linux,ORA-00214: controlfile '/u01/app/oracle/oradata/[sid]/control01.ctl' version...

ORA-00214: controlfile '/u01/app/oracle/oradata/[sid]/control01.ctl' version inconsistent with file '/u01/app/oracle/oradata/[sid]/control03.ctl'，oraclecontrolfile

Sample error:

SQL> startup

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1321368 bytes

Variable Size 153605736 bytes

Database Buffers 130023424 bytes

Redo Buffers 262144 bytes

ORA-00214: controlfile '/u01/app/oracle/oradata/[SID]/control01.ctl' version

774562 inconsistent with file '/u01/app/oracle/oradata/[SID]/control03.ctl'

version 774558

Solution

get a backup of the control03.ctl

$ cp /u01/app/oracle/oradata/[SID]/control03.ctl /u01/app/oracle/oradata/[SID]/control03_bak.ctl

Replace control file

cp /u01/app/oracle/oradata/[SID]/control01.ctl /u01/app/oracle/oradata/[SID]/control03.ctl

output:

cp: overwrite `/u01/app/oracle/oradata/[SID]/control03.ctl'? y

alter database mount;

recover database;

alter database open;

--本篇文章参考自http://www.easywebtech.com/oracle/ORA-00214controlfile.php，http://blog.csdn.net/photnman/article/details/137572

# chown -R oracle:oinstall /u01/app/oracle /u02/oradata

# chown -R oracle:oinstall /u01/app/oracle /u02/oradata是将目录/u01/app/oracle /u02/oradata及其目录下所有 设为oracle用户和oinstall组

ORACLE数据库启动报错!

linux 4下启动Oracle 10g，安装很顺利，但是无法启动 $sqlplus时出现如下错误： sqlplus就无法启动。 alias sqlplus=

http://www.dengb.com/oracle/864270.htmlwww.dengb.comtruehttp://www.dengb.com/oracle/864270.htmlTechArticleORA-00214: controlfile /u01/app/oracle/oradata/[sid]/control01.ctl version inconsistent with file /u01/app/oracle/oradata/[sid]/control03.ctl，oraclecontrolfile Sample error: SQL...