Skip to main content
SnapCenter Software 5.0

Back up SAP HANA databases

Contributors netapp-nsriram netapp-soumikd netapp-asubhas
PDFs

If a resource is not yet part of any resource group, you can back up the resource from the Resources page.

Before you begin

  • You must have created a backup policy.

  • If you want to back up a resource that has a SnapMirror relationship with a secondary storage, the ONTAP role assigned to the storage user should include the “snapmirror all” privilege. However, if you are using the “vsadmin” role, then the “snapmirror all” privilege is not required.

  • For Snapshot copy-based backup operation, ensure that all the tenant databases are valid and active.

  • To create SAP HANA system replication backups, it is recommended to add all the resources of the SAP HANA system into one resource group. This ensures a seamless backup during takeover-failback mode.

    Create resource groups and attach policies.

    Back up resource groups

  • If you want to create a file-based backup when one or more tenant databases are down, set the ALLOW_FILE_BASED_BACKUP_IFINACTIVE_TENANTS_PRESENT parameter to YES in the HANA properties file using Set-SmConfigSettings cmdlet.

    The information regarding the parameters that can be used with the cmdlet and their descriptions can be obtained by running Get-Help command_name. Alternatively, you can also refer to the SnapCenter Software Cmdlet Reference Guide

  • For pre and post commands for quiesce, Snapshot, and unquiesce operations, you should check if the commands exist in the command list available on the plug-in host from the following paths:

    For Windows: C:\Program Files\NetApp\SnapCenter\Snapcenter Plug-in Creator\etc\allowed_commands_list.txt

    For Linux: /var/opt/snapcenter/scc/allowed_commands_list.txt

Note If the commands do not exist in the command list, then the operation will fail.
Steps

  1. In the left navigation pane, select Resources, and then select the appropriate plug-in from the list.

  2. In the Resource page, filter resources from the View drop-down list based on resource type.

    Select filter icon, and then select the host name and the resource type to filter the resources. You can then select filter icon to close the filter pane.

  3. Select the resource that you want to back up.

  4. In the Resource page, select Use custom name format for Snapshot copy, and then enter a custom name format that you want to use for the Snapshot name.

    For example, customtext_policy_hostname or resource_hostname. By default, a timestamp is appended to the Snapshot name.

  5. In the Application Settings page, do the following:

    • Select the Backups arrow to set additional backup options:

      Enable consistency group backup, if needed, and perform the following tasks:

      For this field…​ Do this…​

      Afford time to wait for "Consistency Group Snapshot" operation to complete

      Select Urgent, or Medium, or Relaxed to specify the wait time for Snapshot operation to finish. Urgent = 5 seconds, Medium = 7 seconds, and Relaxed = 20 seconds.

      Disable WAFL Sync

      Select this to avoid forcing a WAFL consistency point.

    • Select the Scripts arrow to run pre and post commands for quiesce, Snapshot, and unquiesce operations.

      You can also run pre commands before exiting the backup operation. Prescripts and postscripts are run in the SnapCenter Server.

    • Select the Custom Configurationsarrow, and then enter the custom value pairs required for all jobs using this resource.

    • Select the Snapshot Copy Tool arrow to select the tool to create Snapshots:

      If you want…​ Then…​

      SnapCenter to create a storage-level Snapshot

      Select SnapCenter without File System Consistency.

      SnapCenter to use the plug-in for Windows to put the file system into a consistent state and then create a Snapshot

      Select SnapCenter with File System Consistency.

      To enter the command to create a Snapshot

      Select Other, and then enter the command to create a Snapshot.

      application settings

  6. In the Policies page, perform the following steps:

    1. Select one or more policies from the drop-down list.

      Note You can also create a policy by clicking add policy from resourcegroup.

      In the Configure schedules for selected policies section, the selected policies are listed.

    2. Select add policy from resourcegroup in the Configure Schedules column for the policy for which you want to configure a schedule.

    3. In the Add schedules for policy policy_name dialog box, configure the schedule, and then select OK.

      policy_name is the name of the policy that you selected.

      The configured schedules are listed in the Applied Schedules column.

  7. In the Notification page, from the Email preference drop-down list, select the scenarios in which you want to send the emails.

    You must also specify the sender and receiver email addresses, and the subject of the email. SMTP must also be configured in Settings > Global Settings.

  8. Review the summary, and then select Finish.

    The resources topology page is displayed.

  9. Select Back up Now.

  10. In the Backup page, perform the following steps:

    1. If you applied multiple policies to the resource, from the Policy drop-down list, select the policy that you want to use for backup.

      If the policy selected for the on-demand backup is associated with a backup schedule, the on-demand backups will be retained based on the retention settings specified for the schedule type.

    2. Select Backup.

  11. Monitor the operation progress by clicking Monitor > Jobs.

    • In MetroCluster configurations, SnapCenter might not be able to detect a protection relationship after a failover.

      For information, see: Unable to detect SnapMirror or SnapVault relationship after MetroCluster failover

    • If you are backing up application data on VMDKs and the Java heap size for the SnapCenter Plug-in for VMware vSphere is not large enough, the backup might fail.

      To increase the Java heap size, locate the script file /opt/netapp/init_scripts/scvservice. In that script, the do_start method command starts the SnapCenter VMware plug-in service. Update that command to the following: Java -jar -Xmx8192M -Xms4096M