ADDING DISK TO ASM DISK GROUP

ADDING DISK TO ASM DISK GROUP in Windows Server

 1. Check the used,free size in ASM disk group_number

SELECT

      name AS disk_group_name

     , state AS disk_state

,TYPE

    , total_mb/1024 AS Total_Size_In_GB

    , ROUND((total_mb - free_mb)/1024,2) AS Used_Size_In_GB

    , ROUND((1- (free_mb / total_mb))*100, 2)  pct_used

  FROM

      v$asm_diskgroup

  WHERE

      total_mb != 0

  ORDER BY

      Name;

  

DISK_GROUP_NAME                DISK_STATE  TYPE    TOTAL_SIZE_IN_GB USED_SIZE_IN_GB   PCT_USED

------------------------------ ----------- ------  ---------------- --------------- ----------

ORA_DATA                       MOUNTED     EXTERN                 2            1.81      89.99

2. Check the candidate disk we will add the candidate disk to asm disk group

col DISK_FILE_PATH format a70 

set pages 200 lines 192 

 SELECT 

 NVL(a.name, '[CANDIDATE]') disk_group_name 

 , b.path disk_file_path 

 , b.name disk_file_name 

 , b.failgroup disk_file_fail_group 

FROM 

 v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number) 

ORDER BY  a.name;

Output

---------------

DISK_GROUP_NAME  DISK_FILE_PATH                                         DISK_FILE_NAME  DISK_FILE_FAIL_GROUP 

---------------- ------------------------------------------------------ --------------- ---------------------

ORA_DATA         D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK1   ORA_DATA_0000   ORA_DATA_0000

[CANDIDATE]      D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK2

                 D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK3

DATA_DISK2 and DATA_DISK3 are candidate disk, we will add only DATA_DISK2 for demonstration purpose.

C:\Users\DILIP_BAKSHI> asmcmd -p

ASMCMD [+] >

ASMCMD [+] > ls -l

State    Type    Rebal  Name

MOUNTED  EXTERN  N      ORA_DATA/

ASMCMD [+] > lsdsk

Path

D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK1

C:\Users\DILIP_BAKSHI>sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 12 23:56:33 2023

Version 19.15.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL>

SQL> ALTER DISKGROUP ORA_DATA ADD DISK 'D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK2';

Diskgroup altered.

SQL>exit

C:\Users\DILIP_BAKSHI> asmcmd -p

ASMCMD [+] > lsdsk

Path

D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK1

D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK2

ASMCMD [+] >

SQL> col DISK_FILE_PATH format a70

SQL> set pages 200 lines 192

SQL>  SELECT

  2   NVL(a.name, '[CANDIDATE]') disk_group_name

  3   , b.path disk_file_path

  4   , b.name disk_file_name

  5   , b.failgroup disk_file_fail_group

  6  FROM

  7   v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)

  8  ORDER BY  a.name;

DISK_GROUP_NAME  DISK_FILE_PATH                                         DISK_FILE_NAME  DISK_FILE_FAIL_GROUP 

---------------- ------------------------------------------------------ --------------- ---------------------

ORA_DATA         D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK1   ORA_DATA_0000   ORA_DATA_0000

ORA_DATA         D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK2   ORA_DATA_0001   ORA_DATA_0001

[CANDIDATE]      D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK3

SQL>

SELECT

      name AS disk_group_name

     , state AS disk_state

,TYPE

    , total_mb/1024 AS Total_Size_In_GB

    , ROUND((total_mb - free_mb)/1024,2) AS Used_Size_In_GB

    , ROUND((1- (free_mb / total_mb))*100, 2)  pct_used

  FROM

      v$asm_diskgroup

  WHERE

      total_mb != 0

  ORDER BY

      Name;

DISK_GROUP_NAME                DISK_STATE  TYPE    TOTAL_SIZE_IN_GB USED_SIZE_IN_GB   PCT_USED

------------------------------ ----------- ------  ---------------- --------------- ----------

ORA_DATA                       MOUNTED     EXTERN                 4            1.81      45.29