April 27, 2012

How to add new disk to Disk Group on ASM

Hi Guys, just to take a note to add new disk to Disk Group on ASM

Change the owner of the raw disk
chown -R grid:asmadmin /dev/rhdisk35
chown -R grid:asmadmin /dev/rhdisk36

chmod 660 /dev/rhdisk35
chmod 660 /dev/rhdisk36

Cek the current disk attach to relevant diskgroup
SELECT B.NAME, A.PATH, B.STATE, A.HEADER_STATUS, A.FREE_MB, A.TOTAL_MB
FROM V$ASM_DISK A, V$ASM_DISKGROUP B
where A.GROUP_NUMBER=B.GROUP_NUMBER
      AND B.NAME like '%DISKGROUPNAME%'
order by path;

Cek for the candidate disk
SELECT HEADER_STATUS,TOTAL_MB,PATH FROM V$ASM_DISK;

SELECT HEADER_STATUS,OS_MB,TOTAL_MB,PATH FROM V$ASM_DISK WHERE HEADER_STATUS LIKE '%CANDIDA%' ORDER BY PATH;
HEADER_STATU   TOTAL_MB PATH
------------ ---------- --------------------
CANDIDATE             0 /dev/rhdisk35
CANDIDATE             0 /dev/rhdisk36

Determine which diskgroup do you want to add
select name, total_mb, free_mb, state from v$asm_diskgroup;
NAME                              TOTAL_MB         FREE_MB   STATE
------------------------------    ----------     ---------- -----------
DATA                              3014656          418080   MOUNTED
FRA                               1048576          998834   MOUNTED
OCRVOTE                           2288             11356    MOUNTED
SSDDISK                           524288           404805   MOUNTED

Then Alter the candidate disk to the disk group, login as grid user and invoke sqlplus / as sysasm then run command below

ALTER DISKGROUP FRA ADD DISK '/dev/rhdisk35' NAME rhdisk35, '/dev/rhdisk36' NAME rhdisk36;
ALTER DISKGROUP FRA ADD DISK '/dev/rhdisk35' NAME rhdisk35, '/dev/rhdisk36' NAME rhdisk36;


Have Fun...