failover backup server

[yxez]

Hi friends,

We have a client/sever apps using VB and oracle10g as back-end db.
We have two db servers 1 for prod and 1 for backup. with identical specs and contents(windows 2003). The following are the detailed info for each.

DB Server1
-----------
Machine name: PROD1
IP Address: 192.100.0.1
DB/Service Name: ORCL
Port : 1521

DB Server2
-----------
Machine name: PROD2
IP Address: 192.100.0.2
DB/Service Name: ORCL
Port : 1521

How do I configure our set-up so that when Prod1 db server is down it will switch over to Prod2 without editing our apps odbc cleints config?

Thanks a lot

[LKBrwn_DBA]

Configure server2 DB as standby database.

[yxez]

Thanks dear,

Can I open the standby database to do some inquiry processing (read only)
so that the machine wont be idle all the time?

[davey23uk]

yes

[yxez]

My problem here is that our db has an image table which is quite big.
I am backing it up separately coz its not really as important as the text data.
Can I opt not to include it on the standby db?

Thanks

[davey23uk]

and what kind of standby do you have

[yxez]

im thinking of a hybrid standby backup selecting only the few critical
tables. the others can be set to zero like the image.

by the way if my prod ip is 192.100.0.1 and my standy ip is 192.100.0.2
and when my prod gets down will I change my standby ip to 192.100.0.1?
coz the clients programs is pointing to this prod ip.


Thanks

[knitty]

hi
u have to configure your tnsnames.ora file setup for using transparent application failover.(runtime failover)
check with this
ORCL =
(DESCRIPTION=
(FAILOVER=ON)
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=PROD1)(PORT=portno)
(ADDRESS=(PROTOCOL=TCP)(HOST=PROD2)(PORT=portno)
)
(CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=shared or dedicated)
(FAILOVER_MODE=(TYPE=select)(METHOD=basic))
)
)

[knitty]

i m sorry..use ur servicename..

[yxez]

thanks dear....does it affect the ODBC connect when it uses connection like
scott/tiger@192.100.0.1:1521/orcl or does it still pass on the tnsnames.ora?