failsafe application.

[fordikon]

We have a software product which connects to oracle database, and it is a critical application. i would like to make a failsafe Database where if one DB server crashes it should automatically change over to the other database server without the need of notifying the CLIENT application and without any changes in client application

what is the best way of handling this sutuation.

[adewri]

RAC

[stmontgo]

your application needs to be taf aware to perform this task. You need to code your application to peform this function, no way around it.

You can implement things like select failover but in terms of dml
, calling stored procs etc oracle will not perform this task

steve

[SANJAY_G]

Originally posted by adewri
RAC

I think Oracle Data Guard.
RAC for load balancing. Oracle DataGuard for Availablity.

[adewri]

Originally posted by fordikon
i would like to make a failsafe Database where if one DB server crashes it should automatically change over to the other database server without the need of notifying the CLIENT application and without any changes in client application

Sanjay, is that possible with Dataguard ? The part "automatically change over to the other database server without the need of notifying the CLIENT application" i.e. without interrupting any on going DML.

[SANJAY_G]

Originally posted by adewri
Sanjay, is that possible with Dataguard ? The part "automatically change over to the other database server without the need of notifying the CLIENT application" i.e. without interrupting any on going DML.

Except "automatically". The role transition must be done manually.

[adewri]

So in that case i would say RAC is best for TAF (Transparent Application Failover), any way its upto fordikon to decide what he wants...