You can use the
DISKGROUP SQL statement to alter a disk group configuration. You can add, resize, or drop disks while the database remains online. Whenever possible, multiple operations in a single
DISKGROUP statement are recommended. Grouping operations in a single
DISKGROUP statement can reduce rebalancing operations.
Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the
DISKGROUP statement does not wait until the operation is complete before returning. Query the
V$ASM_OPERATION view to monitor the status of this operation.
WAIT clause to cause the
DISKGROUP statement processing to wait until the rebalance operation is complete before returning. This is especially useful in scripts. The statement also accepts a
NOWAIT clause that invokes the default behavior of conducting the rebalance operation asynchronously in the background.
You can interrupt a rebalance running in wait mode by typing
CTRL+C on most platforms. This causes the statement to return immediately with the message
ORA-01013: user requested cancel of current operation, and then to continue the operation asynchronously. Typing
CTRL+C does not cancel the rebalance operation or any disk add, drop, or resize operations.
To control the speed and resource consumption of the rebalance operation, you can include the
POWER clause in statements that add, drop, or resize disks. Refer to "Manually Rebalancing Disk Groups" for more information about this clause.
This section contains the following topics: