72 积分	0 好友	11 主题

发消息

oracle 10g asm 的怪异的问题

1^#

发表于 2012-8-6 21:42:01 | 查看: 4490| 回复: 4

oracle 10.2.0.4  rac +asm os solaris 10 + sc3.1
问题描述：
GROUP_NUMBER DISK_NUMBER TOTAL_MB FREE_MB NAME                         FAILGROUP                   PATH                                                                                                                                                                                                                                                          MOUNT_S STATE MODE_ST REDUNDA
------------ ----------- ---------- ---------- ------------------------------ ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------- -------- ------- -------
         2          1 1710985 1561837 DATA_0001                   DATA_0001                   /dev/rdsk/c0t60080E50002DC5000000037A5017350Dd0s6                                                                                                                                                                                                             CACHED  NORMAL ONLINE  UNKNOWN
         2          2 1710985 1561837 DATA_0002                   DATA_0000                   /dev/rdsk/c0t60080E50002DC1F00000048D50173243d0s6                                                                                                                                                                                                             CACHED  NORMAL ONLINE  UNKNOWN

DATA  是一个dg（NORMAL）。里面有两个磁盘 DATA_0001  DATA_0002 分别来自两个存储
有两个failgroup DATA_0001 DATA_0000  每个里面都只有一个磁盘。
上面看起来很正常

当一个存储断电上面有磁盘DATA_0002.
出现如下情况，

QL> select group_number,disk_number,total_mb,free_mb,name,failgroup,path,mount_status,state,mode_status,REDUNDANCY from v$asm_disk  order by  group_number,disk_number,failgroup,path,mount_status,state,mode_status,REDUNDANCY;

GROUP_NUMBER DISK_NUMBER TOTAL_MB FREE_MB NAME                         FAILGROUP                   PATH                                                                                                                                                                                                                                                          MOUNT_S STATE MODE_ST REDUNDA
------------ ----------- ---------- ---------- ------------------------------ ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------- -------- ------- -------
         2          1 1710985       0 DATA_0001                                                    /dev/rdsk/c0t60080E50002DC5000000037A5017350Dd0s6                                                                                                                                                                                                             OPENED  NORMAL ONLINE  UNKNOWN
         2          2       0       0 DATA_0002                   DATA_0000                                                                                                                                                                                                                                                                                     MISSING NORMAL OFFLINE UNKNOWN

居然连path也没有了。麻烦老大给看看

分享0