Re: non-rolling upgrades

  • From: John Smiley <jrsmiley@xxxxxxxxx>
  • To: paul.baumgartel@xxxxxxxxx
  • Date: Thu, 23 Jun 2005 10:54:37 -0600

Rolling Upgrades Using Oracle Data Guard SQL Apply 

If you use logical standby databases, you can use Oracle Data Guard SQL 
Apply to perform rolling upgrades to upgrade Oracle Database 10*g* release 1 
(10.1.0.3 <http://10.1.0.3>) to release 1 (10.1.0.4 <http://10.1.0.4>). 
During a rolling upgrade, you can run different releases of the Oracle 
software on the primary and logical standby databases while you upgrade them 
one at a time. If you do this, you will incur minimal downtime on the 
primary database.For information and instructions on rolling upgrades with 
logical standby databases, review document 300479.1, available on the Oracle
*MetaLink* Web site: 


On 6/23/05, John Smiley <jrsmiley@xxxxxxxxx> wrote: 
> 
> Logical only. 
> 
> On 6/23/05, Paul Baumgartel <paul.baumgartel@xxxxxxxxx> wrote: 
> > 
> > Mladen,
> > 
> > Can you clarify this? Are you talking about a logical standby or
> > physical standby?
> > 
> > Thanks.
> > 
> > 
> > --
> > Paul Baumgartel
> > paul.baumgartel@xxxxxxxxxxxx
> > 
> > 
> > On 6/22/05, Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx > wrote:
> > 
> > >
> > > John, rolling upgrades are a legend. I work with RAC, I used to work
> > > with OPS and I've never
> > > seen that done. Allegedly, it has only been done in the land of El
> > > Dorado. It's easier to find WMD 
> > > in Iraq then someone who has really done a rolling upgrade. The best 
> > you
> > > can do is to switch over
> > > to standby, upgrade the primary database, then upgrade the standby and
> > > rebuild the standby. 
> > >
> > > --
> > > Mladen Gogala
> > > Oracle DBA
> > > Ext. 121
> > >
> > >
> > > --
> > > //www.freelists.org/webpage/oracle-l
> > >
> > --
> > //www.freelists.org/webpage/oracle-l
> > 
> 
>

Other related posts: