How To Change Flash Recovery Area Location

Below are the steps for changing the flash recovery area(FRA destination).

1. Check the current FRA destination.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

SQL> show parameter db_recovery_file   NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest                string      /dbaclassdb/oradata/FRA db_recovery_file_dest_size           big integer 20G     SQL> select name from V$RECOVERY_FILE_DEST;   NAME                                   -------------------------------------- /dbaclassdb/oradata/FRA

2. Change db_recovery_file_dest parameter.

1 2 3 4 5 6 7 8 9 10 11 12

SQL> alter system set db_recovery_file_dest='/fradg/oradata/FRA' scope=both;   System altered.     select name from V$RECOVERY_FILE_DEST; NAME                                   SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES     CON_ID -------------------------------------- ----------- ---------- ----------------- --------------- ---------- /fradg/oradata/FRA               2.1475E+10          0                 0               0          0

From onwards new files will be created in this new location. However, the flashback logs will be c

For the FLASHBACK logfiles to be able to pick up the new ‘db_recovery_file_dest’ location, we just need to disable and enable the flashback, which needs a downtime.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

1.  Drop restore point if any   SQL> select GUARANTEE_FLASHBACK_DATABASE,NAME from v$restore_point; GUARANTEE_FLASHBACK_DATABASE     NAME -------------------------------- ----------------------------- YES                              RESTORE_UPGRDE     SQL > Drop restore point  restore_point RESTORE_UPGRDE ;   2. Turn off and turn on flashback :   ALTER DATABASE FLASHBACK OFF; ALTER DATABASE FLASHBACK ON;