溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

Oracle RAC 刪除ASM磁盤組

發布時間:2020-02-19 21:31:14 來源:網絡 閱讀:655 作者:劉楓_Leo 欄目:關系型數據庫

1.檢查確認要刪除的磁盤組是否在用

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

2.先在各節點上dismount磁盤組

alter diskgroup REDO01 dismount;
alter diskgroup REDO02 dismount;
alter diskgroup REDODG1 dismount;

3.ASM中刪除磁盤組

drop diskgroup REDO01 force including contents;
drop diskgroup REDO02 force including contents;
drop diskgroup REDODG1 force including contents;

4.crs刪除磁盤組

crsctl stat res -t? ---查看磁盤組
srvctl remove diskgroup -g REDO01 -f
srvctl remove diskgroup -g REDO02 -f
srvctl remove diskgroup -g REDODG1 -f

5.更新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"?

向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

亚洲午夜精品一区二区_中文无码日韩欧免_久久香蕉精品视频_欧美主播一区二区三区美女