Complete the Databases Guided Setup for SAP HANA

Updated

The Databases guided setup guides you through creating a server 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, click the Databases tile.

    The Databases guided setup appears.

Create a Server Plan That You Can Use for SAP HANA

The server 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 server plan that you can use, you can skip this step.

Before You Begin

To create a server plan, you must have the Plan Creator Role assigned to your user account.

Procedure

  1. On the Create server backup plan page, click Create a new plan, and then specify the settings for a server plan that you can use for the SAP for Oracle instance.

Settings

Steps

Plan name

  1. Enter a name for the server plan.

Click Next.

Backup destinations

  1. Click Add.

    The Add backup destination dialog box appears.

  2. In Name, enter a name for the backup destination.

  3. From the Storage list, select the storage to use for the backups.

    If you selected storage that uses Distributed Storages, the Optimize for instant clone toggle key appears.

    By default, this setting is turned on to allow the associated Distributed Storage to optimize backups for clones, using Copy Data Management. To turn off the setting, move the Optimize for instant clone toggle key to the left.

    The setting does not apply to Hyperscale solutions that use Distributed Storage.

  4. For Retention period, enter the amount of time to retain the backups.

  5. To specify additional backups, such as weekly full backups, move the Extended retention rules toggle key to the right, and then add rules.

  6. Click Save.

RPO

  1. For Backup, specify how often and when to run incremental backups.

  2. To run full backups, move the Add full backup toggle key to the right, and then specify how often and when to run full backups.

  3. For Backup window, specify when you want incremental backups to run.

  4. For Full backup window, specify when you want full backups to run.

Folders to back up

  1. To back up only some content, in Content to back up, enter the content to back up.

    By default, all content is backed up.

  2. To exclude folders or files from the backup, in Exclude - files/folders/patterns, enter the content to exclude.

  3. Specify whether to include the system state in backups:

    • To include the system state in all backups, select the Back up system state check box.

    • 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 VSS (Volume Snapshot Service, also called Shadow Copy) to back up the system state, select the Use VSS for system state check box.

Snapshot options

  1. 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.

  2. If you don't want to create backup copies, move the Enable backup copy toggle key to the left to turn it off.

  3. For Backup copy frequency, enter how often to run backup copy jobs.

Database options

  1. For Log backup RPO, enter how often to run log backups.

  2. To use the disk cache of the logs to the MediaAgent for backups, do the following:

    1. Move the Use disk cache for log backups toggle key to the right.

    2. For Commit every, enter how often to commit the logs to the CommServe computer.

      Disk caching of database logs applies to the following agents: Informix, Microsoft SQL Server on Windows, Oracle, Oracle RAC, and SAP HANA.

Override restrictions

Leave the Allow plan to be overridden check box cleared.

  1. Click Save.

Add an SAP HANA Database Server

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. From the Application type list, select SAP HANA.

  3. In the SAP HANA system name box, enter a name for the SAP HANA system.

  4. In the SID box, enter the name of the SAP HANA database SID.

  5. From the Plan list, select the server plan.

  6. Add the SAP HANA host to install the SAP HANA agent on:

    1. Beside the HANA hosts list, click +.

      The Add SAP HANA host dialog box.

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

    3. In the User name box, enter the user name for the SAP HANA host.

    4. In the Password and Confirm password boxes, enter the password for the HANA host user.

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

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

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

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

      2. In the SSH key path box, enter the path for the SSH key.

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

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

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

    9. To reboot the SAP HANA host, move the Reboot if required toggle key to the right.

    10. Click Install.

  7. Choose how you want to connect to the SAP HANA database server:

    • User credentials: To connect to the database using the credentials, select this option, and then enter the user name and password.

    • HDB store key: To connect to the database using a hdbuserstore key, select this option, then in the Store key box, enter the hdbuserstore key.

  8. In the hdbsql location box, enter the directory that contains the HANA hdbsql tools.

  9. In the OS username box, type the admin user name.

  10. To authenticate access to the HANA server that use an SSL connection, move the Enable SSL toggle key to the right, and then provide the following details:

    • In the Service provider box, enter the service provider that is used for the SSL connection.

      For example, enter commoncrpto.

    • In the SSL trust store box, enter the trust store name for the SSL connection.

      For example, enter sapcli.pse.

  11. Click Add.