Re: Any-one know how to eliminate PLANNED downtime with Oracle RAC?
Date: Tue, 25 Nov 2008 10:43:57 +1100
Heh! Funny enough: when RAC first came out, I asked Oracle marketing if it would allow me to upgrade one node while keeping the other(s) operational. The reply was: "Yes of course!". Anyone managed to do that yet? No? Nuff said...
You may be spending big for this type of availability. When I was working for the SEM folks, we had this same situation with Google's traffic coming into our servers. We ended up writing extensions to Apache to capture the data we needed into a flat file that kept being rotated, with quite a few RHLinux Apache servers attached to load balancers, all pumping data to these files. The files got collected into a ETL process into our database, which then through an elaborate process provided changes back to the config of the Apache servers as to how to handle the traffic. Whenever a new config was ready, we just sent a signal to the Apache server and the custom code would read it and apply the changes.
Zero downtime front end because of the load balancers, db downtime was acceptable provided we stayed within the window for the feedback loop - around one day. So much so that we didn't even have to use EE, just Standard Edition was enough.
More than one way to skin a cat. I suggest you look at this type of approach rather than "nothing will ever be down". That last one costs a LOT of moolah...
-- Cheers Nuno Souto in sunny Sydney, Australia dbvision_at_iinet.net.au Fahrenfort, Keith (HP Shared Solutions Architect for Oracle) wrote,on my timestamp of 25/11/2008 3:25 AM:Received on Mon Nov 24 2008 - 17:43:57 CST
> Hi, I'm working with a customer running a critical web site on a 10gR2
> RAC backend DB - they support hundreds of thousands of simultaneous
> connections at the "quietest" time.
> They have expressed a desire for NO downtime during ANY changes to
> Oracle, particularly the application of Oracle patches and Oracle
> upgrades (both minor and major), etc.
> Any thoughts? Who's "been there done that"?