Skip Headers
Oracle® Database 2 Day DBA
10g Release 2 (10.2)

Part Number B14196-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

Dropping a Disk Group

When you drop a disk group, you delete the disk group, and optionally all of its files. You cannot drop a disk group if any of its database files are 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. Access the ASM Home page.

    See "Accessing the Automatic Storage Management Home Page" for instructions.

  2. Click the Administration tab.

  3. If the Automatic Storage Management Login page appears, log in as the SYS user, connecting as SYSDBA. Provide the SYS password that is stored in the password file for the ASM instance. This password was set up when the ASM instance was created.

  4. On the ASM Administration page, under the Disk Groups heading, click in the Select column to select the disk group that you want to drop.

  5. Click Delete.

    A confirmation page appears.

  6. If you want to delete the contents of the disk group, click Advanced Options, ensure that the INCLUDING CONTENTS option is selected, and then click OK.

  7. On the confirmation page, click Yes.