Skip Headers
Oracle® Database 2 Day DBA
11g Release 1 (11.1)

Part Number B28301-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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 ASM Home page.

    See "Accessing the Automatic Storage Management Home Page".

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

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

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

  5. Click Delete.

    A confirmation page appears.

  6. If you want to delete the disk group even if it still contains files, click 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, you cannot drop the disk group.

  7. On the confirmation page, click Yes.