Re: Options for wide-area database?

From: DBA Infopower Support <support_at_dbainfopower.com>
Date: Thu, 5 Feb 2004 23:36:29 -0800
Message-ID: <1rKdnWxYdKMN377d4p2dnA@comcast.com>

Hello Ernest,

Consider another approach:

Single site, multi-servers, no-RAC, DR sites using standbys/DataGuard, no multi-master replication

If budget allows use Quest SharePlex to replicate data to DR. ( Streams replication by Oracle can be an alternative application, but it is much more complex and less time in production then shareplex).

This approach is least expensive and least complex (IMHO)

Regards,

  Support
  DBA Infopower LLC
  http://www.dbainfopower.com

"Ernest Siu" <ernestsiu_at_yahoo.com> wrote in message news:2833144d.0402051044.9feed4_at_posting.google.com...
> What are the pros/cons for the following options in implementing a
> wide-area oracle (e.g. 100-1000 miles apart)? In terms of cost,
> performance and data consistency?
>
> 1. Single-site single-server (big!) with remote clients
> 2. Single-site multi-servers using RAC with remote clients
> 3. Single-site server(s) (option 1 or 2) with advanced replication
> onto remote hosts
> 4. Multi-site servers with RAC and wide-area SAN
>
> Any comment/suggestion?
> Ernest
Received on Fri Feb 06 2004 - 01:36:29 CST