This content has been marked as final. Show 4 replies
Will you have both archivelog and flashback logs in the FRA ?
Really it all depends on your standards, budget, monitoring, tape drives, maintenance scripts etc.
How often do you backup the database ? How often do you backup archivelogs ? If you backup archives every 24 hours, then really you want to keep minimum 48 hours and preferably 72 hours on disk to allow for failed backups, bad tapes etc.
So ... rough estimate of 60GB for 3 days archivelog + 20GB for 24 hours flashback logs = 80GB.
You can reduce this by increasing archivelog backup frequency and reducing archivelog retention (backup archivelog all delete input).
ML/MOS ID 761126.1
Thanks for your response. If my policy is to flash back up to 24 hours, logically,
arch log (24 hrs) 20GB + flash logs (what is this and how to determine?) = 20gb + X
Flashback log volume depends on what kind of transaction you are doing. Insert ? Update ? Delete ?
From experience flashback volume is generally less than archivelog, so I just use the archivelog volume as a safe estimate.
You may find some useful information here :-