ORA-00214: control file '/.../control02.ctl'version 906 inconsistent with file '/.../control01.ctl'

问题描述

在云平台添加容器时，启动实例时显示错误ORA-00214

SQL> startup
ORACLE instance started.

Total System Global Area 6313463808 bytes
Fixed Size                  2264976 bytes
Variable Size            1191182448 bytes
Database Buffers         5100273664 bytes
Redo Buffers               19742720 bytes
ORA-00214: control file '/oracledata/fast_recovery_area/XXXXX/control02.ctl'
version 906 inconsistent with file '/oracledata/oradata/XXXXX/control01.ctl'
version 894

问题分析

1、根据错误提示为控制文件版本不一致导致。控制文件原理为维护数据库的当前物理状态，为二进制的文件，数据库打开的时候控制文件一致变化。主要记录数据库名字、标示、当前日志SCN、表空间信息等。理论上3个控制文件应该一致。
2、因为版本不一致，且控制文件2版本最新为version 906.

问题解决

1、在操作系统上，备份所有控制文件，同时使用控制文件control02.ctl覆盖重命名control01.ctl，保证版本一致。

• 备份control01.ctl

$ cp  /oracledata/oradata/XXXXX/control01.ctl  /oracledata/oradata/XXXXX/control01_bak.ctl

• 替换控制文件

[oracle@XXXXX XXXX]$ cp /oracledata/fast_recovery_area/XXXXX/control02.ctl /oracledata/oradata/XXXXX/control01.ctl

2、操作后，数据库启动正常，可以使用，问题解决。

• 重新开启数据库

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@XXXXX XXXX]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 17 14:09:56 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 6313463808 bytes
Fixed Size                  2264976 bytes
Variable Size            1191182448 bytes
Database Buffers         5100273664 bytes
Redo Buffers               19742720 bytes
Database mounted.
Database opened.