oraclednaThis post is to demonstrate enabling Flash Recovery Area In Oracle RAC 19c Database.
1. Before enabling the fast recovery area, check the status of FRA.
SQL> show parameter db_recovery;
NAME TYPE VALUE
———————————— ———– ——————————
db_recovery_file_dest string
db_recovery_file_dest_size big integer 0
2. Enable the FRA.
SQL> alter system set db_recovery_file_dest_size=20G scope=both sid=’*’;
System altered.
SQL> alter system set DB_RECOVERY_FILE_DEST=’+DATA’ scope=both sid=’*’;
System altered.
3. Verify the FRA status from all RAC nodes.
SQL> show parameter db_recovery;
NAME TYPE VALUE
———————————— ———– ——————————
db_recovery_file_dest string +DATA
db_recovery_file_dest_size big integer 20G
4. Check the FRA utilization and occupant details.
set linesize 300
col NAME for a20
select name, ROUND(SPACE_LIMIT/1024/1024/1024,2) “Allocated Space(GB)”,
round(SPACE_USED/1024/1024/1024,2) “Used Space(GB)”,
round(SPACE_RECLAIMABLE/1024/1024/1024,2) “SPACE_RECLAIMABLE (GB)” ,
(select round(ESTIMATED_FLASHBACK_SIZE/1024/1024/1024,2)
from V$FLASHBACK_DATABASE_LOG) “Estimated Space (GB)”
from V$RECOVERY_FILE_DEST;
NAME Allocated Space(GB) Used Space(GB) SPACE_RECLAIMABLE (GB) Estimated Space (GB)
——————– ——————- ————– ———————- ——————–
+DATA 20 .81 0
—
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
———————– —————— ————————- ————— ——–
CONTROL FILE .09 0 1 0
REDO LOG 3.93 0 4 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
8 rows selected.
Disclaimer:
Please note the above information is only for educational purpose and practised in personal test database only. Always test in test database before implementing in production database. The pre-requisites and ways of implementing may vary from one environment to another. Hence, not providing guarantee that it will work in your environment.
