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

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=