添加UDEV新磁盘规则
root@rac2 ~]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules
root@rac2 ~]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VBc95e5d3a-1aca6dfd_",NAME="asm-diskb", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VBd39a3600-e6e50a29_",NAME="asm-diskc", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VBfe998b04-e6374ba8_",NAME="asm-diskd", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB7b844853-50b66fcf_",NAME="asm-diske", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p", RESULT=="SATA_VBOX_HARDDISK_VB286943d0-617004e4_",NAME="asm-diskf", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root@rac2 ~]# ll /dev/asm*
brw-rw---- 1 grid asmadmin 8, 17 Jul 26 16:49 /dev/asm-diskb
brw-rw---- 1 grid asmadmin 8, 33 Jul 26 16:49 /dev/asm-diskc
brw-rw---- 1 grid asmadmin 8, 49 Jul 26 16:49 /dev/asm-diskd
brw-rw---- 1 grid asmadmin 8, 65 Jul 26 16:49 /dev/asm-diske
brw-rw---- 1 grid asmadmin 8, 81 Jul 26 16:49 /dev/asm-diskf
[grid@rac2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 26 17:00:32 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select GROUP_NUMBER group#,DISK_NUMBER disk#,LABEL,STATE,FAILGROUP,name,path,TOTAL_MB,FREE_MB from v$asm_disk;
向ASM中添加磁盘
SQL> ALTER DISKGROUP DATA ADD disk'/dev/asm-diskf';
Diskgroup altered.
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN Y 512 4096 1048576 18424 16229 0 16229 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 4094 3698 0 3698 0 Y OCRVT/
SQL> select GROUP_NUMBER group#,DISK_NUMBER disk#,LABEL,STATE,FAILGROUP,name,path,TOTAL_MB,FREE_MB from v$asm_disk;
GROUP# DISK# LABEL STATE FAILGROUP NAME
---------- ---------- -------------------- -------- ------------------------------ ----------
PATH TOTAL_MB FREE_MB
-------------------- ---------- ----------
1 0 NORMAL DATA_0000 DATA_0000
/dev/asm-diskc 4094 3604
1 2 NORMAL DATA_0002 DATA_0002
/dev/asm-diske 4094 3605
1 1 NORMAL DATA_0001 DATA_0001
/dev/asm-diskd 4094 3604
GROUP# DISK# LABEL STATE FAILGROUP NAME
---------- ---------- -------------------- -------- ------------------------------ ----------
PATH TOTAL_MB FREE_MB
-------------------- ---------- ----------
1 3 NORMAL DATA_0003 DATA_0003
/dev/asm-diskf 6142 5416
2 0 NORMAL OCRVT_0000 OCRVT_0000
/dev/asm-diskb 4094 3698
删除ASM磁盘
SQL> alter diskgroup DATA drop disk DATA_0003;
Diskgroup altered.
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN Y 512 4096 1048576 12282 10087 0 10087 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 4094 3698 0 3698 0 Y OCRVT/
新建磁盘组DG_NEW_DATA,将ASM_DISK_1G_3、ASM_DISK_1G_4添加到磁盘组中。
SQL> CREATE DISKGROUP DG_NEW_DATA external REDUNDANCY DISK '/dev/ASM_DISK_1G_3','/dev/ASM_DISK_1G_4';
Diskgroup created.