How v$recovery_file_dest.space_used is calculated from v$asm_file.bytes in ASM
Last updated on APRIL 23, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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.
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