Re: Raid and Mirroring Redo logs-Newbie

Hi,

I have worked with raid5 on dec systems and I am mentioning some points which might be useful to you.

1. I did mirror the archived logs from raid to an internal disk (using a shell script) because of 24x7 requirement(prevention against raid controller failure). It may not be a good idea(performance wise) to keep redo on raid. As far as I know, mirroring redo on raid 5 may not be reqd. I would suggest putting redo on one internal disk, and its mirror on another (unless you have your redo on raw). It is unlikely that both disks will fail together.
2. If your environment is going to be OLTP, then multi-threaded might be better. If it going to be DSS, warehouse, batch kind of apps then dedicated is better off. If you have a mix your batch type apps should use a dedicated server.

I hope this helps.

Ajit

In article <34d3ce7f.0_at_news1.ibm.net>,
  "DKite" <dkight_at_ibm.net> 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
>
> --

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet