Restore the SAP HANA tenant database with the backup and logs.
Before You Begin
-
Perform a SAP HANA complete data backup on a Multitenant Tenant Database.
-
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”