That would be the most optimal. I believe that the original question was about
OFA. And I also believe that the "middle of the road" configuration would have
4 disks.
On 2003.07.30 16:09, Peter Gram wrote:
> Hi
>
> 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" <ORACLE-L_at_fatcity.com>
>>> 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: senthilkumard_at_summitworks.com
>>> > >
>>> > > 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: ListGuru_at_fatcity.com (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: mgogala_at_adelphia.net
>>> >
>>> > 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: ListGuru_at_fatcity.com (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: kjanusz_at_att.net
>>>
>>> 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: ListGuru_at_fatcity.com (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 : peter.gram@MiracleAS.dk - http://MiracleAS.dk
>
>
>
>--
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
> Author: Peter Gram
> INET: peter.gram_at_miracleas.dk
>
> 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: ListGuru_at_fatcity.com (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: mgogala_at_adelphia.net
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: ListGuru_at_fatcity.com (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).
Received on Wed Jul 30 2003 - 15:19:30 CDT
