如何卸载并删除ASM磁盘组

2015-11-21 01:46:14 · 作者: · 浏览: 2

1、以oracle用户登录RAC数据库节点1:

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, 2008, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise EditionRelease 11.1.0.7.0 - 64bit Production

With the Partitioning, Real ApplicationClusters, OLAP, Data Mining

and Real Application Testing options

SQL> alter diskgroup dg_arch dismount;

Diskgroup altered.

------ 实例+ASM1卸载ASM磁盘组DG_ARCH

2、以oracle用户登录RAC数据库节点2:

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, 2008, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise EditionRelease 11.1.0.7.0 - 64bit Production

With the Partitioning, Real ApplicationClusters, OLAP, Data Mining

and Real Application Testing options

SQL> alterdiskgroup dg_arch dismount;

Diskgroup altered.

------ 实例+ASM2卸载ASM磁盘组DG_ARCH

SQL> dropdiskgroup dg_arch force including contents;

Diskgroup dropped.

------- 删除ASM磁盘组DG_ARCH