This content has been marked as final. Show 3 replies
Yes. By configuring FRA, directories and subdirectories will be created automatically based on file type and date for recovery related files .FRA is required only for flash back logs. Other destinations can be set manually.
Are there any other compelling reasons to configure FRA ?
Any compelling reasons not to configure FRA ?If you want manually control space for backups and archivelogs.
Occasionally ppl have some doubts regarding the FRA. I am not sure why.
There is another such post but I didn't find it.
The FRA can simplify your configuration and management, of backups and archivelogs.
(I often use it just for the archivelogs, since I believe that the backups can sit outside the FRA. This, because I believe based on my short years that archivelog generation, requires almost hourly management, while backup only daily).
Please take a look at:
Benefits Of Using Flash Recovery Area [ID 560133.1]
hope it helped.
No reason not to use FRA, it is an advantage on every aspect of the protect/backup/restore/recovery process.
- easier to multiplex the critical files (redo logs / controlfiles) even if on this aspect you can use DB_CREATE_ONLINE_LOG_DEST_X instead if you want 0 permanent file in the FRA
- easier to backup (basically backup to the FRA on disk with the suggested strategy, backup the FRA to tape)
- easier to restore/recover, you can catalog files in the FRA with one command etc. etc. etc.
You don't lose any control using the FRA, you can have sophisticated retention policy if you want...
With OMF + FRA Oracle gives us a complete way to manage the Oracle files and to be completely independent from the platform, no OS commands/knowledge needed anymore for the DBA, we can work exclusively at Oracle level.
Implicit crosscheck/catalog of the FRA by RMAN can be a problem in some rare cases but the pros of the FRA are far more important than the cons.