ORA-00214: controlfile & amp; #39;/u01/app/oracle/oradata/[sid]/control01.ctl & amp; #39; version inconsistent with file & amp; #39; /u01/app/oracle/oradata/[sid]/control03.ctl & #39;, 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;

-- This article reference self-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 is to set the directory/u01/app/oracle/u02/oradata and all the files in the directory as oracle users and oinstall groups
 
ORACLE Database startup error!

Starting Oracle 10g in linux 4 is successful, but the following error occurs when $ sqlplus cannot be started: sqlplus cannot be started. Alias sqlplus =