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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle in active-active redundant data centers?

Re: Oracle in active-active redundant data centers?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 19 Sep 2006 16:35:08 -0700
Message-ID: <1158708906.632009@bubbleator.drizzle.com>


amigan wrote:
> Is it possible to have two active data centers each receiving database
> updates via web site and application at each respective site? Somehow
> for the two active data centers to replicate in the complimentary
> direction and survive the outage of one of the active data centers and
> retain data integrity? Thanks.

You can use DataGuard or Streams or Change Data Capture (CDC) to replicate between databases. You can build failover clusters with application servers. But your web application can and should talk to only one database instance. Let the database replicate itself for high-availability.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Tue Sep 19 2006 - 18:35:08 CDT

Original text of this message

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