Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146

    Unanswered: Implementing Oracle StandBy Database - Suggestion & Tips needed Pls.

    Dear Sir,
    With rerefence to high availability of our database, we would like to implement a standby database. Regarding this, i have few doubts and request all you expert to pls. help me out. This goes like this:
    1. What is DataGuard.? Is it Separate product in Oracle or Part of Oracle Database Server - Enterprise Edition.?
    2. Is standby database implemented / created ONLY using DataGaurd?
    3. Do we need to buy another license for Oracle Database when i go for implementing StandBy Database.?

    Basically we want if my main production server is down, it should automatically go to my StandBy database and does not stop my application. This is possible i feel by implementing Standby database. And we are thingking to do it. In that respect, we have above query.

    I would request if somebody could be guide us and help.

    Thanks.

    Regards,
    Kamesh Rastogi
    - KR

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    1. see this.
    2. Standby databases existed before DataGuard, but DataGuard is like a standby database but on esteroids (like, you now have a GUI -OEM-, different modes, and so on). It is more 'easy' now. You have dedicated processes to monitor it and so on.
    3. I really dont know, you will have to contact oracle for that. However, I would expect that depending on the mode you choose to put your standby's on (for example, you could have your standby read-only for reporting services, etc.) will determine whether you need additional licenses.

    Based on what you said, it is possible for you to evaluate RAC as well.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    the standby will not AUTOmagically become the primary if your primary
    database goes down. You would have to write a script to do this or manually
    promote the standby.

    read up on how to promote a standby. there are many things to consider
    regarding physical or logical as well as how archivelogs are applied. Pay
    specific attention to what you need to do if you lose your primary, have no redo logs,
    and need to start the standby. In many setups, if you don't have
    the redo-logs available from the primary then you cannot start the standby or
    you will lose data, etc. You might want to implement standby redo-logs, etc.

    testing every scenario and documenting the steps is always the best answer.
    This way you understand the limitations of your failover scenarios.

    BTW - wanting the stnadby to start AUTOMATICALLY can cause problems.
    Consider what the catalyst would be to start the standby as a primary. What
    if there is a false alarm and the standby becomes the primary? Then you are
    screwed royally and now have TWO primaries.

    If you want any kind of AUTOMATIC failover then go RAC instead.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146
    Hi Guys,
    Thanks a lot for your nice tips and really useful suggestion. yes.! I will take care them and do the simulation in our scenario before puttig it into simulation. Thanks.

    Regards,
    Kamesh Rastogi
    - KR

Posting Permissions

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