ASM管理DG过程

   

ASM实例:
卸载磁盘组
alter diskgroup <group_name> dismount;
加载 磁盘组
alter diskgroup <group_name> mount;

在数据库启动时会改变DB用到的diskgroup的状态为CONNECTED，
那些没有用到的diskgroup的状态仍然为 MOUNTED.

$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jun 29 13:34:55 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name,state from v$asm_diskgroup_stat;

NAME                           STATE
------------------------------ -----------
DG1                            MOUNTED
DG2                            MOUNTED

 

SQL> create tablespace test datafile '+DG1' size 2g;

Tablespace created.
---在DG1创建一个表空间后状态变为CONNECTED，而DG2仍然为 MOUNTED
SQL> select name,state from v$asm_diskgroup_stat;

NAME                           STATE
------------------------------ -----------
DG1                            CONNECTED
DG2                            MOUNTED

 

SQL> select name,state from v$asm_diskgroup_stat;

NAME
--------------------------------------------------------------------------------
STATE
---------------------------------
DG_ORA
CONNECTED

DG_DATA
MOUNTED

DG_IDX
MOUNTED