Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2009
    Posts
    66

    Unanswered: change hadr_timeout

    9.5.10 running on Linux

    I need to change hadr_timeout parm on primary & standby. Is it enough to deactivate the database or i need to stop/start hadr?

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    You have to deactivate both databases.

    1. 'update db cfg' on both standby and primary
    2. 'deactivate db mydb' on standby
    3. 'deactivate db mydb' on primary and force all user connections off
    4. 'activate db mydb' on standby
    5. 'activate db mydb' on primary
    Regards,
    Mark.

  3. #3
    Join Date
    Sep 2009
    Posts
    66
    Do I deactivate primary first or standby first or the order doesn't matter?

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    must be the same on both servers
    I presume stop-start hadr is needed
    this does not harm you implementation : just stop on both nodes - change param -start hadr
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Sep 2009
    Posts
    66
    I'm not clear. Do I just need to deactivate the database on primary/standby or do I have to stop/start hadr?

  6. #6
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    The deactivation order doesn't matter.
    Regards,
    Mark.

Posting Permissions

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