Loading...

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

Parameter

Value

user_store_key

BACKUPM

tenant_database_name

TEN2

data_backup

2015-07-07:09:54:00_COMPLETE_DATA_BACKUP_TEN2

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

Last modified: 7/10/2018 2:35:53 PM