Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why does the sequence of the online redo logs change sporadically?

April 26, 2017logs online redo sequence sporadically

0

Posted

Why does the sequence of the online redo logs change sporadically?

1 Answer

0

Posted

If the next online redo log is still archived, while another redo log is available for overwriting again, this redo log becomes the next redo log. This changes the sequence of the online redo logs. This behavior is desirable because the alternative would be an archiver stuck, at least temporarily. This situation can only occur if several archive processes run in parallel, and if they do not run again when the redo logs are archived. To avoid this problem, check if the archiver performance can be optimized (I/O tuning). Also, you must avoid an archiver stuck situation because of a fully run archive file system. This problem cannot occur if the number of archiver processes is limited to one by LOG_ARCHIVE_MAX_PROCESSES and if you have taken into account Note 445226.