Help Center/ Cloud Backup and Recovery/ Best Practices (Kuala Lumpur Region)/ Using a Custom Script to Implement Application-Consistent Backup/ Using a Custom Script to Implement Consistent Backup for SAP HANA/ Procedure
Updated on 2022-08-16 GMT+08:00
View PDF
Share

Procedure

  1. Encrypt the HANA password.

    1. Log in to the HANA server and run the cd /home/rdadmin/Agent/bin/ command to go to the Agent directory.
    2. Run the /home/rdadmin/Agent/bin/agentcli encpwd command. The following information is displayed: 
      Enter password:

      Enter the HANA password and press Enter. After the encrypted password is displayed, copy it to the clipboard.

      Run the cd /home/rdadmin/Agent/bin/thirdparty/ebk_user command to go to the custom script directory and run the vi hana_freeze.sh command to open the example freezing script.

  2. The following figure shows an example. You need to set HANA_USER, HANA_PASSWORD, and INSTANCE_NUMBER DB_SID based on your actual conditions, where HANA_PASSWORD should be the encrypted password obtained in step 1.

    You can also run the sed commands to modify the configuration:

    sed -i 's/^HANA_USER=.*/HANA_USER="XXX"/' hana_freeze.sh hana_unfreeze.sh, where XXX indicates the database username.

    sed -i 's/^HANA_PASSWORD=.*/HANA_PASSWORD="XXX"/' hana_freeze.sh hana_unfreeze.sh, where XXX indicates the password obtained in step 1

    sed -i 's/^INSTANCE_NUMBER=.*/INSTANCE_NUMBER="XXX"/' hana_freeze.sh hana_unfreeze.sh, where XXX indicates the database username

    sed -i 's/^DB_SID=.*/DB_SID="XXX"/' hana_freeze.sh hana_unfreeze.sh, where XXX indicates the database SID

    If you run this command, both the freezing and unfreezing scripts will be modified and therefore step 3 is not needed.

  3. Run the vi hana_unfreeze.sh command to open the example HANA unfreezing script and change the username, password, instance ID, and SID in the script to be consistent with your actual settings.

    The hana_freeze.sh and hana_unfreeze.sh scripts can only be used to freeze and unfreeze databases. If other operations are required, you can add them in the scripts via compilation. For details, see Using a Custom Script to Implement Consistent Backup for Other Linux Applications.

    When freezing the SAP HANA database, you need to freeze the XFS file systems of the data volumes as SAP suggested. Otherwise, data inconsistency may occur. The example script mentioned in this section will query the mount point of the Data volume used by the HANA database and then use the xfs_freeze command to freeze the database.

    If the HANA system does not have an independent partition for saving the data volumes as SAP suggested but stores them in the same partition as the system volume, modify the hana_freeze.sh script by commenting out lines related to xfs_freeze to avoid the freezing of the entire system. However, such operations still could not eliminate data inconsistency.