How to detach and delete an ASM disk group or an asm disk group

How to detach and delete an ASM disk group or an asm disk group

1. log on to RAC database Node 1 as an oracle user:

Oracle @ node74: ~> Export ORACLE_SID = + ASM1

Oracle @ node74: ~> Sqlplus sys/xxxxx as sysdba

 

SQL * Plus: Release 11.1.0.7.0-Productionon Mon Feb 18 14:34:20 2013

Copyright (c) 1982,200 8, Oracle. All rights reserved.

Connected:

Oracle Database 11g Enterprise EditionRelease 11.1.0.7.0-64bit Production

With the Partitioning, Real applicationters ters, OLAP, Data Mining

And Real Application Testing options

 

SQL> alter diskgroup dg_arch dismount;

Diskgroup altered.

------ Instance + ASM1 uninstall ASM disk group DG_ARCH

2. log on to RAC database Node 2 as an oracle user:

Oracle @ node76: ~> Export ORACLE_SID = + ASM2

Oracle @ node76: ~> Sqlplus sys/xxxxx as sysdba

 

SQL * Plus: Release 11.1.0.7.0-Production onMon Feb 18 14:35:10 2013

Copyright (c) 1982,200 8, Oracle. All rights reserved.

Connected:

Oracle Database 11g Enterprise EditionRelease 11.1.0.7.0-64bit Production

With the Partitioning, Real applicationters ters, OLAP, Data Mining

And Real Application Testing options

 

SQL> alterdiskgroup dg_arch dismount;

Diskgroup altered.

------ Instance + ASM2 unmount the ASM disk group DG_ARCH

 

SQL> dropdiskgroup dg_arch force including contents;

Diskgroup dropped.

------- Delete the ASM disk group DG_ARCH