DROP DISKGROUP
SQL> column HEADER_STATUS format a20
SQL> set pages 100
SQL> col PATH format a25
SQL> SELECT name, header_status, path FROM V$ASM_DISK ;
NAME HEADER_STATUS PATH
------------------------------ -------------------- -------------------------
CANDIDATE /dev/asm-disk8
CANDIDATE /dev/asm-disk6
CANDIDATE /dev/asm-disk7
DATA_0000 MEMBER /dev/asm-disk1
DATA2_0000 MEMBER /dev/asm-disk4
DATA_0002 MEMBER /dev/asm-disk3
DATA2_0001 MEMBER /dev/asm-disk5
DATA_0001 MEMBER /dev/asm-disk2
DROP DISKGROUP DATA2 INCLUDING CONTENTS;
drop diskgroup DATA2 force including contents;
Rac-Node2
oracle@testdbrac2:/oracle:>grid_env
oracle@testdbrac2:/oracle:>sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 28 10:49:18 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select GROUP_NUMBER, NAME, state from v$asm_diskgroup;
GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
1 DATA MOUNTED
2 DATA2 MOUNTED
SQL> alter diskgroup DATA2 dismount;
Diskgroup altered.
SQL> select GROUP_NUMBER, NAME, state from v$asm_diskgroup;
GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
1 DATA MOUNTED
0 DATA2 DISMOUNTED
Everything Changes
6 gün önce