在啟動(dòng)數(shù)據(jù)庫的時(shí)候，報(bào)ORA-000205錯(cuò)誤,詳細(xì)錯(cuò)誤信息如下：
| 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 |
經(jīng)過檢查alert.log，發(fā)現(xiàn)如下內(nèi)容：
| 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 |
確認(rèn)是因?yàn)锳SM實(shí)例錯(cuò)誤導(dǎo)致數(shù)據(jù)庫實(shí)例無法啟動(dòng)，下面著手解決ASM實(shí)例問題：
啟動(dòng)ASM實(shí)例：
| 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 |
經(jīng)過檢查，發(fā)現(xiàn)ASM的參數(shù)中沒有了asm_diskgroups參數(shù)，增加
| asm_diskgroups=DATA |
修改后的asm的參數(shù)文件為：
| 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實(shí)例，能夠正常啟動(dòng)
| 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實(shí)例正常啟動(dòng)之后，數(shù)據(jù)庫實(shí)例也能夠正常啟動(dòng)了
| 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--
