Complete the Databases Guided Setup for SAP HANA

The Databases guided setup guides you through creating a backup plan and adding an SAP HANA database server.

Go to the Databases Guided Setup

1. From the navigation pane, go to Guided setup.

   The Welcome page appears.

2. On the Protect tab, in the Databases tile, click Configure.

   the database Guided setup page appears.

   Note

   If you click Go To App, the database Instances tab appears.

3. From the Configure Database Server wizard, select SAP HANA.

   Click NEXT.

Create a Backup Plan That You Can Use for SAP HANA

The backup plan defines how often the software backs up the database and the log files, and where it stores the backups.

If you already have a backup plan that you can use, you can skip this step.

Before You Begin

To create a backup plan, you must have the Plan creator role assigned to your user account.

Procedure

1. Go to Configure Database Server wizard.

   You can select an existing backup plan or add a new backup plan.

2. To add a new backup plan, click the Add icon available on the right side of the Search Plans by plan name box.

   The Create backup plan dialog box appears.

3. If you only want to create a backup plan and skip the other advanced options, enter the following details:

   • In the Plan name box, enter the name of the backup plan.

   • In the Storage box, select an existing storage from the storage list.

   • From the Retention rules section, select a retention plan.

   • Click DONE.

4. If you want to create a backup plan with advanced options, click For advanced options click here option at the bottom of the dialog box.

   The Create Backup Plan wizard appears.

5. Specify the settings for a backup plan that you can use for the SAP HANA instance.

6. Settings	Steps
   General	Fill in the following plan information: Choose whether to create a new plan or use a base plan. If you selected Create a new plan, in the Plan name, enter a name for the backup plan. If you selected Use existing base plan, specify the plan name and select a Base plan. It allows you to create a plan by inheriting setting from base plan.
   Backup destinations	Click Add copy. The Add copy dialog box appears. In Name, enter a name for the backup destination. From the Storage list, select the storage to use for the backups. You can use the Air Gap Protect cool storage class for creating secondary copies, but not for creating primary copies. To specify the start time for backups on a specific date and later, move the Backups On and After toggle key to the right. For Retention rules, enter the amount of time to retain the backups. To specify additional backups, such as weekly full backups, move the Extended retention rules toggle key to the right, and then add rules. Click SAVE. To add additional regions to the backup destination, move the Multi-region toggle key to the right, and then select the regions. You can also add more regions and associate the storage copy to the region.
   RPO	For Backup frequency, click Add. The Add backup frequency dialog box appears. From the Backup type list, select the backup type, and from the for list, select All agents or Databases. Specify the frequency of the backup. To specify the client time zone, full backup database frequency, or to add exceptions, move the Advanced toggle key to the right, and do the following: From the time zone list, select the time zone according to which the backups must run. If you select incremental or differential backup type for all agents or databases, to modify the full backup frequency of the database, specify a value for Run full backup on databases every option. To add exceptions when the backups must not run, click Exceptions, and then add exceptions for any day of a month or week or schedule an exception for any week of the month. Exceptions repeat every week or month according to the selected exception. To modify the transaction log frequency, or enable disk cache for log backups, in the Run transaction log for databases field, click Edit . For Transaction log, specify how often to run log backups. To automatically back up the database logs to the MediaAgent cache, move the Advance toggle button to the right and do the following: Move the Use disk cache for log backups toggle key to the right. For Commit every, enter how often to commit the logs to the CommServe computer. Disk caching of database logs applies to the following databases: Informix, Microsoft SQL Server on Windows, Oracle, Oracle RAC, and SAP HANA Note The database schedules are available only if the backup plan is applicable to database solution and only one transaction log schedule can be added to that specific plan. For Backup window (if incremental and differential backups are supported for the workload), specify when you want incremental and differential backups to run. For Full backup window, specify when you want full backups to run.
   Folders to back up	To back up only some content, in Content to back up, enter the content to back up. By default, all content is backed up. To exclude folders or files from the backup, in Exclude - files/folders/patterns, enter the content to exclude. Specify whether to include the system state in backups: To include the system state in all backups, move the Back up system state toggle key to the right. To include the system state only in full backups, select the Back up system state check box and the Only with full backup check box. To use Windows Server's VSS (Volume Shadow Copy Service) to back up the system state, select the Use VSS for system state check box.
   Snapshot options	Under Snapshot options, do the following: Specify how to retain snapshots: To specify a number of jobs to retain on a snapshot copy, select Number of snap recovery points, and then enter the number of jobs to retain. To specify a retention period, select Retention period, and then enter the amount of time to retain the jobs. If you don't want to create backup copies, move the Enable backup copy toggle key to the left to turn it off. For Backup copy frequency, enter how often to run backup copy jobs.
   Database options	Under Database options, do the following: For Log backup RPO, enter how often to run log backups. To automatically back up the database logs to the MediaAgent cache, do the following: Move the Use disk cache for log backups toggle key to the right. For Commit, enter how often to commit the logs to the CommServe computer. Disk caching of database logs applies to the following: Informix, Microsoft SQL Server on Windows, Oracle, Oracle RAC, and SAP HANA.
   Override restrictions	Leave the Allow plan to be overridden check box cleared.

7. Click SUBMIT.

Add an SAP HANA Database Server

You can add the SAP HANA database server to be configured for backup and provide login credentials to allow push install.

Before You Begin

• Determine how to connect to the database. If you want to use the SAP HANA Secure User Store, create a key.

  For information about the SAP Secure User Store, go to "hdbuserstore" in the SAP Help Portal website.

• Obtain the following information about the SAP HANA system:

  • The admin user name

  • The SAP HANA instance SID

  • The SAP HANA user credentials

  • The directory that contains the SAP HANA hdbsql tools

    To determine the location, log in to the SAP HANA server with the sid admin credentials and type the following on the command line:

    which hdbsql

  • If the SAP HANA environment uses a Secure Sockets Layer (SSL) connection, obtain the name of the SSL provider and the SSL trust store file that stores the CA-signed certificates.

Procedure

1. Go to the Add database servers page.

2. Click the Add button.

3. From the Add database server dialog box.

4. Click NEXT.

5. In the Host name box, enter a name for the SAP HANA host.

6. Select an OS type from the following:

   • Unix

   • Windows

     Note

     Unix is selected by default.

7. From Credential list, you can select a saved credential or add a new credential.

   Steps to add a credential

   1. Click +.

      The Add Credential dialog box appears.

   2. In the Account type box, the Linux account is selected by default.

   3. From the Credential Vault list, select a credential vault to store, share, and update account credentials with shared resources in your environment.

   4. In the Credential name box, enter a unique name to access the credential.

   5. In the User account box, enter the user account that access to the SAP HANA server.

   6. In the Password/Passphrase box, enter the password for the user account.

   7. In the Description box, enter a brief description for the credential.

   8. Click SAVE.

   Note

   1. If you select OS as Windows.

      • From Credential list, select a saved credential or add a new credential.

      • Click SAVE.

8. To grant write access to a UNIX group, such as the dba group, in the UNIX group box, type the name of the group.

9. In the SSH port number box, enter the port number.

10. To use a SSH key, do the following:

    • Move the Use SSH key toggle key to the right.

    • In the SSH key path box, enter the path for the SSH key. Alternately, you can click SELECT FILE button to define a path.

11. To use a passphrase for the SSH key, do the following:

    • Move the Use SSH key file passphrase toggle key to the right.

    • In the Passphrase box, enter the passphrase for the SSH key.

12. Click SAVE.