This content has been marked as final. Show 1 reply
NO, Standby redo logs will be used only if the database is in standby mode.
1) My Primary database having 3 online redo log groups and 3 standby redo log groups. My question is during the transaction, will it write in both online redo log and stand by redo log?
YES, it is recommended to have same number of SRL's created in primary and standby. In case of switch over it makes easy.
The Standby redolog group on standby recommended to be like : (maximum # of logfiles in primary DB +1) * maximum # of threads on the standby site. If i want to create SRL on the primary, do I have to follow the same recommendation?
YES, it is recommended to have additional SRL group.
Do we need one additional standby redo log group on the standby database to avoid Primary Database LGWR waiting while redo is applied?