RE: formula for # of redo groups
- From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- To: <dag@xxxxxxxxxxxxxxx>, "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 Oct 2006 14:15:37 -0500
I've never seen a formula for this, and I've seen all kinds of
configurations. I will say that a 2 by 2 is a bit small, especially for
archiving. It's best to have some distance between LGWR and ARCH.
Having more then 3 groups is generally considered goodness. Having at
least 3 members is also considered goodness since this gives a backup of
the backup so to say.
Ric Van Dyke
Hotsos Enterprises
-----------------------
Hotsos Symposium March 4-8, 2007. Be there.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Doug Gernaat
Sent: Wednesday, October 11, 2006 1:50 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: formula for # of redo groups
is there a tried and true formula for deciding on the number
or redo groups and members? is the decision solely based on
LGWR activity? what about archiving? for example... a
database with 2 groups and 2 members in each group that
switches about 10 times a day producing 10 archive files.
what is optimal in a relative world?
thanks
-doug-
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
