Re: Oracle 9i Replication to a Remote Site

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 17 May 2005 07:13:21 +0200
Message-ID: <u2vi81hjlp5sr1phuscgp68dnegesu341k@4ax.com>

On 16 May 2005 19:58:06 -0700, "Edwinah63" <edwinah_at_customercare.com.au> wrote:

>Hi Sybrand and Anurag,
>
>thank you both for your replies!
>
>my question now is, if repliction is not intended as a failover, as in
>my example Dataguard seems to be the better choice, what is the main
>purpose of it?
>
>i was asked by the boss to set up replication as a failover device, but
>from your replies, this may not be the case.
>
>are there any other failover methodologies within Oracle 9i apart from
>Dataguard?
>
>regards
>
>Edwinah63

Oracle Parallel Server. (Oracle RAC in later versions). In this option you have 2 servers and 1 set of *shared* disks. As soon as one *server* breaks down, the other server will fully take over. On the client side however, your clients still need to be configured for Transparent Application Failover, as they would also have been done for Dataguard.
The main thing to note is that Parallel Server doesn't protect you against a complete *disk* breakdown.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue May 17 2005 - 00:13:21 CDT