{"id":4142,"date":"2025-06-08T15:24:09","date_gmt":"2025-06-08T15:24:09","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&#038;p=4142"},"modified":"2025-06-08T15:35:37","modified_gmt":"2025-06-08T15:35:37","slug":"fast-recovery-area-fra","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/oracle-dba-d2d-tasks\/fast-recovery-area-fra\/","title":{"rendered":"Fast Recovery Area (FRA)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Fast Recovery Area (FRA) is a centralized storage location in Oracle used to store all essential recovery-related files. It simplifies backup and recovery operations by managing the following components in one place:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Control files<\/li>\n\n\n\n<li>Online redo logs<\/li>\n\n\n\n<li>Archived redo logs<\/li>\n\n\n\n<li>Flashback logs<\/li>\n\n\n\n<li>RMAN backups<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">FRA Configuration<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Set FRA location and size\nALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '\/u01\/app\/oracle\/fast_recovery_area' SCOPE=BOTH;\nALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 20G SCOPE=BOTH;\n\n-- Verify FRA parameters\nSHOW PARAMETER DB_RECOVERY_FILE_DEST;\nSHOW PARAMETER DB_RECOVERY_FILE_DEST_SIZE;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Check FRA Usage<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Check current usage statistics of FRA\nSET PAGESIZE 20\nSET LINESIZE 100\nCOLUMN NAME FORMAT A30\nCOLUMN SPACE_LIMIT_GB FORMAT 999.99\nCOLUMN SPACE_USED_GB FORMAT 999.99\nCOLUMN SPACE_RECLAIMABLE_GB FORMAT 999.99\nCOLUMN NUMBER_OF_FILES FORMAT 99999\n\nSELECT NAME, \n       ROUND(SPACE_LIMIT\/1024\/1024\/1024, 2) AS SPACE_LIMIT_GB, \n       ROUND(SPACE_USED\/1024\/1024\/1024, 2) AS SPACE_USED_GB, \n       ROUND(SPACE_RECLAIMABLE\/1024\/1024\/1024, 2) AS SPACE_RECLAIMABLE_GB, \n       NUMBER_OF_FILES\nFROM V$RECOVERY_FILE_DEST;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Scenario 1: FRA is Full<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Solution: <\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Check current FRA usage\nSET PAGESIZE 20\nSET LINESIZE 80\nCOLUMN SPACE_USED_GB FORMAT 999.99\nCOLUMN SPACE_LIMIT_GB FORMAT 999.99\nSELECT ROUND(SPACE_USED\/1024\/1024\/1024, 2) AS SPACE_USED_GB, \n       ROUND(SPACE_LIMIT\/1024\/1024\/1024, 2) AS SPACE_LIMIT_GB \nFROM V$RECOVERY_FILE_DEST;\n\n-- Identify reclaimable space\nSELECT NAME, ROUND(SPACE_RECLAIMABLE\/1024\/1024\/1024, 2) AS SPACE_RECLAIMABLE_GB \nFROM V$RECOVERY_FILE_DEST;\n\n-- Crosscheck archive logs and backups to validate RMAN catalog\nRMAN> CROSSCHECK ARCHIVELOG ALL;\nRMAN> CROSSCHECK BACKUP;\n\n-- Delete expired logs and backups from RMAN catalog\nRMAN> DELETE EXPIRED ARCHIVELOG ALL;\nRMAN> DELETE EXPIRED BACKUP;\n\n-- Delete obsolete backups forcefully without prompt\nRMAN> DELETE FORCE NONPROMPT OBSOLETE;\n\n-- Delete obsolete backups based on retention policy\nRMAN> DELETE OBSOLETE;\n\n-- Manually remove old archive logs (if required)\nHOST rm -rf \/u01\/app\/oracle\/fast_recovery_area\/archivelog\/*;\n\n-- Increase FRA size if space still insufficient\nALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 50G SCOPE=BOTH;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Scenario 2: Unable to Create New Archived Logs<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Solution:<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Crosscheck and clean up expired archived logs\nRMAN> CROSSCHECK ARCHIVELOG ALL;\nRMAN> DELETE EXPIRED ARCHIVELOG ALL;\n\n-- Redirect archive logs to a new location\nALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=\/u02\/app\/oracle\/archive_logs' SCOPE=BOTH;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Scenario 3: Flashback Logs Consuming Excessive Space<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Solution: Clear flashback logs and manage retention<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Disable flashback feature\nALTER DATABASE FLASHBACK OFF;\n\n-- Delete all flashback logs without confirmation\nRMAN> DELETE NOPROMPT FLASHBACK LOG ALL;\n\n-- Set a lower flashback retention period (in minutes)\nALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET = 60 SCOPE=BOTH;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Scenario 4: FRA Contention Slows Performance<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Solution:<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Improve performance by moving FRA and optimizing schedules\n\n-- Relocate FRA to separate ASM diskgroup or faster storage\nALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '+DATA_FRA' SCOPE=BOTH;\n\n-- Run RMAN backups during non-peak hours (no specific command)\n-- Ensure backup schedules avoid high-load periods<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Best Practices for FRA Management<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Configure RMAN to maintain 2 copies of backups\nCONFIGURE RETENTION POLICY TO REDUNDANCY 2;\n\n-- Back up and delete archive logs regularly\n-- Ensure space is reclaimed periodically<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Useful FRA Queries<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>-- FRA space usage by file type\nSET PAGESIZE 20\nSET LINESIZE 80\nCOLUMN FILE_TYPE FORMAT A20\nCOLUMN PERCENT_SPACE_USED FORMAT 999.99\nCOLUMN PERCENT_SPACE_RECLAIMABLE FORMAT 999.99\n\nSELECT FILE_TYPE, \n       ROUND(PERCENT_SPACE_USED, 2) AS PERCENT_SPACE_USED, \n       ROUND(PERCENT_SPACE_RECLAIMABLE, 2) AS PERCENT_SPACE_RECLAIMABLE \nFROM V$FLASH_RECOVERY_AREA_USAGE;\n\n-- List old RMAN backup pieces\nSET PAGESIZE 20\nSET LINESIZE 80\nCOLUMN HANDLE FORMAT A50\nCOLUMN COMPLETION_TIME FORMAT A20\n\nSELECT HANDLE, COMPLETION_TIME\nFROM V$BACKUP_PIECE\nWHERE COMPLETION_TIME &lt; SYSDATE - 30;\n\n-- Check current RMAN configuration settings\nSHOW ALL;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Conclusion<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Fast Recovery Area (FRA) is vital for managing backups, archived logs, and recovery operations. Centralizing these files helps in maintaining database reliability and simplifies daily maintenance. Regular cleanup, size management, and monitoring ensure smooth database performance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Fast Recovery Area (FRA) is a centralized storage location in Oracle used to store all essential recovery-related files. It simplifies backup and recovery operations by managing the following components in one place: FRA Configuration Check FRA Usage Scenario 1: FRA is Full Solution: Scenario 2: Unable to Create New Archived Logs Solution: Scenario 3: [&hellip;]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,984],"class_list":["post-4142","cposts","type-cposts","status-publish","hentry","category-notes","category-oracle-dba-d2d-tasks"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/4142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=4142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=4142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}