DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: failsafe application.

  1. #1
    Join Date
    Apr 2001
    Posts
    126

    Thumbs up failsafe application.

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    RAC
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by adewri
    RAC
    I think Oracle Data Guard.
    RAC for load balancing. Oracle DataGuard for Availablity.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: failsafe application.

    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.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: Re: failsafe application.

    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.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width