PowerProtect Data Manager 19.17 SAP HANA User Guide

Content requirements for pre-scripts and post-scripts

The pre-script and post-script content must be in text format with a maximum size of 20 KB. The maximum number of scripts that a post-script server supports is 10,000. A maximum of one pre-script and one post-script can run with a backup on UNIX or Windows.

Each script must return the exit code 0 to indicate success. Other exit codes can depend on the particular script and environment. Ensure that the exit codes and corresponding message strings (if available) are logged in the log file.

The pre-scripts and post-scripts can also perform operations that are based on the input parameters that are specified for the scripts. The following examples show the use of input parameters with a pre-script and post-script.

#!/bin/bash
 
# Declare variables
script_name=$1
operation_type=$2
job_id=$3
backup_level=$4
asset_name=$5
policy_name=$6
os_type=$7
app_type=$8
mdc="MDC"  # Modify this according to your environment
instance="00"  # Modify this according to your environment
hostname="blrv003c140.blr.lab.emc.com"
username="SYSTEM"
password="Admin123"
systemdb="SYSTEMDB"
database_name="JAN"
 
# Execute the first hdbsql command to check the ACTIVE_STATUS of the JAN database
output=$(/usr/sap/$mdc/HDB$instance/exe/hdbsql -n $hostname -i $instance -u $username -p $password -d $systemdb -x "SELECT ACTIVE_STATUS FROM M_DATABASES WHERE DATABASE_NAME='$database_name';")
 
# Check if the output contains "YES"
if [[ $output == *"YES"* ]]; then
    echo "The $database_name database is already active."
    exit 0
else
    echo "The $database_name database is not active. Starting it now..."
    # Execute the second hdbsql command to start the JAN database
    /usr/sap/$mdc/HDB$instance/exe/hdbsql -n $hostname -i $instance -u $username -p $password -d $systemdb -x "ALTER SYSTEM START DATABASE $database_name;"
fi

#!/bin/bash
# Input parameters
script_name=$1
operation_type=$2
job_id=$3
backup_level=$4
asset_name=$5
policy_name=$6
os_type=$7
app_type=$8
mdc="MDC"  # Modify this according to your environment
instance="00"  # Modify this according to your environment
hostname="blrv003c140.blr.lab.emc.com"
username="SYSTEM"
password="Admin123"
systemdb="SYSTEMDB"
database_name="JAN"
 
# Execute the first hdbsql command to check the ACTIVE_STATUS of the JAN database
output=$(/usr/sap/$mdc/HDB$instance/exe/hdbsql -n $hostname -i $instance -u $username -p $password -d $systemdb -x "SELECT ACTIVE_STATUS FROM M_DATABASES WHERE DATABASE_NAME='$database_name';")
 
# Check if the output contains "YES"
if [[ $output == *"YES"* ]]; then
    echo "The $database_name database is active."
	# Execute the second hdbsql command to stop the JAN database
    /usr/sap/$mdc/HDB$instance/exe/hdbsql -n $hostname -i $instance -u $username -p $password -d $systemdb -x "ALTER SYSTEM STOP DATABASE $database_name;"

else
    echo "The $database_name database is not active."
	exit 0
fi