This is a project being managed by outside consultants. Their original request was to have two servers each with databases installed. One of these servers was to be shut down sitting next to the primary server. If one failed, fire up the second server, switch the network connection and start the database. Somehow, this did not quite seem right!
We finally agreed to try replication. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Peter - Since nobody seems to be answering your > question, I guess you get > the second tier here. I have not used Oracle > Replication, but I have studied > it some. The first thing I seem to always hear about > Oracle's Replication is > that you must be careful or it won't be able to keep > up. The other thing > they point out is that the application must be > designed for replication, but > I'm not sure this applies in the failover > application you describe. But it > could get messy since you must configure replication > on each of your tables. > I know that the Replication advocates mention how it > can be used for a > standby database, and if you had an offsite disaster > recovery site, I would > say Replication would be worth a look. > What you are proposing sounds a lot like Oracle9i's > new Real > Application Clusters (RAC), or Oracle's Standby > database. Another idea if > you insist on replication would be to look at > Quest's SharePlex. > In the worst case, maybe my reply will encourage > someone with > replication experience to reply. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Thursday, February 14, 2002 5:04 PM > To: Multiple recipients of list ORACLE-L > > > We are looking at Advanced Replication as a fail > over > option for a web site. Straight forward > installation, > both boxes on the same subnet on their own dmz. The > servers will be located on the same rack in the > computer room. Very few tables storing data from an > application that is tracking click through data. > > Does anyone see any flaws with the basic plan? Any > hidden 'features' that we may run into? > > Thanks > > > > ===== > Pete Barnett > Lead Database Administrator > The Regence Group > [EMAIL PROTECTED] > > __________________________________________________ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Peter Barnett > 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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > 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). ===== Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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).
