====== Flash Recovery Area (FRA) ======
  * Location
<code PLSQL>
show parameter db_recovery
</code>
  * FRA size

<code PLSQL>
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;
</code>

  * Usage
<code PLSQL>
select * from v$recovery_area_usage;
</code>

  * Augmenter (vérifier si espace physique est ok)
<code PLSQL>
alter system set DB_RECOVERY_FILE_DEST_SIZE=600G scope=both;
</code>
 \\ 

== 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>