--------------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 The same for sid2.=0D I want to be certain that sid1 will not influence the performance of sid2= =2E Sid1 will be production, sid2 will be a test environment.=0D Is this setup possible with RAID 5 ??=0D =0D Can somebody advice me ?=0D =0D Rgds,=0D =0D Patrick Van der Sande=0D Managing Director =0D ANDES Consulting BVBA=0D email : [EMAIL PROTECTED] website : http://www.andes-consulting.be --------------Boundary-00=_6LRIBHK0000000000000 Content-Type: Text/HTML; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <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--> =0A</head> <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> <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 hspace=3D0 src=3D"cid:IMSTP.gif"; align=3Dbaseline border=3D0></A> =20 <I>IncrediMail</I> - <B>Email has finally evolved</B> - </FONT><A=20 href=3D"http://www.incredimail.com/redir.asp?ad_id=3D309&lang=3D9";><F= ONT=20 face=3D"Times New Roman" size=3D3><B><U>Click=20 Here</U></B></FONT></A></SPAN></SPAN></FONT> </BODY> </html> --------------Boundary-00=_6LRIBHK0000000000000-- --------------Boundary-00=_6LRIG6G0000000000000 Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <IMSTP.gif> R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gL////wAAAAAAAAAAAAAAAAAAAAAA AAAAACH/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).
![cid:IMSTP.gif"](cid:IMSTP.gif"){kind=link}