在grid用户下(安装ASM的时候,设置的磁盘组名称和重装前一样的)
使用asmca无法打开图形界面,报错如下:
sqlplus / as sysasm登陆
使用以下命令查询可用的/dev/设备
SQL> select group_number,disk_number,header_status,mode_status,state,total_mb,name,failgroup,path from v$asm_disk;
GROUP_NUMBER DISK_NUMBER MODE_ST HEADER_STATU MODE_ST STATE TOTAL_MB FREE_MB NAME PATH
------------ ----------- ------- ------------ ------- -------- ---------- ---------- ------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0 0 ONLINE CANDIDATE ONLINE NORMAL 0 0 /dev/asm_vdd
0 1 ONLINE CANDIDATE ONLINE NORMAL 0 0 /dev/asm_vdj
0 2 ONLINE CANDIDATE ONLINE NORMAL 0 0 /dev/asm_vdg
0 7 ONLINE CANDIDATE ONLINE NORMAL 0 0 /dev/asm_vdb
0 4 ONLINE CANDIDATE ONLINE NORMAL 0 0 /dev/asm_vdf
0 5 ONLINE CANDIDATE ONLINE NORMAL 0 0 /dev/asm_vde
0 6 ONLINE CANDIDATE ONLINE NORMAL 0 0 /dev/asm_vdh
0 3 ONLINE CANDIDATE ONLINE NORMAL 0 0 /dev/asm_vdi
8 rows selected.
使用以下命令查询磁盘组是空的:
SQL> select name,state from v$asm_diskgroup;
no rows selected
--添加ASM磁盘组
SQL> Create diskgroup DATA external redundancy disk '/dev/asm_vdd';
Diskgroup created.
--再次查询就有磁盘组了
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATA MOUNTED
将其他磁盘加入磁盘组
SQL> alter diskgroup +data add disk '/dev/asm_vde';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28371090/viewspace-2152220/,如需转载,请注明出处,否则将追究法律责任。