Oracle® Database 2 Day DBA 11g Release 1 (11.1) Part Number B28301-03 |
|
|
View PDF |
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:
Go to the ASM Home page.
Click the Disk Groups link to display the Disk Groups subpage.
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.
In the Select column, select the name of the disk group that you want to drop.
Click Delete.
A confirmation page appears.
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.
On the confirmation page, click Yes.