Re: Oracle upgrade without downtime??

  • From: Andreas Piesk <a.piesk@xxxxxxx>
  • To: nupendra@xxxxxxxxxxx
  • Date: Tue, 31 Aug 2010 22:21:14 +0200

Upendra N schrieb:
> For the database upgrades Oracle seems to be recommending Logical
> standby database (SQL Apply).
> There are a lot of restrictions with Logical standby. Will it work with
> Physical standby?

no, it won't work with physical standby.

how much downtime you're willing to accept, 5min, 10min, 20min?

did you test how long a upgrade of your database actually take?

if the time taken by the upgrade really exceeds your limit, you should take a 
look at transportable
tablespaces. using this you can upgrade large databases within 1-5 minutes, 
depending on the number
of tablespaces you have.

another way, for small amounts (some tens of GB) of data, is replication using 
materialized views.
very easy to setup and works very well. depending on the amount of activity in 
the database you can
switch within 1 minute.


Other related posts: