Re: Oracle 10 Failover

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 10 Sep 2008 07:35:38 -0700
Message-ID: <1221057338.261465@bubbleator.drizzle.com>


Chris Seidel wrote:
> Hi,
>
> we are planning to configure a snapshot replication to a second database
> server to increase the availability of our application.
>
> We have odbc clients which use the oracle odbc driver with Oracle Net and we
> have jdbc clients which uses the oracle thin driver.
>
> As far as I know it is possible to configure TAF with Oracle Net
> (tnsnames.ora). Transparency is on select level only. DML ist lost.
> Right?
>
> And as far as I know this is not possible with the jdbc thin driver. This
> supports only FCF - thus the client has to call getConnection() again to
> connect to the backup server.
> Thus all work gets lost.
> Right?
>
> Altenatives would be:
>
> OS-Cluster with shared storage
> RAC
>
> Right?
>
> Thank you.

If you have 10g then snapshot replication is old technology that I would highly recommend you not use. Look into using Streams or Change Data Capture.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Sep 10 2008 - 09:35:38 CDT

Original text of this message