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

1. Check the current FRA destination.

2. Change db_recovery_file_dest parameter.

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

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.



How to enable flash recovery area in oracle database

How to enable and disable flashback in oracle database