| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle and High Availability solutions
That's what we're configuring too. It's true to say that only one instance
will have any database open at any given time. Two sets of binaries should
not be a problem though provided both are the same versions. Obviously both
machines should be running the same O/S too.
We have the oracle binaries installed on 2 HA servers so we can run 1/2 of our instances on each machine, with each machine providing failover for the other one's instances. The servers are both SGI IRIX 6.5 with SGI's fail-safe software. Version 1 was originally installed and found to be unuseable. It provided no means for manually shutting down an instance without it automatically failing over the entire machine. Version 2 is being installed this week. It's supposed to provide that functionality. You need to remember to disable the fail-over "unit" that includes the instance to be downed though.
One thing you need to remember to do with this type of HA strategy is to not mix datafiles from 2 different instances on the same logical file systems. Otherwise if one of them fails over, the 2nd will experience a media failure when the filesystems are unmounted.
Also you should scale both machines so that they can run all instances
should there be a critical component failure on one machine.
--
Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA
Steve.Parker@
lis.co.uk To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Ext: NA cc: (bcc: CHUCK HAMILTON/QVC)
Sent by: Subject: Oracle and High Availability solutions
root_at_fatcity.
com
05/08/00
06:44 AM
Please
respond to
ORACLE-L
Dear All,
Consider High Availability (HA) Oracle systems, i.e UNIX and
MC/ServiceGuard / TruCluster / HACMP etc
where the Oracle database and binaries are held on a 'highly resilient'
shared disk array which can be
accessed from 2 or more servers.
When either the HA Service providing Oracle is gracefully 'bounced' from
one
server to the other, or is restarted on an alternate server due to the main
server
crashing etc, is it true to state that only one server at any one time is
accessing
( or can access ) the Oracle database.
Oracle parallel server is NOT being used !
In all cases, 'simple' scripts are used by the HA Service to stop and start
Oracle,
which normally mimic what an operator would do anyway.
I would have thought that 2 sets of binaries accessing the same database would have disatrous consequences.
Any thought / experience / comments please .....
Thanks
Steve Parker
Technical Consultant
LIS
--
Author:
INET: Steve.Parker_at_lis.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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 Received on Mon May 08 2000 - 11:11:48 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |