Dropping a Disk Group

When you drop a disk group, you delete the disk group, and all of its files. You cannot drop a disk group if any one of its database files is open. After dropping a disk group, you can add its member disks to other disk groups or use them for other purposes.

One reason to drop a disk group is to change redundancy (normal, high, or external). Because you cannot change the redundancy of a disk group, you must drop the disk group and then re-create it with the proper redundancy. In this case, you must back up or move disk group data before you drop the disk group.

To drop a disk group:

1. Go to the Oracle ASM Home page.

   See "Accessing the Oracle Automatic Storage Management Home Page".

2. Click the Disk Groups link to display the Disk Groups subpage.

3. If the Oracle ASM Login page appears, then log in as the SYS user, connecting as SYSASM. Provide the SYS password that was set when the Oracle ASM instance was created.

4. In the Select column, select the name of the disk group to drop.

5. Click Delete.

   A confirmation page appears.

6. To delete the disk group even if it still contains files, expand Show Advanced Options and ensure that the Including Contents option is selected.

   If the disk group contains files and the Including Contents option is not selected, then you cannot drop the disk group.

7. On the confirmation page, click Yes.