1、登錄到命令行

切換到grid用戶

[grid@swnode1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.2.0.1.0 Production on Wed May 30 05:40:48 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

注意：這里是sysasm登錄才能有權限修改

2.檢查確認要刪除的磁盤組是否在用
select * from dba_data_files;
select * from dba_temp_files;
select * from v$logfile;

3.先在各節點上dismount磁盤組
alter diskgroup REDO01 dismount;
alter diskgroup REDO02 dismount;
alter diskgroup REDODG1 dismount;

4.ASM中刪除磁盤組
drop diskgroup REDO01 force including contents;
drop diskgroup REDO02 force including contents;
drop diskgroup REDODG1 force including contents;

5.crs刪除磁盤組
crsctl stat res -t ---查看磁盤組
srvctl remove diskgroup -g REDO01 -f
srvctl remove diskgroup -g REDO02 -f
srvctl remove diskgroup -g REDODG1 -f

6.更新crs信息
查看crs依賴的磁盤組：
crsctl status res ora.veraa.db -f
START_DEPENDENCIES=hard(ora.testDG1.dg,ora.testDG2.dg,ora.REDODG1.dg,ora.testDG3.dg,ora.REDO01.dg,ora.REDO02.dg,ora.REDODG01.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(ora.testDG1.dg,ora.testDG2.dg,ora.REDODG1.dg,ora.testDG3.dg,ora.REDO01.dg,ora.REDO02.dg,ora.REDODG01.dg)
START_TIMEOUT=600
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.testDG1.dg,shutdown:ora.testDG2.dg,shutdown:ora.REDODG1.dg,shutdown:ora.testDG3.dg,shutdown:ora.REDO01.dg,shutdown:ora.REDO02.dg,shutdown:ora.REDODG01.dg)
修改正確的磁盤組：
srvctl modify database -d veraa -a "testDG1,testDG2,testDG3,REDODG01"

總結

以上是生活随笔為你收集整理的oracle RAC如何正确地删除ASM磁盘组的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。