RE: 9i-OCP Question

Roy,

I think you've got this backwards. To preserve the groups you need to preserve the members and thus you would multiplex the members.

If you multiplex the 4 members of the 2 groups over 4 disks you will minimize the risk of failure. If you lose one disk you still have three members left in each group so you can have up to 3 disks fail without the instance stopping.

With 2 groups, if you put all the members of a group on a single disk and you lose that disk you have lost the whole group and the instance will fail instantly or at the next log switch (depending on whether it was the current group or not).

Gudmundur

> I thought you need to preserve the groups, not (necessarily)
> the members.
>
> If you have each group on its own disk then if one disk goes,
> you've got a complete set of logs on the other. Or am I not
> thinking about this correctly?
>
> Cheers,
>
> -Roy
>
> Roy Pardee
> Programmer/Analyst/DBA
> SWFPAC Lockheed Martin IT
> Extension 8487
>
> -----Original Message-----
> Sent: Wednesday, July 30, 2003 11:10 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Answe is 4 disks . to keep each member on different disks .
>
> -ak
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, July 30, 2003 10:19 AM
>
>
> > Hi all,
> >
> > What is the correct answer for this?
> >
> > Q> If you have 2 redo log groups with 4 members each, how
> many disks
> > Q> 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).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: AK
> INET: oramagic_at_hotmail.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Pardee, Roy E
> INET: roy.e.pardee_at_lmco.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gudmundur Bjarni Josepsson
  INET: gbj_at_index.is

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).