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.
|
Review all of the recovery settings and proceed by selecting “finish”.Navigate to the main database view in SAP HANA Studio, right click on the relevant database connection, navigate to “Backup and Recovery” and then select “Recover Tenant Database…”. When using a single container SAP HANA 1.0 system this will state “Recover database…” |
|
|
|
(MDC Only) Select the tenant database to restore. In SAP HANA 2.0 SPS03 and previous releases only a single tenant system can be restored.(MDC Only). Select the tenant database to restore. In SAP HANA 2.0 SPS03 and previous releases only a single tenant system can be restored. |
|
|
|
The location of the backup catalog is normally populated, only change this under specialized circumstances where the recovery catalog is in a different location. |
|
|
|
Accept the prompt to shut down the database. |
|
|
|
The relevant recovery point should be shown as available, then select “Next “to proceed. |
|
|
|
The log backup location is typically populated with the system default values, only change these values in specialized circumstances. |
|
|
|
Review the relevant settings for “Check the availability of delta and log backups”, “Initialize Log Area”, “Use Delta Backups” and “Install New License Key”. In some scenarios, these selections will be grayed out depending on the recovery type. |
|
|
|
Review all of the recovery settings and proceed by selecting “finish”. |
|
|
|
When recovery is completed the status will be shown. |
|
|