Are you running a mission-critical database like SAP HANA in your data center?
Is your SAP landscape large and complex
with several production and non-production instances?
And how about a one-stop solution
for all your data protection needs for the entire SAP landscape?
Hi. My name is Ansul Nagori.
I'm a worldwide technical marketing expert with HPE storage
and today I'm going to talk to you about SAP HANA data protection
using Commvault and HPE.
This is the first video in two-part series.
Let's see.
Commvault is a data protection and data management solution which
offers intelligent data services for several mission-critical databases,
one of them being SAP HANA.
It primarily supports two kinds of backups for SAP HANA:
Backint and Snapshop.
In this video, we are going to talk about
Commvault streaming backups which use the Backint API,
and in the next video, we will talk about Commvault's IntelliSnap technology
with HPE solutions.
Commvault streaming backups for SAP HANA
is an SAP certified data protection approach for data as well as [inaudible].
In this demo, we have used HPE StoreOnce as the backup catalyst.
HPE StoreOnce is a highly secure and highly performing
secondary storage appliance
available as a bare metal or software-defined offer.
Using its catalyst interface, HPE StoreOnce
offers [inaudible] for backing up
mission-critical workloads like SAP HANA on premises and in the cloud.
It integrates pretty well with Commvault.
Commvault automates almost all of SAP HANA's backup restore
and initial configuration tasks so that you don't need to go back and forth
between the SAP HANA and UIs like computer Studio
and the Commvault command center.
Commvault is an HPE complete partner
and is available as-a-service in the HPE GreenLake offering.
Now let's take a look at a demonstration
where Commvault streaming backups for SAP HANA are used with HPE [inaudible].
Here, I have a bare metal SAP HANA instance called CV1 with one tenant database.
This is the Commvault command center UI
and we have the StoreOnce VSA with three
stores for data log backups and data snapshots.
Now we need to add the StoreOnce in Commvault.
So we go to storage, Cloud.
Click on Add, select Cloud storage,
and then from the type drop down, you select HPE Catalyst Storage.
And we need to give a name to this storage destination.
Enter the IP address or host name of the StoreOnce system.
Give in the name of the StoreOnce [inaudible],
and enter the credentials of the client that has access to that particular store.
I click on Save so that this store gets added as a backup destination on Commvault.
Similarly, we add the other two as well.
Now we go to plans to create a backup plan.
Click on Create plan. First the server.
Enter a plan name
and add the recently added storage
StoreOnce catalyst store as the backup destination.
This is the default RPO for the log backups if it's a database.
So if you want, you can change it based on your SLAs.
And we click on the Save button to save this plan.
The plan is now created. It has got a default backup copy option enabled.
I'm disabling it right now, but you can keep it on if you want.
That is basically with snapshots. Then we go to Protect Databases,
click on SAP HANA, and we're going to add the SAP HANA instance here.
So we give the host name underscore SID.
That's the format. Enter the SID.
Select the plan, set up the HANA host. I have already added the HANA host earlier.
And enter the details of the system user.
Then we go to the SCP HANA system and just start dealing a log file so
that we can monitor the progress of what Commvault is doing on the Backint.
And we click on Add, and this will add
the SAP HANA instance onto the Commvault system.
So you can see all the changes that are happening in
the log file. Plan is added. And we click on the instance.
And now we have the tenant and the system database both available.
To back up, we click on the backup system option and select the system DB first.
You set up the type of backup, and now they can do the backup job itself.
This can be verified by going to the backup console on HANA studio.
We see all the configuration for Backint is already created by Commvault,
and on the back catalog.
We can refresh, this is the Backint. These are the logs that are getting generated.
So the initial configuration settings in global NI are all done automatically.
And a backup command has been issued.
So if we refresh, we see a new backup with Backint type has been initiated.
And this is basically writing data to the
catalyst store on StoreOnce.
The job is now completed.
The next step would be to back up the tenant database in a very similar fashion.
So we go to the instance.
Click on Back up, select the tenant,
select the type of backup and click OK.
Now we can view the job details as well as look at the logs.
So it will do the initial configuration for the tenant database as well.
The Global NI file,
and subsequently issue a backup command.
So we change the database to the tenant database.
And now we have a backup of the tenant database
getting [inaudible] system.
You can verify the files under StoreOnce.
You've got a recent deduplication there and as
you go forward, the deduplication ratio will improve.
You can even monitor the job from the
jobs page on Commvault command center.
As I spoke earlier, they have got log volume backups also going on.
So the size of the HANA database is around 100 GB as you can see here.
And it's getting compressed to 62.8 GB so they've got a decent deduplication.
So that's how you use the Commvault streaming backups to
back up data and log for an SAP HANA instance.
In summary, Commvault's streaming backups for SAP HANA
utilizes the Backint API with HPE StoreOnce to offer data protection for your
bare metal or virtual, scale up or scale out,
production or non-production SAP HANA instances.
In the next video, we will talk about Commvault's
IntelliSnap technology and how it integrates with HPE
storage areas to offer complete protection for your SAP landscapes.
To know more about our joint solutions,
reach out to your Commvault or HPE representative today.
And if you like this video,
hit the like button and share the video with your customers and colleagues.
And to watch more such technology videos, subscribe to the HPE channel on YouTube.
Thanks for watching.