Hi All,
Oracle 12 - For some reason the view is not showing anything, just zeroes, I can't remember when was the last time the information was populated maybe months ago, now it is gone.Archive logs and backup pieces are saved under /mnt/proddbvol2/fast_recovery_area/orcl/archivelog and /mnt/proddbvol2/fast_recovery_area/rman
SQL> SHOW PARAMETER DB_RECOVERY_FILE_DEST;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /mnt/proddbvol2/fast_recovery_area
db_recovery_file_dest_size big integer 100G
SQL> SELECT * FROM V$RECOVERY_FILE_DEST;
"NAME" "SPACE_LIMIT" "SPACE_USED" "SPACE_RECLAIMABLE" "NUMBER_OF_FILES" "CON_ID"
"/mnt/proddbvol2/fast_recovery_area" 107374182400 0 0 0 0
SQL> SELECT * FROM V$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" 0 0 0 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