From: Jim Anderson <janderson@ci.lincoln.ne.us>
Subject: Re: Raid and Mirroring Redo logs-Newbie
Date: 1998/02/02
Message-ID: <34D623C5.D23B98B9@ci.lincoln.ne.us>#1/1
Content-Transfer-Encoding: 7bit
References: <34d3ce7f.0@news1.ibm.net>
To: DKite <dkight@ibm.net>
Content-Type: text/plain; charset=us-ascii
Organization: City of Lincoln, Nebraska
Mime-Version: 1.0
Reply-To: janderson@ci.lincoln.ne.us
Newsgroups: comp.databases.oracle.server



I'm not sure about the second question, but a definate yes on the first. As
with you, I wondered it this was necessary. I did not have mirrored redo logs
and one of the redo logs got corrupted. Because there was no mirror, the db
crashed. I created a mirror for each group. Again, the same redo file got
corrupted but this time the db did not crash because it could still write to
the mirror. I dropped the corrupt member and recreated it with no problems.

DKite wrote:

> I am relatively at Oracle.  I have 2 questions.
>
> 1.  We have an HP with raid 5.  My Oracle instructor suggested that redo
> logs should be mirrored within Oracle.  Is this really needed with raid?
>
> 2.  The system will eventually have 2000 users.  Most of which will have a
> login, but may not being actively working at the one time.  Are there any
> rules to determine whether to run a multithreaded or 'normal' Oracle
> instance?
>
> Thanks in advance
>
> --