HDBSQL Example: Performing SAP HANA Multitenant Tenant Database Restores with the Data Backup

Restore the SAP HANA tenant database with the data backup.

Before You Begin

1. Perform a SAP HANA complete data backup on a Multitenant Tenant Database.

2. Stop the tenant database. On the command line, type the following command, substituting the tenant_database_name parameter with your value.

    
   hdbsql -U user_store_key “ALTER SYSTEM STOP DATABASE tenant_database_name′′

Procedure

• On the command line, type the following command.

   
  hdbsql -U user_store_key “RECOVER DATA FOR tenant_database_name USING BACKINT ‘data_backup′ CLEAR LOG”

What to Do Next

1. Verify the status of the tenant databases. On the command line, type the following command:

    
   hdbsql -U user_store_key “Select * from M_DATABASES” > file_name

2. View the output file.

3. Start the tenant database. On the command line, type the following command, substituting the tenant_database_name parameter with your value.

    
   hdbsql -U user_store_key “ALTER SYSTEM START DATABASE tenant_database_name′′

Example

Perform a restore

hdbsql -U BACKUPM “RECOVER DATA FOR TEN2 USING BACKINT ‘2015-07-07:09:54:00_COMPLETE_DATA_BACKUP_TEN2′ CLEAR LOG”