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”

    After the restore operation is complete, verify that the tenant database is automatically started.

Example

Perform a restore operation.

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”

Last modified: 3/19/2019 9:22:17 AM