oracle 11g aix asm ora-15063,ASM:ORA-15063 错误处理方法一则

idle> startup

ASM instance started

Total System Global Area 83886080 bytes

Fixed Size 1217836 bytes

Variable Size 57502420 bytes

ASM Cache 25165824 bytes

ORA-15032: not all alterations performed

ORA-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 599

idle> alter diskgroup data mount;

alter diskgroup data mount

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-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 dropped

ORA-15001: diskgroup "DATA" does not exist or is not mounted

idle> drop diskgroup data including contents;

drop diskgroup data including contents

*

ERROR at line 1:

ORA-15039: diskgroup not dropped

ORA-15001: diskgroup "DATA" does not exist or is not mounted

查询错误信息：[oracle@localhost ~]$ oerr ora 15063

15063, 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> startup

ASM instance started

Total System Global Area 83886080 bytes

Fixed Size 1217836 bytes

Variable Size 57502420 bytes

ASM Cache 25165824 bytes

ASM diskgroups mounted

现在没抛出错误了，不过：SQL> drop diskgroup data;

drop diskgroup data

*

ERROR at line 1:

ORA-15039: diskgroup not dropped

ORA-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=5

5+0 records in

5+0 records out

5120 bytes (5.1 kB) copied, 0.011998 seconds, 427 kB/s

㈡ 在dbca ---&gt show all ---&gt 选中raw5 ---&gt 点击cancel

其实，我已经有water这个diskgroup，也mount上了，对于data这个diskgroup，可以不必管它。