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