RedoLogs vs. StandbyRedoLogs
Hey,
in my db configuration ( I didn´t setup the database) I have a configuration, where the RedoLogGroups have 3 Groups with 4 members each.
The standbylogs for the standbydatabase have 3 groups and 5 members.
Does that make any sense ? I know that it will work, but wouldn´t it be better to just have 4 members in each group for the standby logfiles ?
Does it have any performance impact or other issues ?
v$log - Primary Site
GROUP# THREAD# BYTES
---------- ---------- ----------
1 2 134217728
2 2 134217728
3 3 134217728
4 3 134217728
5 1 134217728
6 1 134217728
7 2 134217728
8 2 134217728
9 3 134217728
10 3 134217728
11 1 134217728
12 1 134217728
v$standby_log - Standbysite
GROUP# THREAD# BYTES
------------ -------------- -------------
101 1 134217728
102 1 134217728
103 1 134217728
104 1 134217728
105 1 134217728
201 2 134217728
202 2 134217728
203 2 134217728
204 2 134217728
205 2 134217728
301 3 134217728
302 3 134217728
303 3 134217728
304 3 134217728
305 3 134217728
My configuration:
Oracle 10.2.0.4, SLES9, DataGuardBroker, 3-Nodes RAC + PhysicalStandby