No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

Huawei SAP HANA Appliance HA and DR Scheme Restore Guide 03

Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Restore Procedure

Restore Procedure

  1. Run the hdbnsutil -sr_state command on DCN03 to check the SR status.

    hs4adm@DCN03:/usr/sap/HS4/HDB90> hdbnsutil -sr_state
    checking for active or inactive nameserver ...
    
    System Replication State
    ~~~~~~~~~~~~~~~~~~~~~~~~
    
    mode: primary
    site id: 3
    site name: DCN03
    
    Host Mappings:
    ~~~~~~~~~~~~~~
    
    dcn03 -> [DCN03] dcn03
    
    
    done.
    hs4adm@DCN03:/usr/sap/HS4/HDB90>

  2. If the OS is RHEL, run the pcs property set maintenance-mode=true command to enter the maintenance mode. If the OS is SLES, run the crm configure property maintenance-mode=true command.
  3. Run the crm_mon command on DCN01 to check whether all resources have been stopped.

    [root@DCN01 hdbclient]# crm_mon
    Cluster name: hacluster
    Last updated: Sat Feb 27 10:43:26 2016
    Last change: Sat Feb 27 10:43:13 2016
    Stack: cman
    Current DC: DCN01 - partition with quorum
    Version: 1.1.11-97629de
    2 Nodes configured
    7 Resources configured
    
    
    Node DCN01: standby
    Node DCN02: standby
    
    Full list of resources:
    
    st_ipmi_dcn01  (stonith:fence_ipmilan):        Stopped
    st_ipmi_dcn02  (stonith:fence_ipmilan):        Stopped
    rsc_ip_SAPHana_HS4_HDB00       (ocf::heartbeat:IPaddr2):       Stopped
    Clone Set: rsc_SAPHanaTopology_HS4_HDB00-clone [rsc_SAPHanaTopology_HS4_HDB00]
    Stopped: [ DCN01 DCN02 ]
    Master/Slave Set: msl_rsc_SAPHana_HS4_HDB00 [rsc_SAPHana_HS4_HDB00]
    Stopped: [ DCN01 DCN02 ]

  4. Run the HDB start command on DCN02 to start the database.
  5. Run the hdbnsutil -sr_unregister --name=DCN03 command on DCN02 to unregister it from DCN03.
  6. Run the hdbnsutil -sr_state command on DCN02 to check the SR status.

    hs4adm@DCN02:/usr/sap/HS4/HDB90> hdbnsutil -sr_state
    checking for active or inactive nameserver ...
    
    System Replication State
    ~~~~~~~~~~~~~~~~~~~~~~~~
    
    mode: primary
    site id: 1
    site name: DCN02
    
    Host Mappings:
    ~~~~~~~~~~~~~~
    
    dcn02 -> [DCN02] dcn02
    
    
    done.
    hs4adm@DCN02:/usr/sap/HS4/HDB90>

  7. Run the HDB stop command on DCN02 to stop the database.
  8. Run the hdbnsutil -sr_register --remoteHost=DCN03 --remoteInstance=90 --mode=async --name=DCN02 command on DCN02 to register it with DCN03.

    hs4adm@DCN02:/usr/sap/HS4/HDB90> hdbnsutil -sr_register --remoteHost=DCN03  --remoteInstance=90 --mode=async  --name=DCN02
    adding site ...
    WARNING: Deprecated option --mode. Please use --replicationMode instead.
    --operationMode not set; using default from global.ini/[system_replication]/operation_mode: delta_datashipping
    checking for inactive nameserver ...
    nameserver dcn02:39001 not responding.
    collecting information ...
    updating local ini files ...
    done.

  9. Run the HDB start command on DCN02 to start the database.
  10. Log in to the database on DCN03 using the HANA studio.

  11. Check the database synchronization status. If the value of Replication_status is ACTIVE, data synchronization has finished.

  12. Run the hdbnsutil -sr_takeover command on DCN02 for it to take over services.
  13. Run the hdbnsutil -sr_state command on DCN02 to check the SR status.

    hs4adm@DCN02:/usr/sap/HS4/HDB90> hdbnsutil -sr_state
    checking for active or inactive nameserver ...
    
    System Replication State
    ~~~~~~~~~~~~~~~~~~~~~~~~
    
    mode: primary
    site id: 1
    site name: DCN02
    
    Host Mappings:
    ~~~~~~~~~~~~~~
    
    dcn02 -> [DCN02] dcn02
    
    
    done.

  14. Run the HDB start command on DCN01 to start the database.
  15. Run the hdbnsutil -sr_unregister --name=DCN03 command on DCN01 to unregister it from DCN03.
  16. Run the hdbnsutil -sr_unregister --name=DCN02 command on DCN01 to unregister it from DCN02.
  17. Run the hdbnsutil -sr_state command on DCN01 to check the SR status and check that there is no registration information.
  18. Run the HDB stop command on DCN01 to stop the database.
  19. Run the hdbnsutil -sr_register --remoteHost=DCN02 --remoteInstance=90 --mode=sync --name=DCN01 command on DCN01 to register it with DCN02.
  20. Run the HDB start command on DCN01 to start the database.
  21. If the OS is RHEL, run the pcs property set maintenance-mode=false command on DCN02 to exit the maintenance mode. If the OS is SLES, run the crm configure property maintenance-mode=false command.
  22. Run the pcs resource cleanup command on DCN02 to delete historical resource records.
  23. Log in to SUSE Hawk and choose Cleanup in the Operations column of the target resource.

  24. Run the crm_mon command on DCN02 to check the HA resource status.

    [root@DCN02 ~]# crm_mon
    Cluster name: hacluster
    Last updated: Sat Feb 27 11:31:35 2016
    Last change: Sat Feb 27 11:30:52 2016
    Stack: cman
    Current DC: DCN01 - partition with quorum
    Version: 1.1.11-97629de
    2 Nodes configured
    7 Resources configured
    
    
    Online: [ DCN01 DCN02 ]
    
    Full list of resources:
    
    st_ipmi_dcn01  (stonith:fence_ipmilan):        Started DCN02
    st_ipmi_dcn02  (stonith:fence_ipmilan):        Started DCN01
    rsc_ip_SAPHana_HS4_HDB00       (ocf::heartbeat:IPaddr2):       Started DCN02
    Clone Set: rsc_SAPHanaTopology_HS4_HDB00-clone [rsc_SAPHanaTopology_HS4_HDB00]
    Started: [ DCN01 DCN02 ]
    Master/Slave Set: msl_rsc_SAPHana_HS4_HDB00 [rsc_SAPHana_HS4_HDB00]
    Masters: [ DCN02 ]
    Slaves: [ DCN01 ]

  25. Run the su - <sid>adm command on DCN02 to log in to the database on it.
  26. Run the hdbnsutil -sr_state command on DCN02 to check the SR status.

    hs4adm@DCN02:/usr/sap/HS4/HDB90> hdbnsutil -sr_state
    checking for active or inactive nameserver ...
    
    System Replication State
    ~~~~~~~~~~~~~~~~~~~~~~~~
    
    mode: primary
    site id: 1
    site name: DCN02
    
    Host Mappings:
    ~~~~~~~~~~~~~~
    
    dcn02 -> [DCN02] dcn02
    dcn02 -> [DCN01] dcn01
    
    
    done.

  27. Log in to DCN01 and run the hdbnsutil -sr_state command to check the SR status.

    hs4adm@DCN01:/usr/sap/HS4/HDB90> hdbnsutil -sr_state
    checking for active or inactive nameserver ...
    
    System Replication State
    ~~~~~~~~~~~~~~~~~~~~~~~~
    
    mode: sync
    site id: 2
    site name: DCN01
    active primary site: 1
    
    
    Host Mappings:
    ~~~~~~~~~~~~~~
    
    dcn01 -> [DCN02] dcn02
    dcn01 -> [DCN01] dcn01
    
    primary masters:dcn02
    
    done.

  28. Run the hdbnsutil -sr_enable command on DCN01 to enable SR.
  29. Run the HDB info command on DCN03 to check the database status.
  30. Run the hdbnsutil -sr_state command on DCN03 to check the SR status and check that there is no registration information.

    hs4adm@DCN03:/usr/sap/HS4/HDB90> hdbnsutil -sr_state
    checking for active or inactive nameserver ...
    
    System Replication State
    ~~~~~~~~~~~~~~~~~~~~~~~~
    
    mode: primary
    site id: 3
    site name: DCN03
    
    Host Mappings:
    ~~~~~~~~~~~~~~
    
    dcn03 -> [DCN03] dcn03
    
    
    done.

  31. Run the HDB stop command on DCN03 to stop the database.
  32. Run the hdbnsutil -sr_register --remoteHost=DCN01 --remoteInstance=90 --mode=async --name=DCN03 command on DCN03 to register it with DCN01.
  33. Run the HDB start command on DCN03 to start the database.
  34. Run the hdbnsutil -sr_state command on DCN03 to check the SR status.

    hs4adm@DCN03:/usr/sap/HS4/HDB90>  hdbnsutil -sr_state
    checking for active or inactive nameserver ...
    
    System Replication State
    ~~~~~~~~~~~~~~~~~~~~~~~~
    
    mode: async
    site id: 3
    site name: DCN03
    active primary site: 2
    
    
    Host Mappings:
    ~~~~~~~~~~~~~~
    
    dcn03 -> [DCN02] dcn02
    dcn03 -> [DCN03] dcn03
    dcn03 -> [DCN01] dcn01
    
    primary masters:dcn01
    
    done.

  35. Log in to the database from the studio using the virtual IP address, and check the SR status.

    DCN02 is the primary node, DCN01 is the secondary node, and DCN03 is the DR node.

    The following figure shows the network diagram after the restoration.

    NOTE:

    If you want to restore DCN01 as the primary node, DCN02 as the secondary node, and DCN03 as the DR node, perform a takeover after step 35 to configure DCN01 as the primary node. Then register DCN02 with DCN01 for synchronous replication and register DCN03 with DCN02 for asynchronous replication.

Translation
Download
Updated: 2019-03-30

Document ID: EDOC1100073266

Views: 1936

Downloads: 27

Average rating:
This Document Applies to these Products

Related Version

Related Documents

Share
Previous Next