Re: Oralce 10gR2 Setup questions
From: jgar the jorrible <joel-garry_at_home.com>
Date: Tue, 31 Mar 2009 10:05:21 -0700 (PDT)
Message-ID: <af8372af-61f4-4dd2-8eff-2c4b853224a1_at_d25g2000prn.googlegroups.com>
On Mar 30, 9:44 pm, bw <b..._at_abc.com> wrote:
> I have been running Oraclee 9.2 in WIndow2000 Server. I have the
> folowinf setup: Drive C: Oracle Home; Drive D: Tablespace for Data;
> Drive E: Tablespace for Index; Drive F: Archive redo Log; Drive G:
> RMAN Backup location. This database supports a busy on-line system
> with 24X7 update. The transactions are regular text data.
>
> It worked very well for many years. C, D, E, F, G are different
> volumes on different physical drives to enhance repsonse time,
> reliability and recoverability. Each 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. We
> will be purchasing Blade Servers. Wonder 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 ? Do we
> need to separate Data and Index Tablspaces on different LUN (it then
> carved uder different physical drives). I 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. Should I use this area for RMAN files as well ? I
> 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. If I
> install Oracle on drive D in SAN, what if the System drive C fails.
> After I reinstall WIndow 2003, do I just update the PATH to point to
> the Oracle Home in drive D in SAN, and recreate the instance using
> oradim ?
>
> Thanks
>
> BW
Date: Tue, 31 Mar 2009 10:05:21 -0700 (PDT)
Message-ID: <af8372af-61f4-4dd2-8eff-2c4b853224a1_at_d25g2000prn.googlegroups.com>
On Mar 30, 9:44 pm, bw <b..._at_abc.com> wrote:
> I have been running Oraclee 9.2 in WIndow2000 Server. I have the
> folowinf setup: Drive C: Oracle Home; Drive D: Tablespace for Data;
> Drive E: Tablespace for Index; Drive F: Archive redo Log; Drive G:
> RMAN Backup location. This database supports a busy on-line system
> with 24X7 update. The transactions are regular text data.
>
> It worked very well for many years. C, D, E, F, G are different
> volumes on different physical drives to enhance repsonse time,
> reliability and recoverability. Each 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. We
> will be purchasing Blade Servers. Wonder 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 ? Do we
> need to separate Data and Index Tablspaces on different LUN (it then
> carved uder different physical drives). I 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. Should I use this area for RMAN files as well ? I
> 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. If I
> install Oracle on drive D in SAN, what if the System drive C fails.
> After I reinstall WIndow 2003, do I just update the PATH to point to
> the Oracle Home in drive D in SAN, and recreate the instance using
> oradim ?
>
> Thanks
>
> BW
In addition to what everyone else said, look for papers about SAME like http://www.oracle.com/technology/deploy/availability/pdf/oow2000_same.pdf
In simple terms, the more disk spindles you can spread things across, the faster you can get everything, until you hit a data transfer bottleneck. If you have the disk space, avoid RAID-5.
jg
-- _at_home.com is bogus. "Thank you for your participation in Oracle’s global relationship survey. We have captured the responses you submitted. With your help, we are driving improvements that benefit your investments in Oracle. Your response is greatly appreciated. Sincerely, Jeb Dasteel Senior Vice President and Chief Customer Officer"Received on Tue Mar 31 2009 - 12:05:21 CDT