How v$recovery_file_dest.space_used is calculated from v$asm_file.bytes in ASM (Doc ID 1212079.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Goal

The purpose of this note is to provide insight on how space allocation ( v$asm_file.space column ) in ASM can be calculated depending on Allocation Unit size, redundancy and striping scheme.


There will be big space gap for Flashback logs in recovery destination diskgroup as the default redundancy and striping method for Flashback logs are "Fine" and "High" and the way of how v$recovery_file_dest.space_used is calculated in ASM. As a result of this space gap, recovery destination clean up mechanism sometimes won't kick in even db_recovery_file_dest_size is used up.


db_recovery_file_dest_size should be calculated carefully by taking into account redundancy, striping and AU boundary as it can cause database hung in a situation when archivelog can not be generated.


This note will be useful -
1. Calculate the exact size of a file in ASM environment.
2. Calculate v$recovery_file_dest.space_used for flashback logs and archived log files.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms