During the recovery of the System database, all tenant databases are invalidated and need to be individually recovered by repeating the below steps.
Follow from here if using single container SAP HANA 1.0 system. Notable differences are the absence of “System” and “Tenant” terminology.
In SAP HANA 2.0 SPS04 and onwards repeat these steps for each additional tenant database.
Ensure that Step 1a is completed, while the database is offline, for SAP HANA 1.0 Single tenant systems before proceeding with the below.
|
Once the System Database has been recovered select “Manage Databases” from the SystemDB database view. |
|
|
|
All of the tenants will be shown, but in an offline state. In SAP HANA SPS03 and previous releases only a single tenant system can be recovered when using data snapshots. |
|
|
|
Highlight the relevant tenant database to be recovered and then select the three dots in the right-hand corner to bring up the context menu, then select “Recover Tenant”. |
|
|
|
Select the recovery target type. |
|
|
|
Specify the location of the latest backup catalog, only change these values under specialized circumstances. |
|
|
|
The relevant backup to be used will have the status of “Available”, select this and then select “Step 4”. |
|
|
|
Specify if Delta Backups are to be used (using data snapshots this value will be ignored). |
|
|
|
Specify an Alternative Backup location if any exist. |
|
|
|
Specify if the log area must be initialized. |
|
|
|
Review the information for the recovery operation and then select “Start Recovery”. |
|
|
|
Once the tenant has been successfully recovered the status will be shown. |
|
|