v$flash_recovery_area_usage shows wrong number used?
rdbms 19.16 RHEL8
Hi,
We have an recovery_dest_size of 400G.
v$flash_recovery_area_usage show usage of 200G.
But the mountpoint itself is only used to 100G.
show parameter db_rec
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /opt/oracle/backup
db_recovery_file_dest_size big integer 400G
select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE 0 0 0 0
REDO LOG 0 0 0 0
ARCHIVED LOG 0 0 0 0
BACKUP PIECE 51.72 0 1574 0
IMAGE COPY 0 0 0 0
FLASHBACK LOG 0 0 0 0
FOREIGN ARCHIVED LOG 0 0 0 0
AUXILIARY DATAFILE COPY 0 0 0 0
Thats 51% used.