控制文件多路径复用ORA-00205错误

1.配置控制文件多路径复用，执行以下命令成功

SQL> alter system set control_files='/oradata/orcl/control01.ctl','/oradata/orcl/control02.ctl' scope=spfile;

System altered.

SQL> 

2.正常关闭数据库

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> 

3.操作系统层面复制控制文件，实现多路径复用

[oracle@oracle11g orcl]$ ll
total 1771904
-rw-r----- 1 oracle oinstall   9748480 Jun 18 09:54 control02.ctl
-rw-r----- 1 oracle oinstall  52429312 Jun 18 09:48 redo01.log
-rw-r----- 1 oracle oinstall  52429312 Jun 18 09:48 redo02.log
-rw-r----- 1 oracle oinstall  52429312 Jun 18 09:50 redo03.log
-rw-r----- 1 oracle oinstall 555753472 Jun 18 09:50 sysaux01.dbf
-rw-r----- 1 oracle oinstall 807411712 Jun 18 09:50 system01.dbf
-rw-r----- 1 oracle oinstall  20979712 Jun 18 09:48 temp01.dbf
-rw-r----- 1 oracle oinstall 209723392 Jun 18 09:50 TOBACCO.dbf
-rw-r----- 1 oracle oinstall  57679872 Jun 18 09:50 undotbs01.dbf
-rw-r----- 1 oracle oinstall  14426112 Jun 18 09:50 users01.dbf

[oracle@oracle11g orcl]$ cp control02.ctl control01.ctl 


[oracle@oracle11g orcl]$ ll
total 1781424
-rw-r----- 1 oracle oinstall   9748480 Jun 18 09:54 control01.ctl
-rw-r----- 1 oracle oinstall   9748480 Jun 18 09:54 control02.ctl
-rw-r----- 1 oracle oinstall  52429312 Jun 18 09:48 redo01.log
-rw-r----- 1 oracle oinstall  52429312 Jun 18 09:48 redo02.log
-rw-r----- 1 oracle oinstall  52429312 Jun 18 09:50 redo03.log
-rw-r----- 1 oracle oinstall 555753472 Jun 18 09:50 sysaux01.dbf
-rw-r----- 1 oracle oinstall 807411712 Jun 18 09:50 system01.dbf
-rw-r----- 1 oracle oinstall  20979712 Jun 18 09:48 temp01.dbf
-rw-r----- 1 oracle oinstall 209723392 Jun 18 09:50 TOBACCO.dbf
-rw-r----- 1 oracle oinstall  57679872 Jun 18 09:50 undotbs01.dbf
-rw-r----- 1 oracle oinstall  14426112 Jun 18 09:50 users01.dbf

4.启动数据库，到mount阶段数据库报错

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00214: control file '/oradata/orcl/control02.ctl' version 2480 inconsistent
with file '/oradata/orcl/control01.ctl' version 2477

 

后台日志

alter database mount
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oradata/orcl/control01.ctl,/oradata/orcl/control02.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: alter database mount...

 

到这里非常的奇怪，根据提示是无法打开这个控制文件，获取不到这个文件状态，操作系统层面无法找到这个文件

 

5.重新执行SQL语句，使用双引号，启动数据库成功

SQL> alter system set control_files="/oradata/orcl/control01.ctl","/oradata/orcl/control02.ctl" scope=spfile;

System altered.

SQL> startup force
ORACLE instance started.

Total System Global Area  864333824 bytes
Fixed Size                  2258120 bytes
Variable Size             289409848 bytes
Database Buffers          566231040 bytes
Redo Buffers                6434816 bytes
Database mounted.
Database opened.
SQL>

 

转载于:https://www.cnblogs.com/hanglinux/p/11045617.html