Tivoli Data Protection (TDP) SAP HANA Configuration Steps


1) Data Protection for SAP HANA requires the TSM API configuration files dsm.sys and dsm.opt to be configured accordingly. The server stanza in the dsm.sys file that is going to be used for Data Protection for SAP HANA must be created before the following steps can be carried out. If the feature 'passwordaccess generate' is going to be utilized then this line in the dsm.sys should be commented out for the setup process of Data Protection for SAP HANA. The setup process expects the default 'passwordaccess prompt' to be used. After the setup is completed the entry in dsm.sys can be activated again.

2) To configure Data Protection for SAP HANA, use the setup.sh script. This script creates the SAP HANA backup user and sets all necessary environment variables for the SAP HANA administration user SIDadm. SID is the SAP system name of the SAP HANA database instance. To allow unattended operations, the backup user credentials are stored in the SAP HANA keystore called hdbuserstore

3) Before Data Protection for SAP HANA can be used, check the prerequisites & installing procedure for TDP SAP HANA. Then it must be configured using the setup.sh script found under the installation directory. To run the setup.sh script
  • Enter the following command to change to the Data Protection for SAP HANA installation directory
                  cd /opt/tivoli/tsm/tdp_hana
  • Enter the following command to run the Data Protection for SAP HANA configuration script setup.sh as user ID root:
                 ./setup.sh

Also Read: All Tivoli Data Protection (TDP) Installation & Configuration Steps

4) The following Data Protection for SAP HANA configuration files are installed in the Data 
Protection for SAP HANA configuration directory. The default path to this directory is 
/usr/sap/SID/home/tsmconf
  • initSID.utl
  • initSID.bki
  • agent.lic (copy of file in Data Protection for SAP HANA installation directory)

TDP SAP HANA Configuration Steps

During the configuration process for the Data Protection for SAP HANA Backup environment, the following information is requested
  • Please enter the SAP HANA system ID [SID]:
The setup.sh script provides a proposal (marked in [ ]) for the SAP HANA system ID. To accept the proposed value, click the ENTER key.
  • Please enter instance number [00]:
For a typical configuration, the SAP HANA instance number is 00.
  • Please enter password for SYSTEM user:
The SYSTEM user is the SAP HANA database administration user. The password of the SYSTEM user is used internally only within the setup.sh script. The password is not stored by Data Protection for SAP HANA.
  • Please enter user name for BACKUP user:
The Data Protection for SAP HANA setup.sh script uses the SYSTEM user to create a new backup user. This backup user account is used for backup and restore tasks. The privileges BACKUP ADMIN and CATALOG READ are granted to this new user. If the user account exists, the account is not changed.For each SAP HANA node where Data Protection for SAP HANA is installed a dedicated backup user must be used.
  • Please enter password for user Data Protection for SAP HANA backup user:
The Data Protection for SAP HANA backup user and its password is stored in the SAP HANA keystore called hdbuserstore.
  • Please enter path of Data Protection for SAP HANA UTL-file initSID.utl [/usr/sap/SID/home/tsmconf]:
The Data Protection for SAP HANA UTL-file initSID.utl is the configuration file of the product. This file contains the Tivoli Storage Manager configuration parameters like Tivoli Storage Manager  server, Tivoli Storage Manager node, and Tivoli Storage Manager management classes. The file is used by the Data Protection for SAP HANA datamover for sending data to the Tivoli Storage Manager server.
  • Do you want to setup the TSM configuration now [y/n]:
If you know how the Tivoli Storage Manager server is configured, and how the Tivoli Storage Manager node is configured, answer this question with y or Y. When you answer this question with y or Y, you are asked for several Tivoli Storage Manager configuration parameters. Based on the information that is provided, the configuration in the Data Protection for SAP HANA UTL-file is updated.

Also Read: Storage Area Network (SAN) Basic Free Tutorials

If you answer this question with n or N you are required to manually edit the Data Protection for SAP HANA UTL-file initSID.utl after the setup.sh script finishes. You need to change at least the following Tivoli Storage Manager parameters in the server section of this UTL-file:
SERVER                                 server       # Servername, as defined in dsm.sys
ADSMNODE                         NODE      # Tivoli Storage Manager Nodename
BRBACKUPMGTCLASS    MDB        # Mgmt­Classes for database backup
BRARCHIVEMGTCLASS   MLOG     # Mgmt­Classes for redo log backup 
If the question in step 7 was answered with n or N, the following steps are omitted.
  • Please enter the TSM server name as defined in dsm.sys:
The Data Protection for SAP HANA UTL-file initSID.utl parameter SERVER is updated with this Tivoli Storage Manager server name. Data Protection for SAP HANA uses this Tivoli Storage Manager server name to backup and restore data. 
  • Please enter the TSM node name:
The Data Protection for SAP HANA UTL-file initSID.utl parameter ADSMNODE is updated with this Tivoli Storage Manager node name. Data Protection for SAP HANA uses this Tivoli Storage Manager node name on the Tivoli Storage Manager server to backup and restore data. 
  • Please enter the TSM management class for database backups:
The Data Protection for SAP HANA UTL-file initSID.utl parameter BRBACKUPMGTCLASS is updated with this Tivoli Storage Manager management class name. Data Protection for SAP HANA uses this Tivoli Storage Manager management class on the Tivoli Storage Manager node to backup and restore data. 
  • Please enter the TSM management class for log file backups:
The Data Protection for SAP HANA UTL-file initSID.utl parameter BRARCHIVEMGTCLASS is updated with this Tivoli Storage Manager management class name. Data Protection for SAP HANA uses this Tivoli Storage Manager management class on the Tivoli Storage Manager node to backup and restore database redo log files. 
  • To set the password of the Tivoli Storage Manager node, you are prompted for the password. After you enter the password, the password is verified.
Next: Taking backup and restore using TDP SAP HANA 




What Others are Reading Now...

4 Responses to "Tivoli Data Protection (TDP) SAP HANA Configuration Steps"

  1. This blog is very useful which is related to my searches. posted best topics and I have also Sap Hana Admin professional. we provide SAP HANA ADMINISTRATION ONLINE TRAINING

    ReplyDelete

  2. Awesome. Just awesome. This was really something, I had been looking for few days. Too excited to view your other blogs on HANA ADMIN. Thanks a lot for the detail explanation on who can fit where. It helps a lot. we give SAP HANA ADMINISTRATION ONLINE TRAINING who are looking for sap career

    ReplyDelete
  3. You provided valuable information regarding sap modules, Well found it very informative and helpful keep updates
    sap bods online training

    ReplyDelete
  4. I am very happy with the training program in Optimize SQL. They have complete setup and learned

    very well msbi training in hyderabad thanks a lot.

    ReplyDelete