Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Update schema while new data is coming in

Re: Update schema while new data is coming in

From: Don Seiler <don_at_seiler.us>
Date: Mon, 12 Nov 2007 10:00:52 -0600
Message-ID: <716f7a630711120800w6e613f64o9c6b616717c79547@mail.gmail.com>


I haven't personally had the pleasure of playing with this, but isn't this exactly the kind of thing that is used in RAC success testimonials? Being able to perform updates on one member of the cluster at a time while the others handle the application traffic?

Don.

On Nov 12, 2007 3:47 AM, <Antje.Stejskal_at_ppimedia.de> wrote:
> Hi,
>
> we are having a web application that ist o be online availyble 7x24. We plan
> for the scenario that the application needs a software update (new tables ,
> modified tables et. al.) Management and customer requires that the
> application is still running while the upgrade goes on. How would you solve
> this, that you have one server with the old schema where new data is coming
> in, meanwhile another server is brought up to latest release. And data of
> the old server (or delta of data) will be send to new server. We will
> propably have 2 servers anyway because of the traffic.
> Please help me with your ideas.
>
> Regards
> Antje Stejskal
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 12 2007 - 10:00:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US