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 10gR2 RAC 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"?