ORACLE ASM磁盘组没有mount的解决办法

作者：Mike.Xu 发表于: April 13, 2009 12:18 PM
转载时请务必以超链接形式标明文章 原始出处和作者信息及本版权声明。
链接：http://www.dbasky.net/archives/2009/04/oracle-asmmount.html
       由于数据库的数据增长很快，使得磁盘空间不够，于是绝对为生产库添加磁盘（生产库为RAC的环境），其实添加磁盘非常容易，只要细心就可以了，我现在大概说下会遇到的情况。
   （ora-01078 ora-01565 ora-17503 ora-15077)

SQL> startup;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.ora
ORA-15077: could not locate ASM instance serving a required diskgroup

可以看出diskgroup没有mount,所以先把diskgroup mount

oracle@rdb1 bdump]$ export ORACLE_SID=+ASM1
[oracle@rdb1 bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Mar 22 17:59:39 2008

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


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

SQL> shutdown immediate;
ORA-15100: invalid or missing diskgroup name


ASM instance shutdown
SQL> startup;
ASM instance started

Total System Global Area   92274688 bytes
Fixed Size                  1217884 bytes
Variable Size              65890980 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted


SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
RECOVERYDEST                   DISMOUNTED
DG1                            DISMOUNTED

SQL> alter diskgroup RECOVERYDEST mount;

Diskgroup altered.

SQL> alter diskgroup DG1 mount;

Diskgroup altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
[oracle@rdb1 bdump]$ export ORACLE_SID=devdb1
[oracle@rdb1 bdump]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Mar 22 18:07:29 2008

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

SQL> startup;
ORA-01031: insufficient privileges
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 264241152 bytes
Fixed Size                  1218868 bytes
Variable Size             109053644 bytes
Database Buffers          150994944 bytes
Redo Buffers                2973696 bytes
Database mounted.

SQL> alter database open;

Database altered.

SQL>