How to configure backup and recovery of SAP HANA Multi-Tenant Database Containers

Article: 100038788
Last Published: 2018-08-01
Ratings: 5 0
Product(s): NetBackup

Description


Note: For more information regarding automatic scheduling of backup policies for SAP HANA Multi-Tenant Database Containers using NetBackup Admin console, see the attachments (word document and the sample script file) in this article. 

Disclaimer!
Please note that any script attached to this Technote is provided as is and is a sample script only. The script is not supported by Netbackup Technical support.
It is the responsibility of the customer to modify the script to take into account specific requirements and variables in his/her environment.

For additional information about SAP HANA Multi-Tenant Database Containers, see the SAP documentation.

Perform the following steps for manual backup and recovery of SAP HANA Multi-Tenant Database Containers:

1. Create a softlink from the Multi-Tenant System Database to the NetBackup client hdbbackint_script:
> ln -s /usr/openv/netbackup/bin/hdbbackint_script /usr/sap/<SID>/SYS/global/hdb/opt/hdbbackint


2. Create a file named node_names.txt in /usr/openv/netbackup/ext/db_ext/sap and add the host name of the System Database host as the first line in this file.

3. In SAP HANA Studio, configure SAP HANA to use backint:
User-added image


4. Provide the path to the .utl file for data and log backup for the System Database.

    Note: Ensure the backup policy name is the same in the source and target initSAP.utl file.

5. Confirm that everything is configured correctly.
    To back up the Instance Databases

a. In SAP HANA Studio, right-click on the System Database and select Backup and Recovery
b. Select either System Database or Tenant Database
User-added image
c. If System Database is selected then the backup will execute as a normal backup process
d. If a Tenant Database is selected then SAP HANA studio will ask you to select which Tenant Database
User-added image
 
e.After clicking next, the backup will execute as a normal backup process
 
6. Restore of the Instance Databases
a. Select either Recover System Database or Recover Tenant Database
User-added image
b. If the System Database is selected then the restore will execute as a normal restore process
c. If a Tenant Database is selected then SAP HANA studio will ask you to select which Tenant Database
User-added image
d. After clicking next, the restore will execute as a normal restore process

 

Attachments

  1. Schedule_SAP_HANA_Multi-Tenant_Backup.docx (14.34 KB)
  2. sap_hana_multi_db_bkp.txt (4.34 KB)

 

Was this content helpful?