How to Add New Disk in ASM DiskGroup

Add New Disk in ASM DiskGroup, As per the business growth the database also growing so sometimes we need to add space in the existing diskgroup. The oracle rider will help to resolve your query also on PATCHING.

Steps to add Add New Disk in ASM DiskGroup

Follow the below step to add a new disk.

Add New Disk in ASM DiskGroup

Step 1: Mount physical disk in server

First, we need to add a new physical disk and make it usable, if you don’t know click here. My physical disk address is ‘/dev/sdb1

Step 2: Create a new ASM disk

Create a new ASM disk using the below commands.

$oracleasm createdisk DATA_02 /dev/sda1

Step 3: Check newly created ASM disk

The below command will help us to find all +ASM disk lists. Complete steps to add New Disk in ASM DiskGroup.

$oracleasm listdisks

Step 4: Add this disk into disk group

After creating the ASM disk, now we need to add this disk into that disk group where we need space. In my case, I’m going to add the DATA disk group.

SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/DATA_02’ NAME DATA_02 rebalance power 100;

Step 5: Check rebalance status

We have successfully added a new disk in the disk group, this is the last step where we just check to rebalance status using the below query.

$sqlplus / as sysasm

SQL> select * from v$asm_operation.

If the above query return no row selected that means rebalancing is completed.

Using the below query you can find the ASM disk information with their disk group.

set lines 400;
col diskgroup for a17
col diskname for a17
col path for a38

select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status
from v$asm_disk b, v$asm_diskgroup a
where a.group_number (+) =b.group_number
order by b.group_number,b.name;

FAQ

  1. Can we add former disk to ASM?

    Yes, we can add the former disk to the ASM disk, but before adding the disk we need to perform the above steps.

  2. How do you make a candidate disk in ASM?

    Here is the which help us to create candidate disk in ASM
    “oracleasm createdisk DATA_02 /dev/sda1”

  3. How do I list disks in ASM Diskgroup?

    Use the following command to show the list of ASM diskgroup.

    select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;

  4. How do I extend ASM Diskgroup?

    Using the above steps you can extend the ASM diskgroup

5 thoughts on “How to Add New Disk in ASM DiskGroup”

Leave a Comment