You need to provide Data Protector with the following configuration parameters for the SAP MaxDB instance:
• Username of the SAP MaxDB database user.
• Password of the SAP MaxDB database user.
• Optionally, the SAP MaxDB independent program path parameter To configure an SAP MaxDB instance, use the Data Protector GUI or CLI.
Data Protector then creates the SAP MaxDB instance configuration file on the Cell Manager and verifies the connection to the instance.
TIP: Once the configuration file is created, you can set, retrieve, and list the configuration file parameters using the Data Protector util_cmd command. For details, see the util_cmd man page.
To configure an SAP MaxDB instance, use the Data Protector GUI or CLI.
Before you begin
• Ensure that the SAP MaxDB instance is online.
Using the Data Protector GUI
1. In the Context List, click Backup.
2. In the Scoping Pane, expand Backup Specifications, right-click SAP DB Server, and click Add Backup.
3. In the Create New Backup dialog box, select the Blank SAPDB Backup template. Click OK.
4. In Client, select the SAP MaxDB Server system. In a cluster environment, select the virtual server.
In Application database, type the SAP MaxDB instance name.
For information on the User and group/domain options, press F1.
Figure 44 Specifying an SAP MaxDB instance
Click Next.
5. In the Configure SAP DB dialog box, specify the SAP DB independent program path parameter.
This parameter is the independent program path directory specified during the installation of the SAP MaxDB application. To automatically detect the directory, leave the Auto-detect option selected.
Under Connection, type the username and password of the SAP MaxDB database user as described in“Configuring SAP MaxDB users” (page 147).
Figure 45 SAP MaxDB configuration
Click OK.
6. The SAP MaxDB instance is configured. Exit the GUI or proceed with creating the backup specification atStep 3.
Using the Data Protector CLI
UNIX systems only: Log in to the SAP MaxDB Server system as the SAP MaxDB OS user.
From the directory:
Windows systems: Data_Protector_home\bin UNIX systems: /opt/omni/lbin
run:
util_sapdb \[-homedir SAPMaxDB_independent_program_directory] \-config Instance Name username password
Parameter description
SAPMaxDB_independent_program_directory
The SAP MaxDB independent program path parameter. This parameter is the independent program path directory specified during the installation of the SAP MaxDB application on the SAP MaxDB Server.
This parameter is optional. If it is not specified, the directory is detected automatically.
Instance_Name
The name of the SAP MaxDB instance to be configured.
username
The username of the SAP MaxDB database user created or identified as described in
“Configuring SAP MaxDB users” (page 147).
password
The password of the SAP MaxDB database user created or identified as described in
“Configuring SAP MaxDB users” (page 147).
NOTE: The username and the SAP MaxDB independent program path parameter must not contain the single quote character (‘).
The message *RETVAL*0 indicates successful configuration.
Example
To configure the instance sapmaxdb_inst by specifying the database user sapmaxdb_user with the password sapmaxdb_pass, and the SAP MaxDB independent program path
/opt/sapdb/indep_prog(UNIX) or c:\program files\sapdb\indep_prog (Windows), run:
Windows systems:
util_sapdb -homedir "SAPDB_independent_program_directory" -config sapdb_inst sapdb_user sapdb_pass
UNIX systems:
util_sapdb -homedir SAPDB_independent_program_directory/indep_prog -config sapdb_inst sapdb_user sapdb_pass
TIP: To change the configuration parameters, run the same command using new values.
Handling errors
If an error occurs, the error number is displayed in the form
*RETVAL*error_number.
UNIX systems only: To obtain an error description, from the directory:
/opt/omni/lbin run:
omnigetmsg 12 Error_number
Checking the configuration
Check the configuration of an SAP MaxDB instance after you have created at least one backup specification for the SAP MaxDB instance. Use the Data Protector GUI or CLI.
Using the Data Protector GUI
1. In the Context List, select Backup.
2. In the Scoping Pane, expand Backup Specifications and then SAP DB Server. Click the backup specification to display the SAP MaxDB instance to be checked.
3. Right-click the SAP MaxDB instance and click Check configuration.
Using the Data Protector CLI
UNIX systems only: Log in to the SAP MaxDB Server system as the SAP MaxDB OS user.
From the directory:
Windows systems: Data_Protector_home\bin UNIX systems: /opt/omni/lbin
run:
util_sapdb -chkconf Instance_Name
where Instance_Name is the name if the SAP MaxDB instance.
A successful configuration check displays the message *RETVAL*0.
Backup
The integration provides online database backups of different types. What is backed up depends on which objects and backup type you select. SeeTable 17 (page 151).
Table 17 What is backed up
SAP MaxDB backup mode
Trans Diff
Full
archive logs diff on data
data Data
GUI selection
configuration configuration
configuration Configuration
archive logs + configuration diff on data + configuration
data + configuration Instance
Creating backup specifications
Create a backup specification using the Data Protector Manager.
1. In the Context List, click Backup.
2. In the Scoping Pane, expand Backup Specifications, right-click SAP DB Server, and click Add Backup.
3. In the Create New Backup dialog box, select the Blank SAPDB Backup template. Click OK.
4. In Client, select the SAP MaxDB Server system. In a cluster environment, select the virtual server.
In Application database, type the SAP MaxDB instance name.
For information on the User and group/domain options, press F1.
Click Next.
5. If the SAP MaxDB instance is not configured yet for use with Data Protector, the Configure SAP DB dialog box is displayed. Configure it as described in“Configuring SAP MaxDB instances” (page 147).
6. Select the SAP MaxDB objects you want to back up.
IMPORTANT: To back up SAP MaxDB archive logs, select the Data item. The archive log backup is then triggered by selecting the Trans backup type when scheduling the backup or running the backup interactively.
Figure 46 Selecting SAP MaxDB objects
7. Select devices to use for the backup.
To specify device options, right-click the device and click Properties. Specify the device Concurrency, media pool, and preallocation policy.
Click Next.
8. Set backup options. For information on application-specific options (Figure 47 (page 152)), seeTable 18 (page 153).
Click Next.
Figure 47 Application-specific options
9. Optionally, schedule the backup. See“Scheduling backup specifications” (page 153).
10. Save the backup specification, specifying a name and a backup specification group.
TIP: Save the backup specifications in the group SAP DB Integration.
TIP: Preview your backup specification before using it for real. See“Previewing backup sessions”
(page 154).
Table 18 SAP MaxDB backup options
Description Option
Specifies the SAP MaxDB database mode during backup (Admin or Online).
If this option is OFF, the database remains in the current mode.
Change database state
Specifies whether to keep (ON) or delete (OFF) archive logs on the SAP MaxDB Server after the backup has finished.
Keep archive logs
Specifies the number of SAP MaxDB media created on the SAP MaxDB Server and consequently the number of SAP MaxDB backup data streams.
Parallelism
The value must be equal to or lower than:
• The SAP MaxDB MAXBACKUPDEVS parameter.
• The sum of concurrency values of all backup devices selected in the backup specification.
For more information on the Data Protector Concurrency option, see the online Help index: “concurrency“.
Default value: 1.
Maximum value: 32.
Recommended value: the number of SAP MaxDB data volumes to be backed up.
Modifying backup specifications
To modify your backup specification, click its name in the Scoping Pane of the Backup context, then click the appropriate tab, and apply the changes.
Scheduling backup specifications
You can run unattended backups at specific times or periodically. For details on scheduling, see the online Help index: “scheduled backups”.
Scheduling example
To back up SAP MaxDB objects at 8:00, 13:00, and 18:00 during week days:
1. In the Schedule property page, select the starting date in the calendar and click Add to open the Schedule Backup dialog box.
2. Under Recurring, select Weekly. Under Time options, select 8:00. Under Recurring Options, select Mon, Tue, Wed, Thu, and Fri. SeeFigure 48 (page 154).
Click OK.
3. RepeatStep 1andStep 2to schedule backups at 13:00 and 18:00.
4. Click Apply to save the changes.
Figure 48 Scheduling the backup specification
Previewing backup sessions
Preview the backup session using the Data Protector GUI or CLI to test it.
This interactive test does not back up any data. However, as a result of this test, the following file is created on the SAP MaxDB Server system:
Windows systems:
Data_Protector_home\tmp\Backup_Specification_Name_TEST_FILE UNIX systems:
/var/opt/omni/tmp/Backup_Specification_Name_TEST_FILE Delete the file after the test.
Using the Data Protector GUI
1. In the Context List, click Backup.
2. In the Scoping Pane, expand Backup Specifications and then SAP DB Server. Right-click the backup specification you want to preview and click Preview Backup.
3. Specify the Backup type and Network load. Click OK.
The message Session completed successfully is displayed at the end of a successful preview.
Using the Data Protector CLI From the directory:
Windows systems: Data_Protector_home\bin HP-UX, Solaris, and Linux systems: /opt/omni/bin/
Other UNIX systems: /usr/omni/bin/
run:
omnib -sapdb_list backup_specification_name -test_bar What happens during the preview?
2. Data Protector tests the Data Protector part of the configuration. The following are tested:
• Communication between the SAP MaxDB instance and Data Protector
• The syntax of the backup specification
• If devices are correctly specified
• If the necessary media are in the devices
Starting backup sessions
Interactive backups are run on demand. They are useful for urgent backups or restarting failed backups.
NOTE: If the backup you want to perform is the first backup after the restore, you must select the full backup type.
Backup methods
Start a backup of the SAP MaxDB objects selected in the backup specification in any of the following ways:
• Use the Data Protector GUI.
• Use the Data Protector CLI.
• Use the SAP MaxDB utilities.
Using the Data Protector GUI
1. In the Context List, click Backup.
2. In the Scoping Pane, expand Backup Specifications, and then SAP DB Integration. Right-click the backup specification you want to use and click Start Backup.
3. Select the Backup type and Network load. Click OK.
The message Session completed successfully is displayed at the end of a successful backup session.
Using the Data Protector CLI From the directory:
Windows systems: Data_Protector_home\bin HP-UX, Solaris, and Linux systems: /opt/omni/bin/
Other UNIX systems: /usr/omni/bin/
run:
omnib -sapdb_list ListName [-barmode sapdbmode] [list_options] [-preview]
ListNameis the name of the backup specification.
sapdbmodespecifies the backup type. You can select full, diff, or trans.
For List_options, see the omnib man page.
Example
To start a full backup using an existing SAP MaxDB backup specification called TEST, and to set data protection to 10 weeks, run:
omnib -sapdb_list TEST -barmode full -protect weeks 10 Using SAP MaxDB utilities
For a description of the variables listed below, seeParameter description.
1. Create the bsi_env file on the SAP MaxDB Server system.
UNIX systems only: Give the SAP MaxDB OS user read permission for this file.
The file must contain the following lines:
Windows systems:
BACKINT Data_Protector_home\bin\sapdb_backint INPUT Data_Protector_home\tmp\inst_name.bsi_in OUTPUT Data_Protector_home\tmp\inst_name.bsi_out ERROROUTPUT Data_Protector_home\tmp\inst_name.bsi_err PARAMETERFILE name_of_backup_spec
TIMEOUT_SUCCESS 60 TIMEOUT_FAILURE 30 UNIX systems:
BACKINT /opt/omni/bin/sapdb_backint INPUT /var/opt/omni/tmp/inst_name.bsi_in OUTPUT /var/opt/omni/tmp/inst_name.bsi_out ERROROUTPUT /var/opt/omni/tmp/inst_name.bsi_err PARAMETERFILE name_of_backup_spec
TIMEOUT_SUCCESS 60 TIMEOUT_FAILURE 30
2. Log in to the SAP MaxDB database manager as the SAP MaxDB database user by running:
dbmcli -d inst_name -u username,password
3. In the SAP MaxDB database manager, register the location of the bsi_env file created in Step 1of this procedure by running:
Windows systems:
dbm_configset -raw BSI_ENV location\inst_name.bsi_env UNIX systems:
dbm_configset -raw BSI_ENV location/inst_name.bsi_env
4. Create SAP MaxDB media, grouping them under the same name (media_group_name).
The number of created media should equal the parallelism you plan to use for backup. To create a medium medium_name, run the following command, depending on the SAP MaxDB version:
• For SAP MaxDB version 7.6:
medium_put media_group_name/medium_name pipe_name type backup_type [size [block_size [overwrite [autoloader [os_command
[tool_type]]]]]]
• For other SAP MaxDB versions:
medium_put media_group_name/medium_name pipe_name medium_type backup_type
backup_typecan be one of the following:
• DATAfor full backup
• PAGES for differential backup
• LOGfor log backup
tool_typemust be the following:
• "BACK"for backup with Backint for SAP MaxDB
IMPORTANT: When creating SAP MaxDB media for the purpose of a Data Protector backup and restore, the media group name must begin with the "BACK" string.
Example
The commands below create two media and two pipes (parallelism = 2) in the media group BACKDP-Data[2].
Windows systems, SAP MaxDB version 7.6:
medium_put BACKDP-Data[2]/1 \
\\.\Pipe\inst_name.BACKDP_Data[2].1 PIPE DATA 0 8 \ NO NO \" \" "BACK"
medium_put BACKDP-Data[2]/2 \
\\.\Pipe\inst_name.BACKDP_Data[2].2 PIPE DATA 0 8 \ NO NO \" \" "BACK"
UNIX systems, SAP MaxDB version 7.6:
medium_put BACKDP-Data[2]/1 \
/var/opt/omni/tmp/inst_name.BACKDP_Data[2].1 PIPE \ DATA 0 8 NO NO \" \" "BACK"
medium_put BACKDP-Data[2]/2 \
/var/opt/omni/tmp/inst_name.BACKDP_Data[2].2 PIPE \ DATA 0 8 NO NO \" \" "BACK"
Windows systems, other SAP MaxDB versions:
medium_put BACKDP-Data[2]/1 \
\\.\Pipe\inst_name.BACKDP_Data[2].1 PIPE DATA medium_put BACKDP-Data[2]/2 \
\\.\Pipe\inst_name.BACKDP_Data[2].2 PIPE DATA UNIX systems, other SAP MaxDB versions:
medium_put BACKDP-Data[2]/1 \
/var/opt/omni/tmp/inst_name.BACKDP_Data[2].1 PIPE DATA medium_put BACKDP-Data[2]/2 \
/var/opt/omni/tmp/inst_name.BACKDP_Data[2].2 PIPE DATA 5. Start the SAP MaxDB utility session by running:
util_connect
6. Start the backup. The following exemplary command starts the full backup for the media created inStep 4of this procedure:
backup_start BACKDP-Data[2] DATA
7. The progress of the session is displayed in the Data Protector Monitor context. For more information, see“Monitoring sessions” (page 169).
Parameter description
inst_name Name of the instance to be backed up.
name_of_backup_spec Name of the Data Protector backup specification to be used for backup.
username,password Connection string for the SAP MaxDB database user.
location Location of the bsi_env file.
media_group_name Name of the SAP MaxDB media group.
medium_name Name of the SAP MaxDB medium.
pipe_name Name of the SAP MaxDB pipe.
medium_type Type of the SAP MaxDB medium.