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.
(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.
Bookmarks