10G RAC ASM无法启动



一数据库服务器意外断电, 重启发现无法启动ASM:

[Rac10g01][/home/oracle]$ srvctl start asm -n rac10g01
PRKS-1009 : 无法启动节点 "rac10g01", [PRKS-1009 : 无法启动节点 "rac10g01", [CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.rac10g01.ASM1.asm' has placement error.] 上的 ASM 实例 "+ASM1"] 上的 ASM 实例 "+ASM1"
  [PRKS-1009 : 无法启动节点 "rac10g01", [CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.rac10g01.ASM1.asm' has placement error.] 上的 ASM 实例 "+ASM1"]

试着采用如下方法解决:
[Rac10g01][/home/oracle]$ export ORACLE_SID=+ASM1
[Rac10g01][/home/oracle]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 – Production on Tue Sep 9 02:27:08 2008

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

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area   92274688 bytes
Fixed Size                  1217884 bytes
Variable Size              65890980 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> exit 
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP
and Data Mining Scoring Engine options
[Rac10g01][/home/oracle]$ srvctl status asm -n rac10g01
ASM 实例 +ASM1 正在节点 rac10g01 上运行。

启动数据库成功.

还可以采用crs相关命令解决:

1. ./crs_stat -t
ora….SM1.asm application ONLINE UNKNOWN
状态为UNKNOWN

./crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
正常

2. 执行:
./crs_stop -all
./crs_start -all
./crs_stat -t
ora….SM1.asm application ONLINE OFFLINE

3. 启动ASM
srvctl start asm -n rac10g01 -i +ASM1



发表评论