SPACE_USED column in V$RECOVERY_FILE_DEST not Updated After a Change in the FRA Location (Doc ID 2780810.1)

Last updated on APRIL 17, 2023

Applies to:

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

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data

from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material.

Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

FRA location was changed multiple times from one disk group to another due to space crunch.

After housekeeping it was set back to the original disk group but the V$RECOVERY_FILE_DEST did not show updated values in the SPACE_USED column.

In this case +FRA was used as FRA location, then changed to +DATA, and then changed back to +FRA

From ASM it showed the values of disk usage correctly:

because the file usage from v$flash_recovery_area_usage was already shown correctly.

FRA location was changed multiple times from +FRA to +DATA

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.