Add and drop Disks to ASM Disk Group in Oracle

• [email protected]
• 09 Jun, 2025
• 0 Comments
• 1 Min Read

Add and drop Disks to ASM Disk Group in Oracle

 Add and drop Disks to ASM Disk Group in Oracle with Alter Diskgroup Add Disk Command

You can add disks to ASM Disk group as follows.

SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/DATA01';

Diskgroup altered.

SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/DATA02';

Diskgroup altered.

SQL>

Add Disks to ASM Disk Group

here specify the logical disk name and add disk to ASM Disk group as follows.

ALTER DISKGROUP DATA ADD DISK '/dev/mapper/asmdata1' NAME DATA_0001 SIZE 102399 M REBALANCE POWER 10;

list the All ASM Disks and their state using the v$asm_disk

select DISK_NUMBER,name ,PATH, MOUNT_DATE from v$asm_disk;

Drop Disks from ASM Disk Group

Firstly list the disks and their name.

select DISK_NUMBER,name ,PATH, MOUNT_DATE from v$asm_disk;

Then drop the related disk.

alter diskgroup DATA drop disk DATA_0001;

 

check the drop and add disk operation status using the v$asm_operation view as follows.

select * from v$asm_operation;

 

Change Disk group Rebalance power as follows. Thus, You can speed up this task and Disk group will perform rebalance operation in parallel.

ALTER DISKGROUP DATA REBALANCE POWER 8 NOWAIT;

—————————————————————————————————————————————–

At Learnomate Technologies, we take pride in offering the most practical, real-time, and in-depth Oracle DBA training, including advanced topics like Multitenant Architecture. Our hands-on sessions, expert trainers, and real-world use cases ensure you’re not just learning theory, but gaining industry-ready expertise.

👉 For deeper insights and technical tutorials, visit our YouTube channel: 🔗 www.youtube.com/@learnomate

👉 Explore our full course offerings and get in touch via our official website: 🔗 www.learnomate.org

👉 Follow me on LinkedIn for daily knowledge bombs, career tips, and student success stories: 🔗 Ankush Thavali – LinkedIn

If you want to read more about different technologies, tools, and career-focused content, check out our blog page here: 🔗 https://learnomate.org/blogs/

The future is multitenant—get skilled, get certified, and get ahead. See you in the batch!