Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2012
    Posts
    14

    Unanswered: HADR Disconnected on standby

    Hi,

    Please help me to solve this issue. we are using below db2 software:

    DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09075"
    with level identifier "08060107".
    Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23285", and Fix Pack
    "5".
    Product is installed at "/opt/IBM/db2/V9.7".


    Error:2013-09-03-09.25.37.666675-240 E36838A457 LEVEL: Warning
    PID : 8323160 TID : 20268 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000
    EDUID : 20268 EDUNAME: db2logmgr (ABC) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLogFile, probe:4165
    MESSAGE : ADM1847W Failed to retrieve log file "S0006903.LOG" on chain "14" to
    "/pmc_logs/ACTIVE_LOGS/pmcdb02/db2inst1/ABC/NODE0000/".
    2013-09-03-09.25.37.666919-240 I37296A451 LEVEL: Error
    PID : 8323160 TID : 32047 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000
    EDUID : 32047 EDUNAME: db2lfr (ABC) 0
    FUNCTION: DB2 UDB, recovery manager, sqlplfrOpenExtentRetrieve, probe:205
    MESSAGE : Received error from db2logmgr on retrieve:
    DATA #1 : Hexdump, 4 bytes
    0x0A0000001C7FD450 : 870F 0011 ....

    2013-09-03-09.25.38.204256-240 I40097A368 LEVEL: Error
    PID : 8323160 TID : 35131 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000
    EDUID : 35131 EDUNAME: db2hadrs (ABC) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduS, probe:21210
    MESSAGE : HADR: Missing log on primary. Standby shutting down

    2013-09-03-09.25.38.204431-240 I40466A398 LEVEL: Error
    PID : 8323160 TID : 35131 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000
    EDUID : 35131 EDUNAME: db2hadrs (ABC) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduS, probe:21210
    RETCODE : ZRC=0x87800148=-2021654200=HDR_ZRC_BAD_LOG
    "HADR standby found bad log"

    Snapshot from primary:
    HADR Status
    Role = Primary
    State = Disconnected
    Synchronization mode = Nearsync
    Connection status = Disconnected, 09/03/2013 13:32:55.340596
    Peer window end = 08/31/2013 01:12:56.000000 (1377925976)
    Peer window (seconds) = 60
    Heartbeats missed = 0
    Local host = abc1
    Local service = 51011
    Remote host = abc2
    Remote service = 51012
    Remote instance = db2inst1
    timeout(seconds) = 30
    Primary log position(file, page, LSN) = S0006993.LOG, 34, 0000001AF4662E88
    Standby log position(file, page, LSN) = S0006898.LOG, 444, 0000001A97B9C2A6
    Log gap running average(bytes) = 1547207786

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    How do you archive your logs on the primary server?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2012
    Posts
    156
    Explained in the following technote:
    IBM Standby fails with HDR_ZRC_BAD_LOG - United States
    Basically the archived log was probably moved to another location so it can not found and therefore can not be applied. I know lots of people who archive to disk, then move to tape or another media from there for various reasons. I would imagine you are doing something similar. Good luck!

  4. #4
    Join Date
    Aug 2012
    Posts
    14
    Thank you for reply.

    We solve this issue with restore db replace existing option on standby server.

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Tarn View Post
    We solve this issue with restore db replace existing option on standby server.
    That's going to be only temporary, until you run into the same situation again, if azready's and my guesses are correct.. You should have probably looked into your log archiving approach.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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