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.
|
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 simply 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. |
|
|
|
Specify the Recovery Type. |
|
|
|
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. |
|
|
|
Review the relevant settings for “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. |
|
|
|
Monitor the data recovery operation. |
|
|