Welcome to Dell Technologies PowerProtect Data Manager Version 19.6
How to Series.
SAPA HANA Recovery using
PowerProtect Data Manager Self-Service Restore.
Reference Dell Knowledge Article # 180472.
This video was created to
Introduce PowerProtect Data Manager Self-Service Restore capability.
Demonstrate the required steps to perform Database Recovery via SAP HANA Studio GUI.
This video presents the following.
When is it necessary to recover the SAP HANA Database?
What kind of Recovery Procedures are available for the SAP HANA Database?
Requirements for performing an SAP HANA Recovery.
And procedures to recover the database through HANA Studio.
When is it necessary to recover the SAP HANA Database?
There are different situations in which it is necessary to recover
an SAP HANA Database, such as
disk crash of the Data Area
disk crash of the Log Area
resetting the system to a certain point in time
for a Special Recovery Purpose
creating a copy of the database.
What kind of Recovery Procedures are available for the SAP HANA Database?
Depending on the cause of the database failure
a different recovery strategy and procedure may be appropriate.
We have three recovery scenarios, such as
A) Recover the Database to its most recent state
which recovers the Database as close as possible to the current time.
B) Recover the Database to a specific point in time
which recovers the last data backup before the specified time.
C) Recover the Database to a specific data backup
which restores only the specified backup.
Requirements for performing an SAP HANA Recovery.
SAP HANA Database must be shut down.
User must have the system privilege BACKUP ADMIN.
The ADM Operating System user is required.
At least one data backup is required.
Before a recovery can start
all data and Log Backups must be either accessible in the file system
or available through the third-party backup tool.
Before you begin
you must complete the required configurations
on PowerProtect Data Manager
to enable the Backup and Restore Operations
in an SAP HANA Environment.
If you are performing Restore of backups
performed prior to PowerProtect Data Manager registration
you should modify the auto configuration file
and use the UTL file that was originally used for backup.
The success of a Database Recovery can only be ensured
if the required backups are available
and have not been changed since they were created.
For this reason, manually check backups periodically.
To perform a Restore and Recovery of an SAP HANA Database
you can run either of the supported SAP HANA tools
such as SAP HANA Studio GUI, which is the recommended method
or SAP HANA command-line interface using an SQL command.
In this demo, we have deleted some data volumes
on Tenant Database, to simulate file system crash.
We will walk through SAP HANA Tenant Database recovery steps
by using HANA Studio GUI.
Log in to SAP HANA host with ADM user.
Start SAP HANA Database instance by running the command “HDB start.”
Tenant Database failed to start due to system crash.
Now Data Area becomes unusable.
Hence, we need to recover the Tenant Database.
In order to check backup available for Restore
start PowerProtect Data Manager UI.
Then, go to Infrastructure.
Select Assets.
Select SAP HANA tab.
Select the Tenant Database asset.
Click on View Copies.
PowerProtect Data Manager.
Create a catalog of backups that are produced by the application agent
and monitor the catalog data
to determine if retention policies are being adhered to.
You can select a certain backup and expand it to see log backup details.
Start SAP HANA Studio and open the Recovery GUI.
Recovery of Tenant Database can only be initiated from System Database.
Tenant Databases are recovered individually and not in single operation.
So, you have to specify
the Tenant Database you would like to recover.
Click Next.
In the Specify Recovery Type page
select one of the following types of recovery
for the required .
Here, we are going to recover the database to a specific data backup.
Then, click Next.
On the Specify Backup Location page, choose whether you want to select a backup
from a backup catalog, or enter the name in the path of a backup
in the next step.
Here, we are using backup catalog.
Then, click Next.
To perform a Recovery, SAP HANA Database must be shut down.
So, click OK.
On the Select a Backup page, select the database backup
for either Restore or Recovery.
To check the availability of a backup, select the backup in the table
and then click Check Availability.
The available column in the table displays
either a green icon if the backup is available
or a red icon if the backup is not available.
Since our selected backup is available, click Next.
On the Other Settings page, select the required options
and then click Next.
On the Review Recovery Settings page
review the information, and then click Finish.
The recovery progress appears for each service that includes
the name server, the index server and the statistics server.
A confirmation message appears when the recovery completes.
This recovery has completed successfully and two volumes are now recovered.
Now, let’s try starting instance again
on SAP HANA host after successful recovery.
Database instance started successfully without any errors
and data volumes are successfully recovered.
Important notes.
The System Database only needs to be recovered if it is corrupted.
If only a Tenant Database is corrupted
the System Database does not need to be recovered.
To recover a complete SAP HANA system
the System Database needs to be recovered first
and then all the Tenant Databases are recovered individually.
You can recover an SAP HANA Database to the same system
or to an alternative system.
In order to perform alternate host recovery
you must replicate the directory path of the configuration files
on the destination machine, including the same permissions
and then copy the user and auto configuration files
from the source machine to the directory path.
Reference the following for more information.
PowerProtect Data Manager for SAP HANA Agent User Guide
section “Performing self-service backups of SAP HANA Database.”
SAP HANA Installation and Administration Guide
section “Performing Database Recovery.”
Thank you for watching.