Re: HA options
Date: Mon, 5 Aug 2013 15:21:28 -0500
Message-ID: <CAAKoEZ99jZNXM52jXBibDGMw4SWuVKW4Gwg0KHUOFWTgeY9duw_at_mail.gmail.com>
Thanks everyone for the responses.
The patching team wants several hours downtime for patching and the business side does not like that many hours and are looking for minimizing downtime as much as possible. Going forward I have to look at alternate solutions. RAC is one option, but it is pricier (when we present the $ involved with higher price options, they usually back down). Plus, as Nuno pointed out, applying patches for storage could be an issue with RAC. But still with RAC, the application will be available during OS patching etc - not as much downtime.
We are in the process of setting up dataguard and I am learning the finer details of it. I was thinking that with dataguard, there will be lesser downtime than keeping the DB totally shutdown. They may not like the fact there will be 2 downtimes during switchover, so i am trying to find out if there is a 'seamless switchover' in 11g somewhere that I am not aware of.
I know about replication, RAC, etc (some of our DBs are RACed), but we are looking to see how far we can go with DG.
On Mon, Aug 5, 2013 at 1:30 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:
>
> In framing your expectations, are you talking about requiring a small
> number
> of seconds or a small number minutes? Are you routinely already running
> dataguard or some flavor of physical backup continuous recovery? Do you
> already routinely switch over and switch back so that you know all the
> software pieces you need are in place and whatever web to application to
> database routing you have in place works seamlessly?
>
> The key is to keep things like this as boring and simple as possible. Truly
> zero downtime is neither.
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 05 2013 - 22:21:28 CEST