Re: TAF and node failover non RAC oracle 10.2

TAF is not a RAC feature (it is a SQL*Net feature) and does not require RAC. 
TAF can be used with any two databases. Obviously, the schemas need to match 
very closely in order for it to be logically useful, but it can be used with 
non-RAC technologies like replication, for example. At one point, I remember 
seeing some documentation (from Oracle) discussing how to use TAF with 
replication, but I couldn't find it just now with a quick look. 

Obviously, with any HA configuration, the proof is in the extensive testing 
you'll want/need to do in order to ensure that it really does what you want it 
to and provides the level of availability you require. 

Dan

----- Original Message ----
From: hrishy <hrishys@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Wednesday, January 30, 2008 3:19:37 AM
Subject: TAF and node failover non RAC oracle 10.2 


Hi

Can 
TAF 
be 
used 
to 
detect 
node 
failover 
and 
redirect
the 
connections 
to 
a 
new 
node 
using 
retry 
and 
delay 
so
all 
my 
clients 
detect 
that 
host 
db1 
is 
down 
and 
need
to 
start 
connecting 
to 
db2 
.

I 
am 
not 
using 
RAC.Oracle 
version 
is 
10.2



GRID 
=
  
(DESCRIPTION 
=
  
  
(ADDRESS 
= 
(PROTOCOL 
= 
TCP)(HOST 
=
my.db1.com)(PORT 
= 
1521))
  
  
(ADDRESS 
= 
(PROTOCOL 
= 
TCP)(HOST 
=
my.db2.com)(PORT 
= 
1521))
  
  
(LOAD_BALANCE 
= 
yes)
  
  
(CONNECT_DATA 
=
  
  
  
(SERVICE_NAME 
= 
grid)
  
  
  
(FAILOVER_MODE 
=
  
  
  
  
(TYPE 
= 
SELECT)
  
  
  
  
(METHOD 
= 
BASIC)
  
  
  
  
(RETRIES 
= 
1)
  
  
  
  
(DELAY 
= 
1)  
  
  
 
)
  
  
 
)
  
 
)

Other related posts: