Oracle fra files

I hope my written content will helped you. Keep learning… Have a great day!!! Please comment here for your any query related to above content. You could write to mail me through : orakldba gmail. Add a comment. Active Oldest Votes. If you use user-managed backups, make sure you have backups of these files, then delete them. If you do not need any backup of these files, simply delete them. Improve this answer. Balazs Papp Balazs Papp Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.

Definition of your retention policy should be done in RMAN. Your policy can be a recovery window or the number of backups you want to save. If you keep the defaults, the backup files will be stored in the FRA with retention policy redundancy 1. Meaning that if I make two backups, 1 will be reclaimable. The first backup is removed, and the reclaimable space is back to 0. Be aware that the most common problem with an undersized FRA is a database hang, because the database cannot create an archivelog file at time of a logswitch.

The most common solution is to create a backup of the archivelogs, which will also delete these archivelogs. This doesn't make much sense if both the archivelogs and the backups are stored in the FRA. So, always investigate if you can locate backups outside the FRA. If you are licensed to use the advanced compression option, you can compress RMAN backups while they are created. Automatic compression of archivelog files is still not implemented by Oracle; see Oracle support Doc ID You should not write your own scripts to compress archivelogs in the FRA.

If you want to save space using your own scripts, you should create an archive location outside the FRA. A full FRA can cause a hanging database, so a system down. When monitoring the FRA, focus on the space that is unreclaimable and not just on the actual usage. Make sure you know your needs for your recovery window and flashback target. If you want to make sure you can use a flashback database, you should create a guaranteed restore point.

DBA with over 15 years of experience. Experience in various branches, with several modules. Thanks for this blog Bastiaan! Back to overview. System altered.