cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA Backup und Recovery

Former Member
0 Kudos

is it possible to backup and recover the HANA Database to/from a NTFS Share with the HANA Studio. If so how too.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Manfred,

Backup and recover using HANA studio

To Backup using SAP HANA Studio

From the context menu choose Backup option, choose the backup destination path and backup prefix then choose finish.

To recover using SAP HANA Studio

From the context menu choose Recovery option ,provide<SID>adm username and password and then choose the required recovery type.Then specify the location of the required backup files(databackup and logbackup).Install the license and finish the process.

Note 1:Constraints that applies with recovery of SAP HANA database are

  • Recovery of the backup from higher system release to lower system release is not possible.
  • Recovery can’t be interrupted or stopped in between ,once it is triggered

Note 2:if the license expires on recovery ,new license has to be installed.

Regards,

Sakuru.Koteswararao

Former Member
0 Kudos

Hi Manfred,

Data backup can be taken manually or can be scheduled

SAP HANA database backups up its services (nameserver,nameservertopology,indexserver,xsengine and statisticserver)

Which will be stored in a specific destination mentioned in configuration file  global.ini with the parameters

basepath_databackup and basepath_logbackup

The parameters pointing as below to the default valuesbasepath_databackup=$(DIR_INSTANCE)/backup/data used for databackup,

basepath_logbackup==$(DIR_INSTANCE)/backup/log respectively for logbackup

Backup can be performed with the below sql query

BACKUP DATA USING FILE ('<path><prefix>')

The backup files generated by performing the databackup of SAP HANA database will be as below

COMPLETE_DATA_BACKUP_databackup_0_1

COMPLETE_DATA_BACKUP_databackup_1_1

COMPLETE_DATA_BACKUP_databackup_2_1

COMPLETE_DATA_BACKUP_databackup_3_1

COMPLETE_DATA_BACKUP_databackup_4_1

Where COMPLETE_DATA_BACKUP is the prefix(default) ,which can be changed to the required prefix while performing a data backup.

Regards,

Sakuru.Koteswararao

SK-EA
Active Participant
0 Kudos

Manfred,

Yes, its absolutely possible to backup directly to a NFS mount shared folder from the SAP Hana Studio. Process would be similar to that of maintaining backup on to a local folder.

Prior to initiating backup ensure that the mount location is active, or execute mount -a command under root user to load all the configured mount points.

Also as a best practice verify the last complete backup status in the backup catalog and ensure it is completed successfully. If you find a running status for long time you need to check the logs and cancel it (CANCEL BACKUP <Backupid>) if required. This may also require a reboot of the Hana instance.

Next would be looking for sufficient free space in the NFS share folder, as quoted in the backup dialog.

Lastly, In the backup dialog, specify the full path of the target location. For example,

\<nfs_mount_name>\HanaBackup\HDBBackupDate

Refer to the below OSS note for known issues with NFS mounts as target locations for backups.

Note 1716418 - Data backup hangs when writing to NFS server

In our experience, we found out that maintaining backups using hdbsql commands is much efficient when compared to backups from SAP Hana Studio. These hdbsql commands can be automated by scheduling jobs in cron tab. Refer to the SAP Hana Administration Guide for details.

We haven't yet tested the recovery scenario, hence cannot comment on it

Hope the above information regarding the SAP Hana backups helps.

Regards,

Srinivas K.

AtulKumarJain
Active Contributor
0 Kudos

Hi Manfred,

please check

SAP Note No. 1642148 FAQ: SAP HANA Database Backup & Recovery

SAP Note No. 1820529 Unsuitable network file systems for backup and recovery

I hope note 1820529 will answer your question.

Best Regards,

Atul