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.

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

• 
  How to Setup Oracle to Startup Automatically if the System is Restarted
• 
  How to check when last stats was gathered in Oracle?
• 
  Oracle RMAN Tutorial
• 
  Install Linux in Oracle VirtualBox
• 
  Resolve error in invoking target agent nmhs of makefile
• 
  Purge RECYCLEBIN in Oracle