Removing diskgroup from the ASM instance of Oracle11g reports an error ORA-15027

Removing diskgroup from the ASM instance of Oracle11g reports an error ORA-15027

Removing diskgroup from an Oracle 11g ASM instance reports an error ORA-15027

Delete diskgroup on an Oracle 11g ASM instance.

An error occurred while deleting the ORA-15027: active use of diskgroup precludes its dismount, as shown below:

SQL> drop diskgroup webdg including contents;

Drop diskgroup webdg including contents

*

ERROR at line 1:

ORA-15039: diskgroup not dropped.

ORA-15027: active use of diskgroup "WEBDG" precludes its dismount

I have closed the database instance before deleting it. What client connection will there be on the ASM instance?

SQL> select * from v $ asm_client;

GROUP_NUMBER INSTANCE_NAME

----------------------------------------------------------------------------

DB_NAME STATUS

--------------------

SOFTWARE_VERSION

------------------------------------------------------------

COMPATIBLE_VERSION

------------------------------------------------------------

1 + ASM2

+ ASM CONNECTED

11.2.0.1.0

11.2.0.1.0

GROUP_NUMBER INSTANCE_NAME

----------------------------------------------------------------------------

DB_NAME STATUS

--------------------

SOFTWARE_VERSION

------------------------------------------------------------

COMPATIBLE_VERSION

------------------------------------------------------------

2 + ASM2

Asmvol CONNECTED

11.2.0.1.0

11.2.0.1.0

The group_number value of the disk group webdg is 2. This instance + ASM2 has an asmvol connection. This is a new feature in the 11g architecture. It is a logical volume created on a disk group. When creating an ASM instance, I created an ASM volume group for testing purposes and mounted it to the operating system as an ACFS file.

SQL> host;

[Grid @ serv2 ~] $ Df-h

Filesystem Size Used Avail Use % Mounted on

/Dev/cciss/c0d0p3 39G 8.5G 29G 23%/

/Dev/cciss/c0d0p6 185G 157G 20G 90%/oradata

/Dev/cciss/c0d0p2 291G 46G 230G 17%/u01

/Dev/cciss/c0d0p1 99 M 12 M 82 M 13%/boot

Tmpfs 12G 224 M 12G 2%/dev/shm

/Dev/asm/vg1-229 40G 146 M 40G 1%/u01/app/grid/acfsmounts/webdg_vg1

192.168.15.56:/u02 1008G 383G 574G 41%/u02

[Grid @ serv2 ~] $ Exit

Therefore, you must detach the mount point umount and then disable the logical volume Group to delete the disk group webdg.

Use the umount command umount on two RAC nodes to delete all mount points.

[Root @ serv2 ~] #/Bin/umount-t acfs-

Use the drop diskgroup webdg including contents command again to delete the disk group webdg.

SQL> drop diskgroup webdg including contents;

Drop diskgroup webdg including contents

*

ERROR at line 1:

ORA-15039: diskgroup not dropped.

ORA-15073: diskgroup WEBDG is mounted by another ASM instance

This error indicates that the disk group is mounted on another ASM instance. This is a common RAC error because the disk group in RAC is mounted on two ASM instances at the same time.

Dismount the disk group on both ASM instances at the same time. The force option is used here.

SQL> alter diskgroup webdg dismount force;

Diskgroup altered.

Drop the disk group on one of the ASM instances. If the disk does not have force, the operation fails. Add force again.

SQL> drop diskgroup webdg including contents;

Drop diskgroup webdg including contents

*

ERROR at line 1:

ORA-15039: diskgroup not dropped.

ORA-15001: diskgroup "WEBDG" does not exist or is not mounted.

SQL> drop diskgroup webdg force including contents;

Diskgroup dropped.

SQL>

Now, the disk group is deleted.

For more information about Oracle, see the Oracle topic page? Tid = 12