Re: Oracle 10 Failover

From: DA Morgan <>
Date: Wed, 10 Sep 2008 07:35:38 -0700
Message-ID: <>

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
> 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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Sep 10 2008 - 09:35:38 CDT

Original text of this message