DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, February 28, 2018

Adding disks online to existing diskgroups

STEPS:

1) Check the current ASM diskgroup size:
select name,total_mb,free_mb from v$asm_diskgroup;
2) Check the HEADER_STATUS shows as CANDIDATE or PROVISIONED for the ASM disks:
select group_number,disk_number,header_status,STATE,OS_MB,TOTAL_MB,FREE_MB,NAME,LABEL,PATH,VOTING_FILE from v$asm_disk order by GROUP_NUMBER,DISK_NUMBER;
3) Check the raw disk path and diskgroup name and status
col PATH format a10;
col name format a10;
SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,
FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK;
4) Adding the disks to existing diskgroup online
ALTER DISKGROUP DG08 ADD DISK '/dev/oracleasm/disks/DG09' NAME DG09_0000;
5) Post check status of diskgroup and HEADER STATUS as 'MEMBER'
col PATH format a10;
col name format a10;
SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,
FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK;
6) Check the diskgroup status and size in both nodes
asmcmd

ASMCMD> lsdg

No comments: