I believe the answer is 2 because you need to multiplex each group member
and you need a minimum of two spindles to do this.
You can't begin to reuse a redo log until it has finished archiving,
therefore, you need to put your archive logs on DISK 3 in order to prevent
your ARCH and Log Writer processes from competing. At least that is how I
think about things.
group A
log 1a DISK 1
log 1b DISK 2
log 2a DISK 1
log 2b DISK 2
log 3a DISK 1
log 3b DISK 2
log 4a DISK 1
log 4b DISK 2
group B
log 1a DISK 1
log 1b DISK 2
log 2a DISK 1
log 2b DISK 2
log 3a DISK 1
log 3b DISK 2
log 4a DISK 1
log 4b DISK 2
That way if you loose one disk, you can still recover your redo via the
remaining log.
Josh
-----Original Message-----
Sent: Wednesday, July 30, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L
Yep, that's right--I had it wrong. You need to have at least one member
from each group in order to do a full recovery. I see now from my trusty
dba fundamentals I class text that each member of a group is identical (or
is supposed to be).
So I guess I'll go back to being confused about why the answer to the
question below is 2. I guess 2 is the minimum required to survive a single
disk failure?
Cheers,
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-----Original Message-----
Sent: Wednesday, July 30, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
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" <[EMAIL PROTECTED]>
> Date: 2003/07/30 Wed PM 03:14:30 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> 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" <[EMAIL PROTECTED]>
> 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: [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: AK
> 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: Pardee, Roy E
> 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: <[EMAIL PROTECTED]
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: Pardee, Roy E
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: Josh Collier
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).
