ORA-00205 error in identifying control file 问题解决一例

最新推荐文章于 2024-05-16 15:21:27 发布

csdn_0706

最新推荐文章于 2024-05-16 15:21:27 发布

阅读量4.8k

点赞数 1

文章标签：数据库操作系统运维

在启动数据库的时候，报ORA-000205错误,详细错误信息如下：

idle> startup
ORACLE instance started.

Total System Global Area 209715200 bytes
Fixed Size 1218532 bytes
Variable Size 109053980 bytes
Database Buffers 92274688 bytes
Redo Buffers 7168000 bytes
ORA-00205: error in identifying control file, check alert log for more info

经过检查alert.log，发现如下内容：

[@more@]

ALTER DATABASE MOUNT
Fri Feb 12 19:03:53 2010
Starting background process ASMB
ASMB started with pid=17, OS id=23258
Fri Feb 12 19:03:53 2010
ORA-00202: control file: '+DATA/cnhtm/controlfile/control01.dbf'
ORA-17503: ksfdopn:2 Failed to open file +DATA/cnhtm/controlfile/control01.dbf
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-15055: unable to connect to ASM instance
Fri Feb 12 19:03:57 2010

确认是因为ASM实例错误导致数据库实例无法启动，下面着手解决ASM实例问题：

启动ASM实例：

ora_test@oracle[/oracle/app/10.1/dbs]> export ORACLE_SID=+ASM

ora_test@oracle[/oracle/app/10.1/dbs]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 12 19:14:12 2010

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
idle> startup
ASM instance started

Total System Global Area 79691776 bytes
Fixed Size 1217812 bytes
Variable Size 53308140 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted

经过检查，发现ASM的参数中没有了asm_diskgroups参数，增加

asm_diskgroups=DATA

修改后的asm的参数文件为：

ora_test@oracle[/oracle/app/10.1/dbs]> cat $ORACLE_HOME/dbs/init+ASM.ora
instance_type=asm
instance_name=+ASM
asm_diskgroups=DATA

然后再重启asm实例，能够正常启动

ora_test@oracle[/oracle/app/10.1/dbs]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 12 19:16:38 2010

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
idle> startup pfile='?/dbs/init+ASM.ora'
ASM instance started

Total System Global Area 79691776 bytes
Fixed Size 1217812 bytes
Variable Size 53308140 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted

用pfile生成spfile

idle> create spfile from pfile;

File created.

idle>

在asm实例正常启动之后，数据库实例也能够正常启动了

ora_test@oracle[/oracle/app/10.1/dbs]> export ORACLE_SID=cnhtm

ora_test@oracle[/oracle/app/10.1/dbs]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 12 19:17:20 2010

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

idle> shutdown immediate
ORA-01507: database not mounted

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

Total System Global Area 209715200 bytes
Fixed Size 1218532 bytes
Variable Size 109053980 bytes
Database Buffers 92274688 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.

--end--

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22049049/viewspace-1031251/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22049049/viewspace-1031251/