Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASM Drop diskgroup (Including Contents)

User_46BIKMay 19 2014 — edited May 27 2014

HI,

I was hoping someone could help clarify the 11.2 documentation for me here.

If I had the following scenario:

-I want to drop all ASM disks from a cluster (where databases are being decommissioned)

-After dropping all disks I want the header of each disk to show as Former.

I was under the impression that simply dropping a diskgroup (NOT specifying 'including contents) would drop the disk group and mark all disks that were contained within it with a header status of 'FORMER'

However the oracle docs state that of running the command 'DROP DISKGROUP data1' for example:

"After ensuring that none of the files contained in data1 are open, Oracle ASM rewrites the header of each disk in the disk group to remove Oracle ASM formatting information. The statement does not specify INCLUDING CONTENTS, so the drop operation fails if the disk group contains any files"

This doesn't really make sense to me, lets say if +data1 had 5 member disks,

- Does running 'drop diskgroup data1' drop the diskgroup and mark those 5 member disks as former?

- Does running 'drop diskgroup data1' fail to drop the diskgroup due to there being 5 disks assigned as member and INCLUDING CONTENTS was not specified.

- In order to drop the diskgroup and mark all disks within it with a header status of 'FORMER' must the command 'drop diskgroup data1 INCLUDING CONTENTS' be run?

Any help clarifying this would be appreciated.

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2014
Added on May 19 2014
4 comments
2,710 views