Prev Question
Next Question

Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

A.
ALTER DISKGROUP misc MOUNT;

B.
ALTER DISKGROUP misc DROP DISK misc2;

C.
ALTER DISKGROUP misc CHECK ALL NOREPAIR;

D.
ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;

E.
ALTER DISKGROUP dgroupA ADD DISK ‘/devices/A*’;

Explanation:
Altering Disk Groups
You can use the ALTER 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 ALTER
DISKGROUP statement are recommended. Grouping operations in a single ALTER DISKGROUP statement
can reduce rebalancing operations.
Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the ALTER
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.
add_disk_clause
Use this clause to add one or more disks to the disk group and specify attributes for the newly added disk.
Oracle ASM automatically rebalances the disk group as part of this operation.
drop_disk_clauseUse this clause to drop one or more disks from the disk group.
DROP DISK
The DROP DISK clause lets you drop one or more disks from the disk group and automatically rebalance the
disk group. When you drop a disk, Oracle ASM relocates all the data from the disk and clears the disk header
so that it no longer is part of the disk group. The disk header is not cleared if you specify the FORCE keyword.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *