ASM Management: Add Disk, Drop Disk, and Rebalance within a single statement

select GROUP_NUMBER, DISK_NUMBER, STATE, MOUNT_STATUS, HEADER_STATUS, MODE_STATUS, OS_MB, TOTAL_MB, FREE_MB, NAME, PATH, UDID from v$asm_disk;

alter diskgroup DISKGROUP
add disk ‘ORCL:DISK4‘ NAME DISK4, ‘ORCL:DISK5‘ NAME DISK5, ‘ORCL:DISK6‘ NAME DISK6
drop disk DISK1, DISK2, DISK3
rebalance power 7;

select * from gv$asm_operation;  <– Run this to view the status of the rebalance operation

Advertisements

About Thomas Baran

Work with the Best, Deliver nothing Less.
This entry was posted in Uncategorized and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s