diskgroup3 j加盘不成功

chenghuaming · 发表于 2016-12-13 21:55:16

唐老师：

         C:\Users\Administrator\Desktop\QQ截图

      SQL> alter diskgroup diskgroup3 add disk '/dev/raw/raw4';

      Diskgroup altered.
--------------------
   查v$asm_disk 看不到盘,请唐老师看下

chenghuaming · 发表于 2016-12-13 21:56:13

TOTAL_MB 0
FREE_MB 0
HOT_USED_MB 0
COLD_USED_MB 0
NAME
FAILGROUP
LABEL
PATH /dev/raw/raw4
UDID
PRODUCT
CREATE_DATE
MOUNT_DATE
REPAIR_TIMER 0
READS
WRITES
READ_ERRS
WRITE_ERRS
READ_TIME
WRITE_TIME
BYTES_READ
BYTES_WRITTEN
PREFERRED_READ U
HASH_VALUE 0
HOT_READS
HOT_WRITES
HOT_BYTES_READ
HOT_BYTES_WRITTEN
COLD_READS
COLD_WRITES
COLD_BYTES_READ
COLD_BYTES_WRITTEN
VOTING_FILE N
SECTOR_SIZE 512
FAILGROUP_TYPE REGULAR

botang · 发表于 2016-12-14 23:35:02

chenghuaming 发表于 2016-12-13 21:56
TOTAL_MB 0
FREE_MB 0
HOT_USED_MB 0

不要把 raw 类型的磁盘加到oracleasmlib类型的磁盘组

chenghuaming · 发表于 2016-12-15 12:05:50

怎么看是oracleasmlib类型的磁盘组？， diskgroup3另外三个盘我都是用裸设备绑的

botang · 发表于 2016-12-15 15:16:32

chenghuaming 发表于 2016-12-15 12:05
怎么看是oracleasmlib类型的磁盘组？， diskgroup3另外三个盘我都是用裸设备绑的

select PATH from v$asm_disk;

复制代码

看路径就可以判断。