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.
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;
===============================================================
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
Post a Comment
Oracle DBA Information