Friday , October 20 2017
Home / Oracle DBA / How To Add New Disk To The Existing Disk Groups in ASM

How To Add New Disk To The Existing Disk Groups in ASM

Process to check existing Disk Groups: 

Step 1: Export oracle sid for ASM instance connect sqlplus as sysasm user.
[grid@dbcentre2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 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 - 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
ASM_DG_DATA                   MOUNTED           EXTERN

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.


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.

[root@dbcentre2 ~]# xhost +
access control disabled, clients can connect from any host
[root@dbcentre2 ~]# su - grid
[grid@dbcentre2 ~]$ which asmca
[grid@dbcentre2 ~]$ 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:



Check Also

Moving a database from Normal File System to ASM storage

Default storage for oracle database is File System, where database files resides on local storage. …

Leave a Reply

Your email address will not be published. Required fields are marked *