RE: 9i-OCP Question

> -----Original Message-----
> From: Senthil Kumar [mailto:senthilkumard_at_summitworks.com]
>
> 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

The question specifically says "how many disks does Oracle recommend...?" It seems to me that the correct answer is answer number 4, Oracle recommends 4 disks. (Quote: "When setting up a multiplexed online redo log, place members of a group on different disks. If a single disk fails, then ONLY ONE MEMBER of a group becomes unavailable..." - capitalization mine) Therefore 4 members -> 4 disks.

Here is a link to a relevant section from an Oracle manual.

Oracle9i Database Administrator's Guide, Release 2 (9.2), Part Number A96521-01 Chapter 7 - Managing the Online Redo Log: Placing Online Redo Log Members on Different Disks

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/onlineredo.htm#5414

"Placing Online Redo Log Members on Different Disks When setting up a multiplexed online redo log, place members of a group on different disks. If a single disk fails, then only one member of a group becomes unavailable to LGWR and other members remain accessible to LGWR, so the instance can continue to function.

If you archive the redo log, spread online redo log members across disks to eliminate contention between the LGWR and ARCn background processes. For example, if you have two groups of duplexed online redo log members, place each member on a different disk and set your archiving destination to a fifth disk. Consequently, there is never contention between LGWR (writing to the members) and ARCn (reading the members)."

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.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).