Re: Oracle RAC with Active Data Guard : Maximum Availability Architecture
- From: Nassyam Basha <nassyambasha@xxxxxxxxx>
- To: ckaj111 <ckaj111@xxxxxxxx>
- Date: Mon, 23 Dec 2013 20:46:48 +0530
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@xxxxxxxxx>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@xxxxxxxx> 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
Other related posts:
