一数据库服务器意外断电, 重启发现无法启动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