Database Administration (MOSC)

MOSC Banner

Possible to check if ASM disks are evenly balanced or not

Hi

Oracle 19c

While doing datafile online move, I ran into:

ORA-15041: diskgroup "DATA" space exhausted

However, enough space was left (500G)

Then I realized the error was actually pointing something else

Cause: At least one disk in the diskgroup is out of space.

So I had 2 disks in diskgroup DATA. Probably one got full.

I did asm rebalance, and this fixed the issue.

But can I check this with some queries perhaps..?

While checking MOSC note Doc ID 2372651.1

There seems like somehow this output has to come from somewhere, some query perhaps.

Anyway, looking a way to achieve this somehow, since at the moment seems like ASM itself does not rebalance the disks regularly, and I need to know when to run rebalance operation.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center