Failover Technology- Clustering
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Failover Technology- Clustering

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    hi!
    We are thinking of solution for fialover database. We need to decide technology.

    Does any body share there experience (pros and cron) with

    Veritas Clustering
    Oracle Parrallel server
    Automatic standby database.

    Thinking of OPS but do not know it is worth and liable or not.
    Veritas no idea baout it.

    ANY help appriciated.


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if it's fail over use veritas or standby db

  3. #3
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    If it is veritas does it require to install oracle parallel server.
    which one is more better veritas or standby

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Your desisions depend from couple of factors:
    - how long time you have for rectore database
    - how many boxes you have
    - what type of disk equepment you have and may you
    create shared disk array or not
    - ...

    If time for restore DB less than 1 min you haven't any desicions exept OPS (or ORC).

    If time for restore DB less than 1 h then you can use standby database
    But should be ready, that you may lost last transactions.

    If time for restore DB more than 1 day you can use veritas volume manager, because if you lost 1 box VVM doesn't help you.






  5. #5
    Join Date
    Apr 2001
    Posts
    219
    Is Oracle transparent failover option a valid option?
    ______________________
    Applications come and go,
    but the data remains!

  6. #6
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    Thanks guys
    Harware is to be decided based upon selection of filover.
    This are basic factor for selection
    1. one is better and easy to maintain
    2 less amount of loss of transaction.
    3. Reliable

    It is 24/7 database.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    You want Oracle failover or OS failover?

    Oracle failover there is Oracle Parallel Failsafe, it works like OS failover, OS failover usually takes a while to startup the database whereas Parallel failsafe is much faster

    Forget OPS because it's hard to maintainm and because the application has to adapt to OPS not the other way round

  8. #8
    Join Date
    Oct 2001
    Location
    Buffalo, NY
    Posts
    46
    Here's my 2 cents worth: if purely from a DB failover, auto standby is good - just remember, you may not get ALL the data over (online redos), but it'll be a quick switchover and config/maintenance is much better now in 8i. Haven't used Oracle Parallel Failover. If from OS, we use Veritas Cluster Server, which is reliable. Also there is SUN Clustering on SUN servers and HP ServiceGuard for HP-UNIX servers that are excellent for OS failover.
    Tim Hussar

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