Différences

Ci-dessous, les différences entre deux révisions de la page.

--- oracle:database:fra [08/03/2024 13:16] – mdl
+++ oracle:database:fra [13/10/2024 16:34] (Version actuelle) – mdl
@@ Ligne 15: / Ligne 15: @@
 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>