Oracle DBA – A lifelong learning experience

ASM – Adding and dropping disks in one command

Posted by John Hallas on May 29, 2012

One of the possibilities within ASM that is not widely documented is the opportunity to add disks, drop disks and set the rebalance power all in one command.

One might wonder when you might be both adding and dropping disks simultaneously from the same disk group. Recently we have been migrating to a new storage array and this command comes in very useful in that situation

alter diskgroup data add disk '/dev/oracle/disk100','dev/oracle/disk101','dev/oracle/disk102'

drop disk '/dev/oracle/disk197','dev/oracle/disk198','dev/oracle/disk199'

rebalance power 5;

 

About these ads

3 Responses to “ASM – Adding and dropping disks in one command”

  1. Hi John. Thanks for the information. Normally if i run “add disk” and “drop disk” commands consecutively, it first finishes the rebalance of “add disk” command then starts to rebalance operation of “drop disk” command. Did you check asm’s rebalance behaviour if we run add and drop in one command?

  2. [...] Top Posts Purging statistics from the SYSAUX tablespaceRMAN backup script – example – logging outputORA-19809: limit exceeded for recovery files – db_recovery_file_dest_size and archiver errorPurging ADR log and trace files automaticallyHow to move the central Inventory (oraInventory) to another location. Speeding up the gathering of incremental stats on partitioned tablesWhere has consistent=y gone when using Datapump exportCorrupted Oracle inventoryGrid control sends false alerts with "Agent to OMS communication broken" messageIdentifying corrupt blocks « ASM – Adding and dropping disks in one command [...]

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 )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 133 other followers

%d bloggers like this: