Process to check existing Disk Groups:
Step 1: Export oracle SID for ASM instance and connect sqlplus as sysasm user.
[[email protected] ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.2.0 Production on Sat Aug 5 18:24:39 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Automatic Storage Management option SQL> show parameter instance_type NAME TYPE VALUE ---------------------- ----------- ------------------------------ instance_type string asm
Step 2: We can use v$asm_diskgroup to query existing disk groups information.
SQL>select NAME,STATE ,TYPE , COMPATIBILITY from v$asm_diskgroup; NAME STATE TYPE COMPATIBIL ------------------------- ----------- ------ ---------- ASM_SPF_DATA MOUNTED EXTERN 11.2.0.0.0 ASM_DG_DATA MOUNTED EXTERN 11.2.0.0.0
NOTE: You can see that there are 2 disk groups are available.
Step 3: In order to check what are all disks are associated with each disk group, we can query below using v$asm_disk dictionary.
SQL>select DISK_NUMBER ,MOUNT_STATUS ,HEADER_STATUS,REDUNDANCY,NAME from v$asm_disk;
NOTE: We can see that VOL1 and VOL3 are associated with the other disk groups and other disks are available to add.
Step 4: Execute xhost+ command in root user to enable GUI mode
Step 5: Switch to grid user and execute asmca command which will prompt asm configuration assistant pop-up.
[[email protected] ~]# xhost + access control disabled, clients can connect from any host [[email protected] ~]# su - grid [[email protected] ~]$ which asmca /u01/app/grid/product/11.2.0/grid_home/bin/asmca [[email protected] ~]$ asmca
Press ENTER.
Step 6: Right mouse click on the disk group to which you want to add a new disk and press “Add Disks”.
Step 7: It will show you with the eligible disks which can be added to the disk group. Select the disk you wanted to add (I have selected the “ORCL_VOL2”) and press OK.
NOTE: Here we have successfully added a new disk to the Disk Group ASM_DG_DATA .
Step 8: Now again query the same syntax to see whether the VOL2 disk is added to the group or not.
Creating a manually disk group:
Manually Creating a Disk Group ASM_DG_FRA .
Manually Adding a Disk from Existing Disk Group and To check the Disk are Adding or Not:
Manually Dropping A disk from Existing Disk Group: