Path: news.cambrium.nl!textnews.cambrium.nl!feeder8.cambrium.nl!feed.tweaknews.nl!209.197.12.246.MISMATCH!nx02.iad.newshosting.com!newshosting.com!69.16.185.16.MISMATCH!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!d7g2000prl.googlegroups.com!not-for-mail From: johnbhurley@sbcglobal.net Newsgroups: comp.databases.oracle.server Subject: Re: Oralce 10gR2 Setup questions Date: Tue, 31 Mar 2009 06:54:37 -0700 (PDT) Organization: http://groups.google.com Lines: 57 Message-ID: <75ecb2f2-a474-4321-8b39-55a29ad11c1a@d7g2000prl.googlegroups.com> References: <5i63t4pvbc9nlmk72m0452cm5dm5vsvqpq@4ax.com> NNTP-Posting-Host: 99.164.51.18 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1238507677 16143 127.0.0.1 (31 Mar 2009 13:54:37 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 31 Mar 2009 13:54:37 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: d7g2000prl.googlegroups.com; posting-host=99.164.51.18; posting-account=_6ry2goAAAB8CmCVzS5u_8_rocyBncPn User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.8) Gecko/2009032609 Firefox/3.0.8 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl On Mar 31, 12:44=A0am, bw wrote: > I have been running Oraclee 9.2 in WIndow2000 Server. =A0I have the > folowinf setup: =A0Drive C: Oracle Home; =A0Drive D: Tablespace for Data; > Drive E: =A0Tablespace for Index; =A0Drive F: Archive redo Log; =A0Drive = G: > RMAN Backup location. =A0This database supports a busy on-line system > with 24X7 update. =A0The transactions are regular text data. > > It worked very well for many years. =A0C, D, E, F, G are different > volumes on different physical drives to enhance repsonse time, > reliability and recoverability. =A0Each volume will not be too big, > probably around 80G, except the G which may house 2 or 3 copies of > RMAN. > > And we are upgrading to Oracl 10g R2 on Window 2003 very soon. =A0We > will be purchasing Blade Servers. =A0Wonder if there is need to separate > the database components as now. > > If we are moving to SAN, do I need to carve the SAN similarly ? =A0Do we > need to separate Data and Index Tablspaces on different LUN (it then > carved uder different physical drives). =A0I heard that SAN have the > Cache, and this steps may not be needed. > > I probably set up the Flash Recovery Area in F drive to hold the > Archive Logs. =A0Should I use this area for RMAN files as well ? =A0I > recalled it was recommanded to separate Archived Logs and Rman files > to make recoverability better. > > I have one last questions on where I should place Oracle Home. =A0If I > install Oracle on drive D in SAN, what if the System drive C fails. > After I reinstall WIndow 2003, do I just =A0update the PATH to point to > the Oracle Home in drive D in SAN, and recreate the instance using > oradim ? =A0 > > Thanks > > BW It all depends on what your definition of a "buy online system" is and there are lots of ways to measure that. Obviously one choice is to "not do very much at all" as you move to a SAN. Another choice is to drink heavily of the Oracle Kool aid and go ASM etc. ( We moved into ASM and it is working well for us ... ). You don't really need to use a flash recovery are but you certainly can if you want to. Many people feel that data and index tablespaces do not need to be separated out ( but ours still are ) especially once ASM is considered. Lots of choices in the ASM world including using external redundancy ... etc. If you have the time ... do some setup in different ways and do some benchmarking of performance in different setups. I guess one should argue that without doing benchmarking and checking out different possible setups you are just shooting in the dark.