| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Advice needed
--------------Boundary-00=_6LRIG6G0000000000000
Content-Type: Multipart/Alternative;
boundary="------------Boundary-00=_6LRIBHK0000000000000"
--------------Boundary-00=_6LRIBHK0000000000000
Content-Type: Text/Plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
=0D
Dear,=0D
=0D
The following machine has been bought but not yet installed : =0D
SUN FIRE 6800 =0D
12 CPU a 1,2 Ghz =0D
24 GB Memory =0D
4 X 36 GB internal disks =0D
4 X 14 X 36 GB SAN 15k rpm 2 RAID Controllers (4 T4) =0D
Preconfigured with 1 RAID 5 volume & 1 Hot spare =0D
2 GB PCI fibre channel network adapter =0D
=0D
Now my concerns and questions : =0D
=0D
1) What RAID architecture must we implement ?? =0D
SUN suggest to use RAID 5. At first I do not agree. I always thought RAID
0+1 or RAID 1+0 was better=0D
than RAID 5 certainly for write operations. SUN says the performance will=
be=0D
the same because of the number of disks. Is this true ?? =0D
I guess they will spread parity over all disks. =0D
=0D
According to SUN we need to invest more, before in our case RAID 0+1 or R=
AID
1+0 can be more=0D
performant than RAID 5. I do not know yet what we should invest in. It ha=
s
something to do with the connection to the disks.=0D
=0D
What about restoring 1 data file ? Since SUN suggest to setup RAID 5 over
all disks, is it still possible to restore 1 datafile ?=0D
Does somebody know the answers to my questions ?=0D
=0D
SUN is coming over on wednesday to discuss SAN config and I want to be
prepared. I will not take anything for granted.=0D
=0D
2) What about the file systems ? =0D
I know that the more database files are spread over different disks the
better. =0D
Two databases will be installed.=0D
I propose the following file systems :=0D
=0D
/sid1 --> contains application files and admin directory=0D /sid1/dbs -> contains datafiles for SYSTEM,UNDO,TEMP & REDO log files.=0D /sid1/dbs/data -> contains DATA tablespaces datafiles=0D /sid1/dbs/index --> contains INDEX tablespaces datafiles=0D /sid1/dbs/arch --> contains archived REDO log files=0D=0D
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-885= 9-1"><html>
<head> <meta name=3D"GENERATOR" content=3D"IncrediMail 1.0">=0D <!--IncrdiXMLRemarkStart> <IncrdiX-Info> <X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID> <X-FVER>2.0</X-FVER> <X-CNT>;</X-CNT> </IncrdiX-Info> <IncrdiXMLRemarkEnd-->
<BODY background=3D"" bgColor=3D#ffffff style=3D"BACKGROUND-POSITION: 0px=
0px; FONT-SIZE: 10pt; MARGIN: 1px; FONT-FAMILY: Arial" scroll=3Dyes ORGY=
POS=3D"0" X-FVER=3D"2.0">
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 id=3DINCREDIMAINTABLE w=
idth=3D"95%">
<TR>
<TD id=3DINCREDITEXTREGION width=3D"100%" style=3D"PADDING-RIGHT: 7px; PA= DDING-LEFT: 7px; FONT-SIZE: 10pt; FONT-FAMILY: Arial"=20
>
<DIV> </DIV>
<DIV><STRONG>Dear,</STRONG></DIV>
<DIV><STRONG></STRONG> </DIV>
<DIV>The following machine has been bought but not yet installed : =
<BR>SUN=20
FIRE 6800 <BR>12 CPU a 1,2 Ghz <BR>24 GB Memory <BR>4 X 36 GB inter= nal=20
disks <BR>4 X 14 X 36 GB SAN 15k rpm 2 RAID Controllers (4 T4)=20
<BR>Preconfigured with 1 RAID 5 volume & 1 Hot spare <BR>2 GB P=
CI=20
fibre channel network adapter <BR><BR>Now my concerns and questions=
:=20
<BR></DIV>
<DIV>1) What RAID architecture must we implement ?? <BR>SUN suggest=
to use=20
RAID 5. At first I do not agree. I always thought RAID 0+1 or RAID =
1+0 was=20
better<BR>than RAID 5 certainly for write operations. SUN says the=20
performance will be<BR>the same because of the number of disks. Is =
this=20
true ?? <BR>I guess they will spread parity over all=20
disks. <BR></DIV>
<DIV>According to SUN we need to invest more, before in our ca=
se RAID=20
0+1 or RAID 1+0 can be more<BR>performant than RAID 5. I do not kno=
w yet=20
what we should invest in. It has something to do with the conn=
ection=20
to the disks.</DIV>
<DIV> </DIV>
<DIV>What about restoring 1 data file ? Since SUN suggest to setup =
RAID 5=20
over all disks, is it still possible to restore 1 datafile ?</DIV>
<DIV>Does somebody know the answers to my questions ?</DIV>
<DIV> </DIV>
<DIV>SUN is coming over on wednesday to discuss SAN config and I wa=
nt to=20
be prepared. I will not take anything for granted.<BR></DIV>
<DIV>2) What about the file systems ? <BR>I know that the more data=
base=20
files are spread over different disks the better. <BR>Two databases=
will=20
be installed.</DIV>
<DIV>I propose the following file systems :</DIV>
<DIV> </DIV>
<DIV>/sid1 --> contains application files and admin directory</D=
IV>
<DIV>/sid1/dbs -> contains datafiles for SYSTEM,UNDO,TEMP & =
REDO=20
log files.</DIV>
<DIV>/sid1/dbs/data -> contains DATA tablespaces datafiles</DIV>
<DIV>/sid1/dbs/index --> contains INDEX tablespaces datafiles</D=
IV>
<DIV>/sid1/dbs/arch --> contains archived REDO log files</DIV>
<DIV> </DIV>
<DIV>The same for sid2.</DIV>
<DIV>I want to be certain that sid1 will not influence the performa=
nce of=20
sid2. Sid1 will be production, sid2 will be a test environment.</DI=
V>
<DIV>Is this setup possible with RAID 5 ??</DIV>
<DIV><BR>Can somebody advice me ?<BR></DIV>
<DIV><STRONG>Rgds,</STRONG></DIV>
<DIV><STRONG></STRONG> </DIV>
<DIV><STRONG>Patrick Van der Sande</STRONG></DIV>
<DIV><STRONG>Managing Director </STRONG></DIV>
<DIV><STRONG>ANDES Consulting BVBA</STRONG></DIV>
<DIV><STRONG>email : </STRONG><A=20
href=3D"mailto:[EMAIL PROTECTED]"><STRONG>patrick.van=
[EMAIL PROTECTED]</STRONG></A></DIV>
<DIV><STRONG>website : http://www.andes-consulting.be</STRONG></DIV=
></TD>
<TR>
<TD id=3DINCREDIFOOTER width=3D"100%">
=09<TABLE cellPadding=3D0 cellSpacing=3D0 width=3D"100%"> =09<TR> =09<TD width=3D"100%"></TD> =09<TD align=3Dmiddle id=3DINCREDISOUND vAlign=3Dbottom></TD> =09<TD align=3Dmiddle id=3DINCREDIANIM vAlign=3Dbottom></TD> =09</TR> =09</TABLE>
</TD>
</TR>
</TABLE><SPAN=20
id=3DIncrediStamp><SPAN dir=3Dltr><FONT face=3D"Arial, Helvetica, sans-se=
rif"=20 size=3D2>____________________________________________________<BR><FONT=20 face=3D"Comic Sans MS" size=3D2><A=20 href=3D"http://www.incredimail.com/redir.asp?ad_id=3D309&lang=3D9"><I=MG alt=3D""=20
--------------Boundary-00=_6LRIG6G0000000000000 Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <IMSTP.gif> R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gL////wAAAAAAAAAAAAAAAAAAAAAAAAAAACH/C05FVFNDQVBFMi4wAwEAAAAh+QQJFAAIACwAAAAAFAAPAAAEVRDJSaudJuudrxlEKI6B URlCUYyjKpgYAKSgOBSCDEuGDKgrAtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRt E30tVVRscMHDqV/u+AgAIfkEBWQACAAsAAAAABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQAIfkE CRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCqK1kS9grQhXGAhsDBUJgZ AL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKXdAgRAQAh+QQFCgAIACwAAAAAFAAPAAAEEhDJ Sau9OOvNu/9gKI5kaZ5oBAAh+QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj 1g2FsKorWRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0CBEBACH5 BAVkAAgALAAAAAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs=
--------------Boundary-00=_6LRIG6G0000000000000--
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patrick Van der Sande INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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 Fri Jul 04 2003 - 17:30:26 CDT
 |
 |