RAC删除ASM表空间

1.检查确认要删除的磁盘组是否在用：

select * from dba_data_files;
select * from dba_temp_files;
select * from v$logfile;

查看磁盘组：

select name,state from v$asm_diskgroup;
NAME                           STATE
------------------------------ -----------
ARCH                           MOUNTED
CRS                            MOUNTED
DATA                           MOUNTED
FRA                            MOUNTED
REDO1                          MOUNTED
REDO2                          MOUNTED
ASM_TEST                      MOUNTED  -- 要删除的磁盘组

2.先在各节点上dismount磁盘组：

alter diskgroup ASM_TEST dismount;

3.ASM中删除磁盘组

drop diskgroup ASM_TEST force including contents;

4.crs删除磁盘组

crsctl stat res -t  ---查看磁盘组
srvctl remove diskgroup -g ASM_TEST -f

5.查看磁盘组状态：

SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
ARCH                           MOUNTED
CRS                            MOUNTED
DATA                           MOUNTED
FRA                            MOUNTED
REDO1                          MOUNTED
REDO2                          MOUNTED

6 rows selected.

SQL> select group_number,mount_status,name,path from v$asm_disk;

GROUP_NUMBER MOUNT_S NAME                           PATH
------------ ------- ------------------------------ --------------------------------------------------
           0 CLOSED                                 /dev/mapper/ASM-TEST2
           0 CLOSED                                 /dev/mapper/ASM-TEST1

6.更新crs信息

查看crs依赖的磁盘组：

START_DEPENDENCIES=weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns,ora.ARCH.dg) hard(ora.DATA.dg,ora.FRA.dg,ora.REDO1.dg,ora.REDO2.dg,ora.ASM_TEST.dg) pullup(ora.DATA.dg,ora.FRA.dg,ora.REDO1.dg,ora.REDO2.dg,ora.ASM_TEST.dg)

修改正确的磁盘组：

srvctl modify database -d db_rac -a "DATA,FRA,REDO1,REDO2"

修改后：

crsctl status res ora.db_rac.db -f

START_DEPENDENCIES=hard(ora.DATA.dg,ora.FRA.dg,ora.REDO1.dg,ora.REDO2.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(ora.DATA.dg,ora.FRA.dg,ora.REDO1.dg,ora.REDO2.dg)