Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2017
    Posts
    2
    Provided Answers: 1

    Answered: What Happened If Primary DB in HADR Broken?

    Hello, I'm a newbie at DB2 and I'm learning HADR right now.

    I want to ask if the Primary DB failed/crash, what will happen to standby?

    Will it also crash?

    If not, is there any way to restore from standby back into primary?

    I'm sorry if this is a dumb question.. I'm just a newbie

  2. Best Answer
    Posted by ReachYourDream

    "I think the answer is Failover... Sorry"


  3. #2
    Join Date
    Jun 2017
    Posts
    2
    Provided Answers: 1
    I think the answer is Failover... Sorry

  4. #3
    Join Date
    Jun 2017
    Posts
    9
    Provided Answers: 1
    The whole point of hadr is to have a standby if the main server fails or the computer room blows up etc.

  5. #4
    Join Date
    Oct 2007
    Posts
    162
    Provided Answers: 9
    If you're reading up on HADR, there are instructions on how to switch over to the standby. There are, also, instructions on how to take over by force, in the event your primary is unresponsive. I would suggest reading up more on those topics. Take time understanding the different phases of in synch, near synch, etc...

Tags for this Thread

Posting Permissions

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