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.
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;
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.
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”
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;
How do I extend ASM Diskgroup?
Using the above steps you can extend the ASM diskgroup
- Resolve error in invoking target agent nmhs of makefile
- Purge RECYCLEBIN in Oracle
- How to get tablespace DDL in oracle
- How to create tablespace in Oracle
- Switchover steps in Oracle 11G, 12c, 19c
- Run Expdp Jobs in Background