Environment: Oracle 18.104.22.168 on Win2k with Primary/Standby setup
I am trying to determine the size and number of redo logs for my primary database. I have a standby database set up for it. When I observe the current log switch, the most frequent log switch occurred within 6 minutes and the redo log size is currently 20MB each. I am thinking about shrinking it down to 3-5MB and in the meantime increasing the number of log groups from 3 to 6. However, as far as I know, archiving is not immediately activated when a log switch occurs. I worry if there are too many unarchived redo logs and the primary system fails, I will lose big. Does anybody have any suggestions/rule of thumbs to balance it out?