Flash Recovery Area (FRA)

• Location

show parameter db_recovery

• FRA size

SET linesize 500
col NAME FOR a50
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;

• Usage

SELECT * FROM v$recovery_area_usage;

• Augmenter (vérifier si espace physique est ok)

ALTER system SET DB_RECOVERY_FILE_DEST_SIZE=600G scope=both;

== ACTIVER == * Activer la FRA <code PLSQL> alter system set db_recovery_file_dest_size=20G scope=both; alter system set db_recovery_file_dest='/u07/oradata/FRA' scope=both; alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=both; </code> * Passer en ARCHIVELOG <code PLSQL> SQL> select log_mode from v$database; LOG_MODE ———— NOARCHIVELOG SQL> shutdown immediate; SQL> startup mount; SQL> ALTER DATABASE ARCHIVELOG; SQL> ALTER DATABASE open; </code>