failover backup server

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

Configure server2 DB as standby database.;)

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? ;)

yes

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

and what kind of standby do you have

im thinking of a hybrid standby backup:o 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

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))
)
)

i m sorry..use ur servicename..

thanks dear....does it affect the ODBC connect when it uses connection like
scott/[email protected]:1521/orcl or does it still pass on the tnsnames.ora?

ODBC connections like that won't automatically fail over. You'd probably need to set up a virtual ip address that automatically moves to the standby database to account for that.

That's correct but, you have opened Pandora's box... Jenn is gonna come back with a zillion random questions. Brace for impact!

:D your funny dear....after all this forum is made for questions and answers:p

Quote:

---

Originally Posted by yxez

:D your funny dear....after all this forum is made for questions and answers:p

---

it is, but you are the wirst kinda of person who posts here, one who doesnt even bother to think for themselves.

if you carry on with that, you may well find yourself unable to post here.

Stop trolling

Hi

Does anybody have a idea on how to do this

Code:

---

probably need to set up a virtual ip address
that automatically moves to the standby
database to account for

---

probably microsoft cluster + Oracle Failsafe with Windows or CRS Cold Failover Cluster with UNIX or Linux

I have experience with the second option but not first

let your Systems Engineer/Administrator worries those concerns. They could opt to use SIP /Service I.P. where I.P. can be attach/detached between servers.

Hi reydp

Thank you very much i appreciate.

regards
Hrsihy