如何卸載並刪除ASM磁碟組，asm磁碟組

如何卸載並刪除ASM磁碟組，asm磁碟組

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