重庆思庄oracle技术分享-ORA-00214 控制文件版本不一致

SQL> startup
ORACLE instance started.

Total System Global Area 4949277288 bytes
Fixed Size 9144936 bytes
Variable Size 956301312 bytes
Database Buffers 3976200192 bytes
Redo Buffers 7630848 bytes
ORA-00214: control file ‘+DATA/ORCLCDB/CONTROLFILE/current.261.1089511797’ version 10288 inconsistent with file ‘+DATA/ORCLCDB/CONTROLFILE/current.309.1094080823’ version 10274

ora-00214异常原因为控制文件版本不一致。
在数据库打开状态下，oracle服务器会随时修改控制文件中的内容。
在添加控制文件过程中如果是先复制的控制文件，后关闭数据库，
那么复制的控制文件与此前的控制文件就会不一样。

解决：
SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
ASMCMD [+data/orclcdb/controlfile] > rm current.309.1094080823
SQL> startup nomount
ORACLE instance started.

Total System Global Area 4949277288 bytes
Fixed Size 9144936 bytes
Variable Size 956301312 bytes
Database Buffers 3976200192 bytes
Redo Buffers 7630848 bytes
SQL> show parameter control

NAME TYPE VALUE

---

control_file_record_keep_time integer 7
control_files string +DATA/ORCLCDB/CONTROLFILE/curr
ent.261.1089511797, +FRA/ORCLC
DB/CONTROLFILE/current.256.108
9511797, +DATA/ORCLCDB/CONTROL
FILE/current.309.1094080823
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> alter system set control_files=‘+DATA/ORCLCDB/CONTROLFILE/current.261.1089511797’,‘+FRA/ORCLCDB/CONTROLFILE/current.256.1089511797’ scope=spfile sid=‘*’;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 4949277288 bytes
Fixed Size 9144936 bytes
Variable Size 956301312 bytes
Database Buffers 3976200192 bytes
Redo Buffers 7630848 bytes
Database mounted.
Database opened.
SQL> show parameter control

NAME TYPE VALUE

---

control_file_record_keep_time integer 7
control_files string +DATA/ORCLCDB/CONTROLFILE/curr
ent.261.1089511797, +FRA/ORCLC
DB/CONTROLFILE/current.256.108
9511797
control_management_pack_access string DIAGNOSTIC+TUNING