Ah but with 9i, RAC and TAF you can have the users reconnected automagically and they will resume their transactions inflight.
--- Kimberly Smith <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
