redo log switches per week
19.9 on Oracle Linux
select count(*) from gv$log_history where first_time > sysdate - 7 ;
On checking some databases I noticed redologs sizes beinq quite big.
All is relative, but I then checked the number of logswitches, and found:
Most databases - and these are all Production,
have betwen 45 and 60 logswitches on a weekly basis.
45 logswitches per week is one logswitch every 224 minutes, on average
That doesn't sound sufficient, in context of backup accuracy.
I thought as a general rule to aim for 2 or 4 logswitches per hour,
which is one logswitch every 15 or 30 minutes.
One logswitche every 30 minutes sounds much better (than every 224 minutes),