生产环境因堡垒机因堡垒机影响、系统影响导致无法打开图形界面查看那些磁盘可以加入到ASM磁盘组,通过grid用户进入sqlplus / as sysasm 查看结果
首先使用语句查看:
SQL> select GROUP_NUMBER,DISK_NUMBER, MODE_STATUS,HEADER_STATUS, MODE_STATUS,state,TOTAL_MB,FREE_MB,name,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-diske
2 0 ONLINE MEMBER ONLINE NORMAL 5120 5032 NEWDATA_0000 /dev/asm-diskd
1 0 ONLINE MEMBER ONLINE NORMAL 5120 732 DATA_0000 /dev/asm-diskc
3 0 O