How to ADD/DROP ASM DISK in SINGLE COMMAND

How to ADD/DROP ASM DISK in SINGLE COMMAND


Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

GOAL

When a disk is dropped, the disk group is rebalanced by moving all of the file extents from the dropped disk to other disks in the disk group. A drop disk operation might fail if not enough space is available on the other disks. The best approach is to perform both the add and drop operation with the same ALTER DISKGROUP statement. This has the benefit of rebalancing data extents only one time and ensuring that there is enough space for the rebalance operation to succeed.
  

SOLUTION

The syntax to  ADD and DROP of disks using ALTER DISKGROUP  command is as below :
===============================================================

alter diskgroup data add disk '/dev/oracle/disk1','dev/oracle/disk2','dev/oracle/disk3'
 
drop disk '/dev/oracle/disk4','dev/oracle/disk5','dev/oracle/disk6'
 
rebalance power 5;






Note---> This informationmation taken from oracle metalink. all copy rights oracle only.

Comments