Re: Drive Configuration

Your online redo logs are not multiplexed and therefore a single point of failure in your backup'n'recovery concept.

oli

On Thursday 25 January 2001 16:28, wmckay_at_hydrogenmedia.com wrote:
> I was asked by some hardware people of my suggested drive configuration for
> a 5 drive configuration.
>
> I recommended the following:
>
> Drive 1 - Oracle database software
> Drive 2 - System tablespace, control file_1, online redo log files
> Drive 3 - Roll back (RBS) tablespace, Temp tablespace, control file_2
> Drive 4 - Data tablespace, control file_3
> Drive 5 - Index tablespace, archived log files
>
> I thought this would optimize the performance of small transactions and
> small queries. I also thought it would optimize I/O performance by
> distributing the tablespaces. The database is for a Cold Fusion web site
> where there will be mostly reads but plenty of writes.
>
> They disregarded this configuration and decided to go with a raid-5 with
> everything on the single raid for recoverability. I caved in and said ok.
> Were they right?
>
> Sincerely,
>
> Woody

-- 
---

Oliver Artelt, System- und Datenbankadministration
---------------------------------------------------------------
  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
   email: oli@cubeoffice.de # web: http://www.cubeoffice.de
---------------------------------------------------------------