Re: RE: 9i-OCP Question

dont know from experience, since I dont handle backups and redo, but according to the books, you are multiplexing your redo log groups. so if one of the files gets corrupted, etc... you have exact duplicates on different storage devices.

So if you put all the members on the same storage device and you move onto the the next redo log group and then that storage device goes bad, you lose all the redo.

now lets say you are in archive log mode and your archive log hasnt kept up... and was still archiving data. you cant recover from that point in time.

please correct me if Im wrong. Im half responding to make sure I understand it correctly.
>
> From: "Pardee, Roy E" <roy.e.pardee_at_lmco.com>
> Date: 2003/07/30 Wed PM 03:14:30 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: 9i-OCP Question
>
> 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 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: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.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).