We help IT Professionals succeed at work.

Comment on set up of Storage Foundation  HA with Oracle 10g Lab at home

p0sreed
p0sreed asked
on
611 Views
Last Modified: 2013-12-27
Hi,

I have 2 sun 220R, 1 compaq storageworks HSG80, 1 EMC DS-16B FC switch and 1 cisco 3500 xl switch at home.

I have intstalled solaris 10 and storage foundation for oracle HA 4.1 on both the boxes.

I like to set up an Oracle 10g parallel cluster at home.

My queries are:

1) How many disks do i need in the storage works box for the setup, it right now has 3 disks and has room for 9 more disks and i don't know how many luns i will require for the database

2)Do i need Storage Foundation for Oracle RAC for the parallel implementation or just Storage Foundation for HA Oracle will do?

3)where should i install the Oracle? do i install it on the host disks or set up the luns and install it on them

Please, provide me with expert guidance to build a rock stable Oracle 10g parallel VCS cluster.

Thanks,

Ian
Comment
Watch Question

Mark GeerlingsDatabase Administrator
CERTIFIED EXPERT

Commented:
1) "How many disks do i need... "  A lot more than three!  That is, if your goal is to "to build a rock stable Oracle 10g parallel VCS cluster".  How many more?  That depends on two things:
a).  how big your Oracle database will be
b.)  which RAID level(s) you use
Be aware that RAID5 if a popular option with storage systems, and it is a good choice for Oracle table data and the Oracle system tablespace, but it is a very poor fit for things like: the undo (or rollback) tablespace; the temp tablespace(s); the on-line redo logs; the archived redo logs; and export "dump" files.  All of those perform much better on RAID1 or RAID0, but don't use RAID0 for the undo tablespace, since RAID0 offers no protection against disk failure.  If you have a large write cache in the storage system, that can reduce the problems with RAID5.

2)"Do i need Storage Foundation for Oracle RAC...?"  Sorry, I don't know.  I have only limited RAC experience.

3. "3)where should i install the Oracle [executable files]?"  Either place.  Local disks work fine, but if you have enough space and more redundancy in the storage system, you could install there.  If your server O/S is on local disk, and the local disk fails, your server is down anyway.  If the Oracle executables are on a storage system LUN, this would allow you to just re-install the O/S on a new disk and not have to re-install Oracle if/when your local disk fails.

Author

Commented:
Should i use VCS to manage my cluster or should i be using Oracle's RAC?

I have worked on an environment where the oracle database used to run parallel on both the nodes and the storage was shared.

I am trying to achieve the same, but i am not sure if they company used oracle RAC or VCS to run it parallel

Please, enlighten me.
TolomirAdministrator
CERTIFIED EXPERT
Top Expert 2005

Commented:
It might be a good idea to take a look in this book

http://www.amazon.com/Database-Application-Clusters-Handbook-Osborne/dp/007146509X

It comes with the search inside feature to check a few topics.

---

Setup of a RAC should be done carefully and you need a rather longer list of requirements do have a good start.

We actually did hire an Oracle consultant for 2 days to setup the RAC for us.

--

To monitor the RAC it might be useful to also setup Oracle Grid Control that is also a bit tricky to install, done that a couple of times, not a big problem.

---

OK: My suggestions are this:

You can install the oracle program files on a raid 5 array but never install the datadata on anything but a raid 1 (mirror). If might be also a good idea to have a dedicated disk for the "online redo logs" we are experiencing a not that nice latency if oracle has to move large data amounts in the database.

Here is a nice cookbook to get an impression how to setup a RAC:

http://www.iselfschooling.com/mc4articles/RACinstallation.htm (Solaris)
http://www.puschitz.com/InstallingOracle10gRAC.shtml (linux)
http://www.oracle.com/technology/pub/articles/smiley_rac10g_install.html (linux)

Tolomir

Author

Commented:
HI,

I have 4 luns visible to my hosts of which 3 are on raid 10 on the san and one of them is on raid 1.

i want to create 2 database instances on the vcs cluster in active-active configuration.

how do i go about it?

Also, i have compaq storageworks hsg80 as my san box.

Do you think HSG80 supports I/O fencing?

-Ian
Mark GeerlingsDatabase Administrator
CERTIFIED EXPERT

Commented:
I have no experience with Compaq SAN hardware, so I have no idea what features and technologies it supports.

But, do you still have only three physical disks in the SAN?  If yes, you have no hardware redundancy.

Author

Commented:
I have hardware redundancy.

I said, i have 3 luns visible on raid 10 visible to my hosts and 1 lun on raid 1 visible to my hosts.
Mark GeerlingsDatabase Administrator
CERTIFIED EXPERT

Commented:
LUNs and physical disks are *VERY* different things!  LUNs may be only a portion of a physical disk, or they may span entire multiple disks, or in some systems, they may be portions of multiple disks.

In your original question you indicated that you had just three physical disks in your storage system.  Is that still true?

It doesn't matter home many LUNs you divide these three disks into.  With only three disks you don't have redundacny for more than a single disk faliure.

Author

Commented:
Oh, sorry about that. the disk array holds 14 disks and i added 11 more to it.

I have the HSG80 controller.
Database Administrator
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.