| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9i-OCP Question
Well, in archivelog mode LogWriter may use one group and Archiver may
use the other group, so I'd agree with Kirti.
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
-----Original Message-----
Mladen Gogala
Sent: Wednesday, July 30, 2003 12:59 PM
To: Multiple recipients of list ORACLE-L
There are two reasons:
1) Redo log groups are never used simultaneously, so they can reside on
the same disk. Log members should not be on the same disks for increased
survivability. That gives us 2 groups with 4 members, each two members
sharing the same device - 4 disks alltogether. 2) It's because I say so and I'm an 8i OCP.
On 2003.07.30 13:44, KENNETH JANUSZ wrote:
> Why? What is the logic?
>
> Ken Janusz, CPIM
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, July 30, 2003 12:29 PM
>
>
> > The answer is 4. Of course, no one in the right mind would have
> > 2 groups with 4 members each.
> >
> > On 2003.07.30 13:19, Senthil Kumar wrote:
> > > 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
> > >
-- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: mgogala_at_adelphia.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: ineyman_at_perceptron.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).Received on Wed Jul 30 2003 - 14:34:24 CDT
 |
 |