TAF failover across primary->Standby DB?

From: Frank Foss <fozzie_beer_at_hotmail.com>
Date: Tue, 10 Jun 2003 16:37:32 -0700
Message-ID: <bc5q3c$flg0f$1@ID-190416.news.dfncis.de>

This message received no response in C.D.O.S, so I'm risking it again on CDOM
I guess most regulars read both groups, so my apologies in advance...:

My company is implementing a system running Oracle RAC 9.0.1.4, on Compaq Tru64 UNIX.
There will be 2 sites, each running an active/passive RAC cluster. The clusters are already up and running fine. We are now starting to do the standby database thing, with managed recovery and all that good stuff.

My questions pertains to the client configuration and TAF in this setup: This is the tnsnames entry on one site:

PROD_DB =

     (DESCRIPTION=


       (LOAD_BALANCE=OFF)

       (FAILOVER=ON)

       (ADDRESS_LIST=

          (ADDRESS = (PROTOCOL = TCP)(HOST = SERVERA)(PORT = 1521)) #
Primary site
          (ADDRESS = (PROTOCOL = TCP)(HOST = SERVERB)(PORT = 1521)) #
Primary site
       )


       (CONNECT_DATA=

         (SERVICE_NAME=prod_db
         (SERVER=DEDICATED)
         (INSTANCE_ROLE=PRIMARY)
         (FAILOVER_MODE = (TYPE=SESSION)(METHOD=BASIC))
       )
     )

The standby site have an identical cluster in place. Is it possible to add ADDRESS pointers to the SERVERC and SERVERD, under the same tnsnames section, pointing to the standby site, and have the client "automatically" connect to the standby cluster thru the TAF mechanisms? (After a manual or automatic role switchover)

Will the following tnsnames entry work:

PROD_DB =

     (DESCRIPTION=


       (LOAD_BALANCE=OFF)

       (FAILOVER=ON)

       (ADDRESS_LIST=

          (ADDRESS = (PROTOCOL = TCP)(HOST = SERVERA)(PORT = 1521)) #
Primary site
          (ADDRESS = (PROTOCOL = TCP)(HOST = SERVERB)(PORT = 1521)) #
Primary site
          (ADDRESS = (PROTOCOL = TCP)(HOST = SERVERC)(PORT = 1521)) #
Standby site
          (ADDRESS = (PROTOCOL = TCP)(HOST = SERVERD)(PORT = 1521)) #
Standby site
       )


       (CONNECT_DATA=

         (SERVICE_NAME=prod_db
         (SERVER=DEDICATED)
         (INSTANCE_ROLE=PRIMARY)
         (FAILOVER_MODE = (TYPE=SESSION)(METHOD=BASIC))
       )
     )

Will this client be able to seamlessly connect to server C after a switchover?

I do not have a test setup to do this, and I am sending this question to the group to see if this is something I could test on the to-be-production-setup.

Thanks in advance,
Foz Received on Tue Jun 10 2003 - 18:37:32 CDT