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


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


Huawei SAP HANA Appliance Two Node Installation Guide (RH5885H and RH8100 V3+Redhat) 10

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).
Creating Database Backups

Creating Database Backups

Use the HANA studio management tool or command-line interface (CLI) to create backups for the two HANA servers.

  1. Log in a SAP HANA server (HW00001 in this example) as the root user and go to the /usr/sap/hdbclient installation directory.
  2. Run the backup command ./hdbsql -i 00 -u system -p -n localhost:30015 <SYTEM password> "BACKUP DATA USING FILE ('backup')" to create a database backup. If the following information is displayed, the database backup is created:

    HW00001:/ cd /usr/sap/hdbclient
    HW00001:/usr/sap/hdbclient # ./hdbsql -i 00 -u system -p Huawei_123 -n localhost:30015 "BACKUP DATA USING FILE ('backup')"
    0 rows affected (overall time 22.108163 sec; server time 22.107311 sec)

    Before you run the backup command, ensure that the database is running in primary mode. The database is supposed not to be registered with another database. Otherwise, the backup command fails.

  3. If the database version is HANA2.0 or multiple_containers,backup SYSEMDB and tenantDB is necessary, Run following command(00 is the instance ,S00 is the SID):

    ./hdbsql -i 00 -u SYSTEM -p Huawei123 -n localhost:30013 "backup data for S00 using file ('COMPLETE_DATA_BACKUP')"
    ./hdbsql -i 00 -u SYSTEM -p Huawei123 -n localhost:30013 "backup data using file ('COMPLETE_DATA_BACKUP')"

  4. Log in to the other SAP HANA server as the root user and create the database backup in the same way.
Updated: 2019-08-27

Document ID: EDOC1100019155

Views: 34762

Downloads: 130

Average rating:
This Document Applies to these Products

Related Version

Related Documents

Previous Next