Zero Downtime Backup of MaxDB database with HP Data Protector

Set the ZDB_ALWAYS_POST_SCRIPT omnirc variable

The omnirc variable file template is found on all data protector clients. This file is a template for Data

Protector agent environment variables. To make a variable active, uncomment the line containing the

variable, remove all leading spaces and set the desired value for the variable as follows:

# <VariableName>=<VariableValue>

By default, if the script corresponding to Stop/quiesce the application fails, then the script

corresponding to Restart the application is not executed. However, if you set the omnirc

variable ZDB_ALWAYS_POST_SCRIPT to 1, the script corresponding to Restart the

application will always be executed.

To set an omnirc variable on the application system, go to <Data_Protector_home>\ to find the

omnirc.TMPL omnirc file template. Scroll down to search for the ZDB_ALWAYS_POST_SCRIPT parameter.

Its default value is 0; set it to 1:

ZDB_ALWAYS_POST_SCRIPT=1

then save the file.

Check the complete Data Protector Session report on the benefit of the omnirc variable,

ZDB_ALWAYS_POST_SCRIPT, on the application server in Appendix C

on page 45.

Configuring the MaxDB-DP integration archive logfile backup

specification

This section explains how to configure a MaxDB-DP backup specification to back up archive logs.

 In the Backup context, expand Backup Specifications, right-click SAP DB Server, and

click Add Backup. This opens the backup specification wizard Create New Backup.

 Accept all other defaults in the template Blank SAP DB Backup, then click OK.

 On the next page, input the application server under Client, and the name of the application

database under Application database. Click Next.

 Select the entire database, which would include Config and Data objects. Click Next.

 On the next page, select a driver/writer. Click Next three times, then click Save as to save the

backup specification.

There is no dedicated MaxDB-DP backup template to backup archive logs, so when you run a

MaxDB backup specification, make sure you select Trans as the backup type, as shown in the

following screen shot:

Figure 16. Types of DP-MaxDB integration backup available