Failure phenomena:
Learn Oracle Control file movement and modification today, and discover that only one control file was used when the native installation Oracle database was started.
The following:sql> select * from V$controlfile;
STATUS NAME is_ block_size file_size_blks
------- -------------------- --- ---------- --------------
/opt/oracle/oradata/no 16384 450
Orcl/control02.ctl
1, decided to add control files 01 and 03, so the execution of the command is as follows:
Sql> alter system set Control_files = '/opt/oracle/oradata/orcl/control01.ctl ',
2 '/opt/oracle/oradata/orcl/control02.ctl ',
3 '/opt/oracle/oradata/orcl/control03.ctl ' scope=spfile;
System altered.
2, close the database sql> shutdown immediate;
3, start the database again, the data can not start, error ORA-00214 as follows:
Sql> Startup
ORACLE instance started.
Total System Global area 1258291200 bytes
Fixed Size 1219160 bytes
Variable Size 318768552 bytes
Database buffers 922746880 bytes
Redo buffers 15556608 bytes
Ora-00214:control file '/opt/oracle/oradata/orcl/control02.ctl ' version 599
Inconsistent with file '/opt/oracle/oradata/orcl/control01.ctl ' version 541
Fault analysis
1, according to the error prompts for control file version inconsistency caused. The control file principle is to maintain the current physical state of the database, for binary files, when the database is open, the control file changes uniformly. The main record database name, marking, the current log SCN, tablespace information and so on. Theoretically 3 control files should be consistent.
2, because the version is inconsistent, and the control file 2 version of the latest edition 599.
Fault resolution
1, on the operating system, back up all control files, while using the control file Control02.ctl overwrite rename control01.ctl, Control03.ctl, ensure that the version is consistent .
2, after the operation, the database starts normal, can use, the problem solves.
Ora-00214:control File Control version inconsistency