RE: Oracle upgrade without downtime??

I found the documents under this link:
http://www.oracle.com/technetwork/database/features/availability/oracle-database-maa-best-practices-155386.html

I'm planning to test Logical Standby and Transportable tablespaces. 
Thanks much for everyone who responded.

-Upendra



From: nupendra@xxxxxxxxxxx
To: a.piesk@xxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle upgrade without downtime??
Date: Wed, 1 Sep 2010 00:27:39 -0400








Thanks for your suggestions.

15-20 mins downtime is acceptable.

I couldn't find any whitepapers on transportable tablespace for upgrade. 
There was one in OTN, however the link is broken or the document is taken off 
the site...

-Upendra



> Date: Tue, 31 Aug 2010 22:21:14 +0200
> From: a.piesk@xxxxxxx
> To: nupendra@xxxxxxxxxxx
> CC: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Oracle upgrade without downtime??
> 
> 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.
> 
> regards,
> -ap

Other related posts: