ASM rebalance stuck wiht likely griddisks showing SYNCING status on storage cell server(s)
(Doc ID 2861776.1)
Last updated on NOVEMBER 16, 2022
Applies to:
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and laterOracle Database - Enterprise Edition - Version 12.2.0.1 and later
Gen 2 Exadata Cloud at Customer - Version All Versions and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
[root@exa1dbadm01 ~]# dcli -l root -g /opt/oracle.SupportTools/onecommand/cell_group 'cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome' | grep -vi yes
exa1celadm01: RECOC2_CD_04_exa1celadm01 ONLINE "Cannot deactivate because partner disk RECOC2_CD_08_exa1CELADM05 is not online"
exa1celadm01: RECOC2_CD_08_exa1celadm01 ONLINE "Cannot deactivate because partner disk RECOC2_CD_08_exa1CELADM05 is not online"
griddisks on cell 5 and 10 in SYNCING mode
RECOC4_CD_08_exa1celadm05 active SYNCING Yes
RECOC4_CD_00_exa1celadm10 active SYNCING Yes
RECOC4_CD_01_exa1celadm10 active SYNCING Yes
RECOC4_CD_02_exa1celadm10 active SYNCING Yes
RECOC4_CD_03_exa1celadm10 active SYNCING Yes
RECOC4_CD_04_exa1celadm10 active SYNCING Yes
RECOC4_CD_05_exa1celadm10 active SYNCING Yes
RECOC4_CD_06_exa1celadm10 active SYNCING Yes
RECOC4_CD_07_exa1celadm10 active SYNCING Yes
RECOC4_CD_08_exa1celadm10 active SYNCING Yes
RECOC4_CD_09_exa1celadm10 active SYNCING Yes
RECOC4_CD_10_exa1celadm10 active SYNCING Yes
RECOC4_CD_11_exa1celadm10 active SYNCING Yes
preventing maintenance on another cell / precheck failed, i.e.
exa1celadm01: RECOC4_CD_00_exa1celadm01 ONLINE "Cannot deactivate because partner disk RECOC4_CD_00_exa1CELADM10 is not online"
ASM DG Rebalance running way too longer like 12+ hours (it may depend on the DG size and number of griddisks) or showing error like ORA-59035
e.g. for
select * from gv$operation;
GROUP_NUMBER OPERA PASS STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE CON_ID
------------ ----- --------- ---- ---------- ---------- ---------- ---------- ---------- ----------- -------------------------------------------- ----------
1 REBAL COMPACT WAIT 16 16 0 0 0 0 0
1 REBAL REBALANCE WAIT 16 16 0 0 0 0 0
1 REBAL REBUILD WAIT 16 16 0 0 0 0 0
1 REBAL RESILVER WAIT 16 16 0 0 0 0 0
1 REBAL RESYNC RUN 16 16 667241 680312 3166 4 0
2 REBAL COMPACT WAIT 64 0
2 REBAL REBALANCE ERRS 64 ORA-59035 0 <<<<
2 REBAL REBUILD WAIT 64 0
2 REBAL RESILVER WAIT 64 0
2 REBAL RESYNC WAIT 64 0
10 rows selected.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |