| 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 Parallel Server / Other HA Solutions
I agree with Jay on the timing. If you can cold backup each night, you don't
need OPS. or HA.
Just keep some hw spares handy and check your backups nightly!
Here is my recent war story.
We needed "higher availability" ( not precisely defined ) We decided NOT we "needed" a cluster for availability. We ( i.e. Management ) decided OPS was "too unstable"
( based on the opinions of DBAs with no hands-on experience with it)
The System rebooted and failed almost daily during setup and "testing".
It has already failed once in its first month of service.
Sun "Platinum" Support points to Veritas who points to Sun who points to the Field Engineer who set up the system.....you get the idea.
Point: Our Clustering experience with Sun is highly sub-optimal.
Other Sun implementation are, I'm sure, wonderful. ( Seriously.) But....it all comes down to making biz reqmnts match cost constraints, match technical capabilities........
My experience with OPS has been great. Very stable. Easy to administer. Sure, it's *slightly* harder to set up. But, the ongoing costs are lower than for some other choices, in my limited experience.
YMMV, IMHO, etc.
hth
Ross
-----Original Message-----
From: Jay Hostetter [mailto:jhostetter_at_decommunications.com]
Sent: Thursday, October 12, 2000 1:02 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle Parallel Server / Other HA Solutions
We have a Compaq Tru64 cluster with Oracle 7 and 8 databases. We opted to NOT install OPS. The cluster runs scripts to bring up a 'service' - which is really a virtual node with its own ip address. If a node fails, the cluster brings up the service (and the database) on the other node - no manual intervention required. This means a few minutes of downtime for the database, but it also means fewer headaches by not having to deal with OPS.
When we initially set this up, we made some calls to DEC/Compaq to ask
questions. They basically said that more people should do what we are
doing, rather than going with OPS which is usually overkill for most shops.
Oracle salesfolks recently paid us a visit and tried to talk us into OPS.
The 8i version is supposed to be easier to install. They also introduced
'cache fusion' which basically makes the SGA of one instance available to
the other instance using shared memory channels. But you still have to deal
with raw devices, etc.
In my opinion, if you can afford to do cold backups each night, you don't
need OPS.
>>> "Ruiz, Mary A (CAP, CDI)" <Mary.Ruiz_at_gecapital.com> 10/12/00 10:58AM >>>
I need a little advice. We have a fairly new (< 1 year) 8.1.5 instance to
support my company's internet business. We recently changed our network
solutions provider and now my management wants to achieve a higher level of
redundancy than it currently does with mirrored disks. The solution being
proposed by my Sysadmin is an Oracle Parallel Server solution. Some
background is in order here - we have always shut our databases down at
night for backups. I am not highly skilled in backup and recovery although
I tried some of the hot backup techniques from this list and was able to
recover successfully to another server. I noticed that the course offered
by Oracle in OPS has backup and recovery as well as performance tuning as
pre-requisites, which indicates to me that OPS could be extremely
challenging. Also, I have read mainly unfavorable comments about OPS from
this list, but most of those comments were based on the Oracle 7
implementations (High administrative costs, difficult to implement, etc.).
Have things improved with Oracle 8i ? Is OPS worth pursuing? Or should I convince my management that extra $$ spent in, say, a hot standby database is well worth it? Is there any other solution that would not involve a second set of disks, rather a second database on the same set of disks ??
Thanks in advance,
Mary Ruiz / Atlanta
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruiz, Mary A (CAP, CDI) INET: Mary.Ruiz_at_gecapital.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: 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 also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: jhostetter_at_decommunications.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: 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 mayReceived on Thu Oct 12 2000 - 13:45:10 CDT
 |
 |