Oracle® Database 2 Day DBA 10g Release 2 (10.2) Part Number B14196-02 |
|
|
View PDF |
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:
Access the ASM Home page.
See "Accessing the Automatic Storage Management Home Page" for instructions.
Click the Administration tab.
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.
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.
Click Delete.
A confirmation page appears.
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.
On the confirmation page, click Yes.