Re: Oracle 10 Failover
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.orgReceived on Wed Sep 10 2008 - 09:35:38 CDT