Failover across databases

Hi Guys,

Does anyone have failover setup acorss the databases (also across instances in teh same database)? Like to get experts opinion here. What is the best practice?

Any help would be really appreciated

Following is the requirement:

1. By default, a client should always connect to the Primary 3-Instance Oracle9iR2 RAC Cluster
   (Service-name: MYDB.US.MYCOMPANY.COM).
   
2. Only in case of the Primary DB cluster failure, the client should connect to the Secondary 3-Instance Oracle9iR2 RAC Cluster
   (Service-name: MYDB.US.MYCOMPANY.COM)
   
3. client should connect to surviving nodes when an Instance within the DB cluster fails
4. client(s) should be load-balanced between 3 Instances of the DB cluster.

Enclosed is my TNS entry:

MYDB=
(DESCRIPTION_LIST
(DESCRIPTION=
(FAILOVER=ON)
(LOAD_BALANCE=ON)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=SITE01_01)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=SITE01_02)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=SITE01_03)(PORT=1521)))
(CONNECT_DATA=
(SERVICE_NAME=MYDB.US.MYCOMPANY.COM)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))))
(DESCRIPTION=
(FAILOVER=ON)
(LOAD_BALANCE=ON)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=SITE02_01)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=SITE02_02)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=SITE02_03)(PORT=1521)))
(CONNECT_DATA=
(SERVICE_NAME=MYDB.US.MYCOMPANY.COM)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))))
)

--
Sami Seerangan
Oracle DBA
--
http://www.freelists.org/webpage/oracle-l