Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: RAID Suggestions

Re: RAID Suggestions

From: karsten reincke <kreincke_at_cl-ki.uni-osnabrueck.de>
Date: Tue, 15 Jun 1999 09:49:37 +0200
Message-ID: <37660591.C7BCF00C@cl-ki.uni-osnabrueck.de>


rspeaker_at_my-deja.com wrote:
>
> Hi,
>
> I am looking for some basic suggestions / advice for setting up Oracle
> on an AIX RS/6000 using RAID. My initial plan included full disk
> mirroring at the OS level, but I'd like to move that to a RAID
> configuration and gain more usable disk space if possible.
>
> I have heard tales that RAID 5 is bad for Oracle ... is this true?
>
> Are there certain things that should or should not be included in the
> RAID arrays?
>

we have done two tasks:

(1) for the first time we had to build up a database with really many read-accounts but very rare write-accounts (although operating with many data, that work could have been done during the weekend). for this scenario we installed a RAID-5 configuration. but we had to hold externally all temporary tablespaces.

(2) for the second time we had to build up a database with really many read-accounts, where the read datasets in mostly all cases had to be written back in a changed manner. in this case we wanted to use a RAID 5 system too. but it seemed to be a bad idea: even if did not used a grouped a mirrored redolog and even if we put the temporary table-spaces outside of the RAID-system we could not organize the connections of time-sector in an acceptable manner.

so it has been a nice experiment, but now i prefer in all cases not to give up the oracle-internal security-organization by using an undelying RAID-system: better to think about a good tablespace-placement and good recovery-strategy than not to think by using a RAID-system.

       salut d'Allemagne kr



les chats cont les vrais hédonistes
et devraient être donc notre idéal.

 karsten reincke [ 0541/9696223 ]
 kreincke_at_cl-ki.uni-osnabrueck.de Received on Tue Jun 15 1999 - 02:49:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US