重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-00214 控制文件版本不一致 [打印本页]

作者: denglj 时间: 2022-4-1 17:12
标题: 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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)