Re: Any-one know how to eliminate PLANNED downtime with Oracle RAC?

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Thu, 27 Nov 2008 13:50:43 +0200

He is one of the most respected guys in the Israel oracle community.

Adar Yechiel
Rechovot, Israel



LS Cheng wrote:
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 <mailto: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 <http://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
    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"?


Other related posts: