Ah but with 9i, RAC and TAF you can have the users reconnected
automagically and they will resume their transactions inflight.
- Kimberly Smith <ksmith2_at_myfirstlink.net> wrote:
> You will always have the same issues with fail over technology. Your
> users
> will get disconnected. My databases take less then 5 minutes to fail
> over
> and that is an acceptable time frame to the client. Its great from
> my
> standpoint
> for maintenance cause I can do it on one node, fail the databases
> over, and
> bring the other node up to date. I do not have the Oracle software
> itself
> in fail over, just the database. We do not find it to hard to work
> with
> here.
> I have no experience with Sun's so I cannot compare them.
>
> Whether or not you go with fail over technology all depends on what
> you are
> looking for. You will not lose any committed data with HP's
> (probably not
> with anyone else's either). Fail over is automatic when configured
> correctly.
> I have seen it happen once that I did not even know, it was that
> quick.
> Went
> to go look for my database on the server and it was not there:-)
>
> -----Original Message-----
> McCann
> Sent: Thursday, January 17, 2002 10:05 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Thanks for your help everyone. Very useful advice, although your
> scaring me
> of Sun Clusters.
>
> At the minute, Parallel server looks the best, with a standby
> database
> remotely for disaster.
>
> Does anyone know what the HP solution is like (MC Service Guard)? I
> think
> some one on this list gave it a good review in the past .
>
>
> Thanks,
>
> Jim
>
>
> -----Original Message-----
> Sent: 17 January 2002 17:12
> To: Multiple recipients of list ORACLE-L
>
>
> IBM HACMP works well.
>
> Ooops. guess that means you'll have to change some things. ;-)
>
> Seriously, we *did* get the Sun "clustering" working, but it
> required some serious feet-to-fire holding and gyrations.
>
>
> -----Original Message-----
> Sent: Thursday, January 17, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Thanks for the advice everyone.
>
> So what do you recommend on a Sun cluster/machines for failover other
> than
> OPS?
> Quest Shareplex?
> Standby database?
> Any others?
>
> Thanks,
>
> Jim
>
>
>
> -----Original Message-----
> Sent: 17 January 2002 16:22
> To: Multiple recipients of list ORACLE-L
>
>
> I concur with BB.........yea, I ran Sun "cluster" at <deleted> and
> it broke ALOT.
>
> Kept me and two full time Sun Engineers (they got paid ALOT more)
> in consulting dollars, but i made a mental note not to use
> it in "my business".
>
> Caveat: this was 1.5 years ago. Things change.
>
> Mit Gluck, mein freund.......
>
>
> - Ross "mit schuss" Mohan
>
> -----Original Message-----
>
>
> Jim:
> Sorry, you're not gonna like this answer. HA is a Sun product, not
> an
> Oracle product. Under Sun's High Availability, you can configure
> several
> modules like Sybase and Oracle. (The Oracle product is Sun Cluster
> HA-DBMS
> for Oracle.) It does require what I believe Sun calls a cluster but
> (IMHO)
> is a bastardization of the term. It truly is failover, not cluster.
>
> We've had lots of problems with it. It's caused us lots of grief,
> and only
> in a few instances gained us anything. It is NOT OPS, as the
> database does
> not run in parallel, but only on 1 box at a time. (Everything is
> double
> cabled, and so the drives are re-mounted on the 2nd box if a failover
> occurs.) Your users still get disconnected. You'd probably lose
> less data
> than with a standby (since you pick up with the same drives mounted
> on the
> other box), but it depends on how you have the standby implemented.
>
> There's no additional cost from Oracle to run this crap, but you'll
> be
> paying Sun great sums of money. The Sun web site has more info on
> HA.
>
>
> Let me know if you need more info.
> Good luck!
>
> Barb
>
>
> > ----------
> > From: James McCann[SMTP:james_at_openet-telecom.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Thursday, January 17, 2002 5:40 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Standby Instance questions and HA
> >
> > Hi,
> > I was reading in the book "Oracle 24/7 Tips and Techniques" about
> > Standby
> > Instances.
> >
> > Note, this is not a standby database.
> >
> > From the book it seams to work in the following way...
> >
> > There is only one database.
> > The database files exist on a shared disk pack. One machine is the
> primary
> > instance, and if this instance dies, a new instance is started on
> the
> > second
> > machine using the datafiles on the shared disk.
> >
> > The problem is that I can't find anything in the Oracle docs about
> this,
> > or
> > on Meta Link.
> >
> > I also want to know if this method of HA requires a clustered
> environment
> > (I
> > think it does, but just want to be sure)?
> >
> > Also, does it come with an Enterprise Edition license?
> > Or is it something which each hardware vendor implements in their
> own way,
> > at extra cost?
> >
> > We have a requirement for a fail over method on Sun Solaris.
> > We do not want to loose any committed data (i.e. a standby database
> could
> > loose some), and want the fail over to be as automatic as possible.
> >
> > We don't want the expense of Parallel Server (Anyone know how
> expensive it
> > is these days?).
> >
> > The disk pack is RAID, and we may also have a standby database off
> site.
> >
> > Has anyone any recommendations?
> >
> >
> > Thanks,
> >
> > Jim
> >
> >
>
=== message truncated ===
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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).
Received on Fri Jan 18 2002 - 08:31:54 CST
