Re: Applying CPU to RAC with physical standby

At least I would stronly encourage not to have the standby database
receiving and/or applying logs whilst the primary is upgraded. Oracle
docs suggest to do this.

However, what if the upgrade fails? Then you have two databases upgraded
halfway. 
I never understood why Oracle wants this approach in a HA environment.

If you stop the standby during the upgrade (or have it open read-only,
as Jason suggested) you can easily activate the standby when the upgrade
of the primary fails for whatever reason.


Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok)
===

On Wed, 2008-05-28 at 10:46 +0100, S. Anthony Sequeira wrote:

> On Wed, 2008-05-28 at 10:58 +0200, Carel-Jan Engel wrote:
> > Are you trying to ask whether a rolling upgrade is possible?
> > 
> > If so, the answer is NO.
> > Despite attempts from Oracle to redefine the meaning of 'rolling
> > upgrade', update a system without any downtime for the application is
> > not possible.
> 
> Hi Carel-Jan,
> 
> No I'm asking whether it's possible to apply the patch with at least one
> node servicing the database, as I did for the pre-production database,
> with a short downtime for the recompile views post-installation step.
> Unfortunately this doesn't seem possible with a standby database
> involved.
> 
> Regards.
> -- 
> S. Anthony Sequeira
> ++
> Why be a man when you can be a success?
>               -- Bertolt Brecht
> ++
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
>

Other related posts: