DBA Hub

📋Steps in this guide1/4

Add and drop Disks to ASM Disk Group in Oracle

add and drop disks to asm disk group in oracle | learn more than 100 important question and concepts with learnomate technologies

oracle configurationintermediate
by OracleDba
12 views
1

Overview

You can add disks to ASM Disk group as follows. here specify the logical disk name and add disk to ASM Disk group as follows. Firstly list the disks and their name.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
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>

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

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

Section 2

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

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
select DISK_NUMBER,name ,PATH, MOUNT_DATE from v$asm_disk;

alter diskgroup DATA drop disk DATA_0001;

select * from v$asm_operation;

ALTER DISKGROUP DATA REBALANCE POWER 8 NOWAIT;
3

Section 3

—————————————————————————————————————————————– 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/
4

Section 4

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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!