I have an 8i database in No Archive Log mode and am planning to bring it in Archive Log mode.
I am trying to calculate the need of disk storage based on how much Archive would be generated.
One simple calculation for daily log generation will be --
(size of the redo log) * (Log switches per day)
I do wonder though that Archive log size may not be be actually same as the Redo log because Redo log can switch even without being filled.
Do you guys have any suggestions ?
(size of the redo log) * (Log switches per day) is the safe calculation. Although you can manually switch the logfile, it will be smaller than a full log file.
Click Here to Expand Forum to Full Width