Was the lecturer a pure lecturer or lecturer/consultant? Academic stuffs sounds very good always but us we live in real worlds and work with real applications. Regards -- LSC On Tue, Nov 25, 2008 at 5:05 PM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote: > I was in a stream class today and the lecturer mentioned just this thing. > Create a second database and create bi-directional streams between the two. > 1) bring the application down for a minute or two. > 2) change the application to access the second server. > 3) bring down the first database. > 4) bring up the application. It will start to put updates in the queues in > the second database. > 5) upgrade the first database. > 6) bring up the first database and wait for the apply process to catch up. > 7) bring down the application for a minute or two. > 8) point the application to the first database. > 9) start up the application. > > Upgrade completed with only a few minutes down time. > > Need EE for streams and works best in 10.2.0.4. > > Adar Yechiel > Rechovot, Israel > > > > Martin Berger wrote: > > Hi Keith, > I have to second Carels and Michaels meanings. Your desire is highly > complex and multi dimensional. So you will not get any straight forward > answer. > > In one of my prior lives I had to promote and support Multi Master > Replication. If someone uses this wise, he can achieve a zero-downtime > environment. > But be warned: You need a tremendous engineering work and still really good > skilled operational DBAs with enough time to take care of. > > I have never checked, wether or not streams can provide the same > functionality. Maybe it's worth checking. > > just some ideas, might they help, > Martin > > > -- > Martin Berger http://berxblog.blogspot.com > > > Hi, I'm working with a customer running a critical web site on a 10gR2RAC > backend > DB - they support hundreds of thousands of simultaneous connections at the > "quietest" time. > > They have expressed a desire for NO downtime during ANY changes to Oracle, > particularly the application of Oracle patches and Oracle upgrades (both > minor and major), etc. > > Any thoughts? Who's "been there done that"? > > > >