Re: resize redo logs to decrease archivelog generation

Posted by ErmanArslansOracleBlog on Aug 05, 2021; 11:13am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/resize-redo-logs-to-decrease-archivelog-generation-tp10048p10049.html

Thanks Roshan I m fine.
You need to consider the log switch frequency and the size of redo that you expect -- redo generated by your future DML operations.
You should be able to support the DML generation with your redo log size and count.. You shouldn't be blocking the database due to a redo member being active or current.. You need to have at least for redo available for us even in the case of a huge DML operations.. So consider sizing your redologs and adding more redologs accordingly. This is not related with striim or CDC.. Striim or CDC just reads the redo which is already placed in redologs or archivelog.. What you are asking is the redo size and count and it is related with your database config.