Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

PRVE-03142

One or more ASM disk rebalance operations found in WAIT status

Cause

A query on V$ASM_OPERATION showed one or more ASM disk rebalance operations in WAIT status.


Action

Identify the ASM rebalance operations in WAIT status by running the query "SELECT * FROM V$ASM_OPERATION WHERE OPERATION LIKE 'REBAL' AND STATE LIKE 'WAIT'" and resume the operations by altering rebalance power to a non-zero value for the related ASM disk groups.