On Fri, 2 Jan 2004 21:50:19 +0100, Daniel Morgan wrote
(in message <1073076532.451282_at_yasure>):
> Jim Dwyer wrote:
>
>> Is it possible to run use TAF for SELECT failover with just two
>> separate oracle databases which are not part of OPS or RAC cluster?
>>
>> My application is read-only so I do not need clustering or shared
>> disk. I just want the select statements to be re-executed on the
>> stand-by oracle instance when the first one fails. The databases are
>> on different machines with different disks but they contain the same
>> data.
>>
>> Is this possible? How would I configure TAF SELECT failover without
>> RAC or OPS?
>>
>> Thanks,
>>
>> - Jim
>
> My understanding is that you can not.
In the manual you can find an entry that states: your select might return an
error if the table does not exist in the alternate database.
You can TAF to a normal standby database, as long as it's open for atleast
read access. more important is, can your application handle TAF ? The T is
for transparent but that's for the query, not for the application.
--
With kind regards,
Ronald
http://ronr.nl/unix-dba
Received on Fri Jan 02 2004 - 15:23:59 CST
