PowerProtect Data Manager 19.17 SAP HANA User Guide

Performing self-service alternate host restore

To enable an alternate host recovery, you must copy the required user configuration file and auto configuration file from the source host to the destination host. If the target asset is in a different protection policy than the source asset, then you must also store the password of the source storage unit in the lockbox on the destination host.

1. Copy the configuration files for the source database.

   /usr/sap/<source_host_SID>/SYS/global/ppdmconfig/<source_host_SID>_<source_host_database>_data_auto.utlto /usr/sap<target_host_SID>SYS/global/ directory.

2. Set the log-level information /usr/sap/<target_host_SID>/SYS/global/<source_host_SID>_<source_host_database>_data_auto.utl.
3. Set the path of the /usr/sap/<target_host_SID>/SYS/global/<source_host_SID>_<source_host_database_data_auto.utl in the Hana Studio for the below parameters:
   • catalog_backup_parameter_file
   • log_backup_parameter_file
   • data_backup_parameter_file
4. If the target asset is in a different protection policy than the source asset, store the password of the source storage unit in the lockbox on the destination host:

   1. To obtain the password of the source storage unit, run the required script from the PowerProtect Data Manager server. You can fetch the MTree pathname details from the source UTL files:

      1. Connect to the PowerProtect Data Manager console as an admin user.
      2. Navigate to the /usr/local/brs/puppet/scripts directory.

      3. Obtain the storage unit password by typing the following command:

         python get_dd_mtree_credential.py MTree-name

         For example:

         python get_dd_mtree_credential.py  mtree1
         ==============PowerProtect DD MTree credential==============
         Full MTree path: /data/col1/mtree1
         User name: user1
         Password: pass1
         ============================================================

   2. Store the source credentials in the lockbox on the destination host:

      1. Create a separate file lockbox_reg.utl.

      2. Add the following lines in the lockbox_reg.utl file:

         [PRIMARY_SYSTEM]
         DDBOOST_USER = <username>
         DEVICE_HOST = <IP-address>
         DEVICE_PATH = /<storage-unit-pathname>

      3. To store the source lockbox password, run the command ddbmadmin -P -z lockbox_reg.utl on the destination host. When prompted for the password, enter the password from step 3a.

      4. To store any additional credentials, such as for secondary storage, modify the lockbox_reg.utl file with the following lines and then run the command ddbmadmin -P -z lockbox_reg.utl again:

         [PRIMARY_SYSTEM]
         DDBOOST_USER = <username2>
         DEVICE_HOST = <IP-address2>
         DEVICE_PATH = /<storage-unit-pathname2>

5. When the configuration files are in place and any required credentials are stored, perform the alternate host recovery.
   NOTE: After the alternate host restore process is complete; unset the path in the Hana Studio for the below paraneters:
   • catalog_backup_parameter_file
   • log_backup_parameter_file
   • data_backup_parameter_file