Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9i-OCP Question

RE: 9i-OCP Question

From: Paul Baumgartel <>
Date: Wed, 30 Jul 2003 14:09:33 -0800
Message-ID: <>

I'm constantly amazed (and relieved!) that there's disagreement on the most fundamental principles.

First, I found myself nodding at Roy's first post. On some databases, I have three log groups, with two members each. Each set of members has its own disk. I'll concede the argument that the instance goes down right away if one of the drives fails, but I _still_ have a full set of logs on the other drive, and that's a good thing, right?

Second, if I have three groups of two members each and follow what seems to be the consensus opinion, I have three drives, each holding two members, one from each group. In this case, aren't the two members on the same drive identical? If I lose that drive, I lose that entire log group, and therefore no longer have a full set of logs--so what's the point of having two copies? I also lose the instance immediately if that group happens to be the current group at the time of disk failure.

Third, while I agree that every member of every group should ideally have its own disk, does ANYONE actually configure their DB this way? I had a hard enough time dedicating one or two disks to redo logs; who can dedicate eight, especially given drive sizes of 72+ GB and (single) log file sizes of, what, 100 MB?

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Please see the official ORACLE-L FAQ:
Author: Paul Baumgartel

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 - 17:09:33 CDT

Original text of this message