I don't want to create a fight, but in a configuration with 2 groups and 4 members you need 8 disks :
1 disk for every member.
When the db is writing to one group the archiver will be reading from the other group, by the
why since there are multibe members in the group the db (archiver) will read 64 Kb chunks
from the each member and there by distribute the IO
That's my 2 cent's of knowledge, comment and correction are welcome :-)
Mladen Gogala wrote:
There are two reasons:
1) Redo log groups are never used simultaneously, so they can reside on
the same disk. Log members should not be on the same disks for increased
survivability. That gives us 2 groups with 4 members, each two members
sharing the same device - 4 disks alltogether.
2) It's because I say so and I'm an 8i OCP.
On 2003.07.30 13:44, KENNETH JANUSZ wrote:
Why? What is the logic?
Ken Janusz, CPIM
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 30, 2003 12:29 PM
> The answer is 4. Of course, no one in the right mind would have
> 2 groups with 4 members each.
>
> On 2003.07.30 13:19, Senthil Kumar wrote:
> > Hi all,
> >
> > What is the correct answer for this?
> >
> > Q> If you have 2 redo log groups with 4 members each, how many disks
does
> > Oracle recommend
> > to keep the redo log files?
> >
> > 1. 8
> > 2. 2
> > 3. 1
> > 4. 4
> >
> > Which is the correct answer.
> >
> > TIA
> > Senthil
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Senthil Kumar
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
-- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
