FRA Usage
Please see the FRA usage in my 3 Node 11.2.0.3 RAC set up. However , I am not able to correlate the COLD_USED_MB with the other results. Please can you help me how to relate the results to each other ?
SQL> select SPACE_LIMIT/1024/1024 , SPACE_USED/1024/1024, SPACE_RECLAIMABLE/1024/1024 from V$RECOVERY_FILE_DEST;
SPACE_LIMIT/1024/1024 SPACE_USED/1024/1024 SPACE_RECLAIMABLE/1024/1024
--------------------- -------------------- ---------------------------
51200 27513 19571
SQL> select * from v$recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ----------------- ---------------
CONTROL FILE 5.54 0 1
REDO LOG 0 0 0
ARCHIVED LOG 9.88 9.88 1325
BACKUP PIECE 22.07 22.07 19
IMAGE COPY 0 0 0
FLASHBACK LOG 15.7 6.28 37
FOREIGN ARCHIVED LOG 0 0 0