OCP-043 drop diskgroup

66. In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups,
DGROUP1, is no longer required and you want this disk group to be removed. You execute the following
command to achieve this objective:
DROP DISKGROUP dgroup1 EXCLUDING CONTENTS;
What would be the result of this command?
A.This command would result in an error because the disk group is not empty.
B.The command would drop the disk group, ignoring the EXCLUDING CONTENTS option.
C.The command would result in the disk group being marked as INVALID because it cannot be dropped.
D.The command would result in the contents being moved to the parent disk group and dropping of the
disk group.
E.The command would distribute the contents of the specified disk group among all other disk groups and
then drop the specified disk group.
Answer: A

DROP DISKGROUP

Note:

This SQL statement is valid only if you are using Automatic Storage Management and you have started an Automatic Storage Management instance. You must issue this statement from within the Automatic Storage Management instance, not from a normal database instance. For information on starting an Automatic Storage Management instance, please refer to  Oracle Database Administrator's Guide.

Purpose

The DROP DISKGROUP statement lets you drop an Automatic Storage Management disk group along with all the files in the disk group. Automatic Storage Management first ensures that no files in the disk group are open. It then drops the disk group and all its member disks and clears the disk header.

See Also:

• CREATE DISKGROUP and ALTER DISKGROUP for information on creating and modifying disk groups

• Oracle Database Administrator's Guide for information on Automatic Storage Management and using disks groups to simplify database administration

Prerequisites

You must have the SYSDBA system privilege and you must have an Automatic Storage Management instance started, from which you issue this statement. The disk group to be dropped must be mounted.

Syntax

drop_diskgroup::=

Description of the illustration drop_diskgroup.gif

Semantics

diskgroup_name

Specify the name of the disk group you want to drop.

INCLUDING CONTENTS

Specify INCLUDING CONTENTS to confirm that Automatic Storage Management should drop all the files in the disk group. You must specify this clause if the disk group contains any files.

EXCLUDING CONTENTS

Specify EXCLUDING CONTENTS to ensure that Automatic Storage Management drops the disk group only when the disk group is empty. This is the default. If the disk group is not empty, an error will be returned.

Example

Dropping a Diskgroup: Example The following statement drops the Automatic Storage Management disk group dgroup_01, which was created in "Creating a Diskgroup: Example", and all of the files in the disk group:

DROP DISKGROUP dgroup_01 INCLUDING CONTENTS;