V11 SP8
Loading...

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

Restore the SAP HANA tenant database with the backup and logs.

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 DATABASE FOR <tenant_database_name> UNTIL TIMESTAMP ‘<time_stamp>′ CHECK ACCESS”

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 TEN1
time_stamp 2015-07-07 10:30:00

hdbsql -U BACKUPM “RECOVER DATABASE FOR TEN1 UNTIL TIMESTAMP ‘2015-07-07 10:30:00′ CHECK ACCESS”