ORA-15032 ORA-15410 ORA-15411 解決 ASM 磁碟組調整限制

2021-12-29

13
0
ASM
2022-02-10

記錄使用方式

1. 以 sysasm 身份登入 asm instance，並調整 _asm_disable_failgroup_size_checking & _asm_disable_dangerous_failgroup_checking 為 true，取消過略檢查

[grid@ora-test ~]$ sqlplus / as sysasm
SQL> alter system set "_asm_disable_failgroup_size_checking"=true;
SQL> alter system set "_asm_disable_dangerous_failgroup_checking"=true;

2. 可用 asmca 或 sql command 調整硬碟 ( 以 OCRDG 調整為例 )

--before
[root@ora-test bin]# ./crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   8aebcb0ca6144f37bf0b3eef4302d899 (AFD:OCR01_1) [OCRDG]
 2. ONLINE   322800c74d1d4ff5bfdd024c33bbb2df (AFD:OCR02_1) [OCRDG]
 3. ONLINE   532b4b5a2a764f61bfbe230405707528 (AFD:OCR01_3) [OCRDG]
 
--after 
 [root@oraext1 bin]# ./crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   8aebcb0ca6144f37bf0b3eef4302d899 (AFD:OCR01_1) [OCRDG]
 2. ONLINE   532b4b5a2a764f61bfbe230405707528 (AFD:OCR01_3) [OCRDG]
 3. ONLINE   2d0094ae7a9b4fd3bfb79e69aef6e0cb (AFD:OCR01_2) [OCRDG]

3. 檢查 asm 是否有正在執行 rebalance

SQL> select * from v$asm_operation;
SQL> select * from gv$asm_operation;

4. 調整完畢後，將參數調整回預設值

[grid@ora-test ~]$ sqlplus / as sysasm
SQL> alter system reset "_asm_disable_failgroup_size_checking";
SQL> alter system reset "_asm_disable_dangerous_failgroup_checking";

參考資料：

Oracle 12.2報錯ORA-15032、ORA-15410或ORA-15411解決

已轉向 blogger 記錄

https://slowlife-notes.blogspot.com

回首頁