Re: Oracle RAC with Active Data Guard : Maximum Availability Architecture

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Mon, 23 Dec 2013 20:46:48 +0530
Message-ID: <CAABGLuKd+GJvXkSpGAjY5K7YBCuRKAc7Y+BZ1vzS2TNVEN=uLg_at_mail.gmail.com>

By the way, I forgot to ask.. are you looking for high availability(no downtime) from both primary and standby when ADG enabled? - Nassyam Basha.

On Mon, Dec 23, 2013 at 8:43 PM, Nassyam Basha <nassyambasha_at_gmail.com>wrote:

> Hi Chris,
>
> Usually when patching on DataGuard environment, Standby will be down and
> patch will be applied(No post scripts will be updated), Next we jump to
> primary database and here its RAC so we can opt for rolling patching. in
> rolling patch there is no downtime at all. And each node will be patched
> and brought up while other node(s) are still running after all patching is
> done we do run post scripts..hence patching will be completed on primary..
> So we can avoid downtime on Primary.
>
> So far we initially already patched on standby and also primary, When
> patches are applied on whole environmnet, when we start MRP of course
> dictionary will be updated whenever the archives/redo applied on standby
> database(s). So still we can avoid downtime.
>
> If you are planning for master patching, from 11g release to release (or)
> patch set upgrade, Then you might consider rolling upgrade patching. You
> can refer
> http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-upgrades-made-easy-131972.pdf
>
> In short i can say not complex, If properly planned :)
> Correct me if missing or something wrong.
>
> Thanks,
> Nassyam Basha.
> www.oracle-ckpt.com
>
>
> On Mon, Dec 23, 2013 at 8:07 PM, Chris King <ckaj111_at_yahoo.ca> wrote:
>
>> We're architecting a new system, and will need 99.5% availability.
>> Looking over Oracle's MAA options, I see RAC with Data Guard. .. but it's
>> not clear to me how this would actually work to avoid ALL downtime. Won't I
>> still need downtime to apply patches, even if I use rolling patches? And
>> isn't it more complex applying patches when there's a standby involved?
>>
>> Is 99.5% really achievable with this combination?
>>
>> Thanks in advance..
>>
>
>
>
> --
> Thanks & Regards,
> Nassyam Basha.
> www.oracle-ckpt.com
>

-- 
Thanks & Regards,
Nassyam Basha.
www.oracle-ckpt.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 23 2013 - 16:16:48 CET