Database - RAC/Scalability (MOSC)

MOSC Banner

Calculating ACTUAL and USED space in ASM Disk Group with NORMAL redundancy


Hi

Hello everyone

We are trying to calculate the actual available and used space for one of our ASM DISK GROUP DATA in our 19c database

The Disk Group has NORMAL redundancy

ASMCMD> lsdg - DATA

State  Type  Rebal Sector Logical_Sector Block    AU Total_MB  Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED NORMAL N     512       512  4096 4194304 10684160 10664828     2136832     4263998       0       Y DATA

There are 5 physical disk appx 2 TB that this (+DATA) disk group is made up of and since this is normal redundancy we would need one disk or 2 TB for mirroring / redundancy purpose( as reflected in the required_mirror_free_mb column of v$asm_diskgroup). That means the total available space in the disk group would be 8 TB Divided by 2 (to incorporate mirroring) = appx 4 TB and same is reflected in the USABLE_FILE_MB column of v$asm_diskgroup 

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