ASM:ORA-15063 错误处理方法一则
idle> startupASM instance startedTotal System Global Area 83886080 bytesFixed Size 1217836 bytesVariable Size 57502420 bytesASM Cache 25165824 bytesORA-15032: not all alterations performedORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"idle> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB------------ ---------- --------------------------------- ---------- ---------- 0 DATA DISMOUNTED 0 0 2 WATER MOUNTED 2744 599idle> alter diskgroup data mount;alter diskgroup data mount*ERROR at line 1:ORA-15032: not all alterations performedORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"idle> drop diskgroup data;drop diskgroup data*ERROR at line 1:ORA-15039: diskgroup not droppedORA-15001: diskgroup "DATA" does not exist or is not mountedidle> drop diskgroup data including contents;drop diskgroup data including contents*ERROR at line 1:ORA-15039: diskgroup not droppedORA-15001: diskgroup "DATA" does not exist or is not mounted
查询错误信息：
[oracle@localhost ~]$ oerr ora 1506315063, 00000, "ASM discovered an insufficient number of disks for diskgroup \"%s\""// *Cause: ASM was unable to find a sufficient number of disks belonging to the// diskgroup to continue the operation.// *Action: Check that the disks in the diskgroup are present and functioning, // that the owner of the ORACLE binary has read/write permission to // the disks, and that the ASM_DISKSTRING initialization parameter // has been set correctly. Verify that ASM discovers the appropriate // disks by querying V$ASM_DISK from the ASM instance.
处理步骤：
① /etc/init.d/init.cssd stop
② /etc/init.d/init.cssd start
③ sleep 90
④ restart ASM instance and shutdown immediate
⑤ again restart ASM instance
idle> startupASM instance startedTotal System Global Area 83886080 bytesFixed Size 1217836 bytesVariable Size 57502420 bytesASM Cache 25165824 bytesASM diskgroups mounted
现在没抛出错误了，不过：
SQL> drop diskgroup data;drop diskgroup data*ERROR at line 1:ORA-15039: diskgroup not droppedORA-15001: diskgroup "DATA" does not exist or is not mounted
由于10g中还没有drop diskgroup force的语法，所以这里我们借助linux的dd和dbca配合来强制删除这个老顽固。
步骤：
㈠ 通过查询可知raw5挂在了data身上：
[root@localhost ~]# dd if=/dev/zero of=/dev/raw/raw5 bs=1024 count=55+0 records in5+0 records out5120 bytes (5.1 kB) copied, 0.011998 seconds, 427 kB/s
㈡ 在dbca ---> show all ---> 选中raw5 ---> 点击cancel
其实，我已经有water这个diskgroup，也mount上了，对于data这个diskgroup，可以不必管它。
