Monday , December 18 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 and connect sqlplus as sysasm user.
[grid@dbcentre2 ~]$ 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.

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

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

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

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe