Ora-00214:control File Control version inconsistency

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.