sepusa.com | ONE network-wide backup solution

(C)SEP AG

Any form of reproduction of the contents or parts of this manual is allowed only with the express written permission from SEP AG. When compiling and designing user documentation SEP AG uses great diligence and attempts to deliver accurate and correct information. However, SEP AG cannot issue a guarantee for the contents of this manual.

1 Installation for SAP R/3 on MaxDB
- 1.1 Installation for SAP R/3 on MaxDB in UNIX
- 1.2 Installation for SAP R/3 on MaxDB in Windows
2 Configuration on the SEPsesam Server
3 Configuration on the Sesam SAP/R3 MaxDB client
4 Log Files SAP R/3 on MaxDB
- 4.1 BACKINT, SBC and SBC_COM_INTERFACE
- 4.2 DBMCLI
5 dbmcli calls for SAP/R3 MaxDB

Installation for SAP R/3 on MaxDB

Prerequisite for the installation of the Sesam SAP/R3 MaxDB Backup Module

Installed Database SAP/R3 with MaxDB Version 6.2 i.e. 7.2.5.

Installation for SAP R/3 on MaxDB in UNIX

1. The regular SEP sesam backup client for UNIX has to be installed on the SAP R/3 server

2. Unpack the tar-archive into a temporary directory. The archive contains the following files:

backint_sapdb
backint_sapdb.utl
bsi.env

3. Copy the file backint_sapdb into the <SESAM_ROOT>/bin/sesam directory. Normally root-rights are needed for this. You can also use a different directory. The configuration has to be adjusted accordingly. This file must be executable for the MaxDB SAP R/3 user.

4. Check if the programs sbc and sbc_com_interface are executable in the directory <SESAM DIR>/bin/sesam for the MaxDB user.

5. Copy the file backint_sapdb.utl into <wrk_directory> of the MaxDB. (e.g. /usr/sapdb/indep_data/wrk/CER if the DBsid of the database is CER).

Installation for SAP R/3 on MaxDB in Windows

1. The SEP sesam backup client for Windows has to be installed on the SAP R/3 server. This already includes the necessary files for the MaxDB.

backint_sapdb.exe
backint_sapdb.utl
bsi.env

2. The program backint_sapdb.exe is located in the directory <SESAM ROOT>\bin\sesam. It can also be copied into a different directory e.g. the bin directory of the Max DB. The configuration must then be adjusted accordingly.

3. Copy the files backint_ sapdb.utl and bsi.env from the directory <SESAM ROOT>/skel/ into the <wrk_ directory> of the MaxDB. (e.g. C:\Program Files\sapdb\indep_data\wrk\CER if the DBsid of the database is CER).

Configuration on the SEPsesam Server

The SAP R/3 server has to be added as a client on the SEP sesam server. Additionally, at least one task with the backup type SAP R/3 has to be created for the SAP R/3 server.You can also configure more tasks e.g. to distinguish database backups from archivelog backups. The entry for source can be chosen freely. What data is actually backed up only depends on the respective SAP R/3 backup call. This task can 't be used for regular backups.

Configuration on the Sesam SAP/R3 MaxDB client

In order for the Max DB to use the sesam backint_sapdb program the following entries have to be adjusted in the profile file (default: <wrk_directory>/bsi.env).

BACKINT <full path of the backint_sapdb program>
INPUT <full path of the input file> This file is used by the MaxDB server to communicate with the backint program.
OUTPUT <full path of the output file> This file is used by the MaxDB server to communicate with the backint program.
ERROROUTPUT <full path of the error file> The error message of the backint program is written ins this file.
PARAMETERFILE <full path of the parameter file that's to be used. In it the sesam specific parameters are adjusted>
CHECK_AVAILABILITY <number>BACKUPS. Number of old backups queried during restore

Example of a bsi.env file:

Several profile files can be created. They are declared to the MaxDB by setting the enrivonment variable BSI ENV.

CHECK_AVAILABILITY

Setting of CHECK_AVAILABILITY is important for restore. If not set SAP R/3 asks Sesam Server about state of all backups ever made, which can take a very long time. By setting CHECK_AVAILABILITY only last <n> backups are requested.
Spelling in the example above is correct: There is no space between the number and BACKUPS.

Example for setting the environment variable BSI ENV :

Different values can be set for PARAMETERFILE in the respective profile files. This way, for example, different media pools can be used.

At least the following entries have to be configured in the parameter file (PARAMETERFILE):

SESAM_SERVER=<Sesam Server>: Name of the SEPsesam Server on which you want to back up.
SESAM_JOB=<Sesam SAP Client Task>: Name of the backup task that's already set up in SEP sesam. You can do that by using the Sesam GUI.
SESAM_DRIVE=<Sesam Drive Number>: Number of the Sesam drive that you want to back up on.
SESAM_POOL=<Sesam Mediapool>: Name of the Sesam mediapool that you want to back up on
SSB_LOGFILE=<Log file name>: Full path of the sesam backint log file>

Further optional configuration parameters:

SBC=<SESAM_PATH>: full path of the sesam backup program. It only has to be set if the standard sbc can not be used.
PORT=<Sesam Server Communication Port>: only necessaey if the STPD port was changed during the installation of the SEP sesam server.
SESAM_TAPESERVER=<Remote device server>: IP-Name of the RDS that you want to back up on. The backup net to be used can be chosen by this entry.

Example of a parameter (.utl) file:

Log Files SAP R/3 on MaxDB

The following log files are written by the individual SAP R/3 Backup modules in the <wrk_ directory> of the MaxDB (e.g. /sapdb/data/wrk/CER or /usr/sapdb/indep_ data/wrk/CER if the DBsid of the database is CER).

BACKINT, SBC and SBC_COM_INTERFACE

The programs backint_sapdb, sbc and sbc_com_interface write in the log file which was set in configuration of the entry SSB LOGFILE in the parameter file. For example /sapdb/data/wrk/CER/backint_CER.log

DBMCLI

The MaxDB program dbmcli writes its log files into the appropriate work directory, e.g. /sapdb/data/wrk/CER/dbm.ebp.

dbmcli calls for SAP/R3 MaxDB

Overall

The backup/restore of the database is done with the MaxDB dbmcli program. You can see the commands in the MaxDB documentation (see http://help.sap.com/search/sap trex.jsp)

Example

Creating three external media for full-, incr- and log-backup. These are pipes that are used to transfer data between the MaxDB and Sesam.

Syntax

OS> dbmcli -d TST -u dbm,dbm -c medium_put BACKData /tmp/sapdb/TST/data PIPE DATA 0 8 YES YES pwd BACK OS> dbmcli -d TST -u dbm,dbm -c medium_put BACKPages /tmp/sapdb/TST/pages PIPE PAGES 0 8 YES YES pwd BACK OS> dbmcli -d TST -u dbm,dbm -c medium_put BACKLog /tmp/sapdb/TST/log PIPE LOG 0 8 YES YES pwd BACK OS> dbmcli -d TST -u dbm,dbm -c medium_getall # print list of defined media

Setting the environment variable BSI ENV

Full backup in cold mode

Full backup in warm mode

Incremental backup

Log Backup

Full Restore

Consistency check of the backup with recover_check

This command responds with an list of executed Sesam savesets. The output is divided by the pipe sign (|), the second parameter includes the external backup ID:

The following example shows a recover check call for the backup type "LOG":

Call:
 dbmcli on CER>recover_check <BACKUPNAME> LOG ExternalBackupID "<BACKUP_ID>" AUTOIGNORE
 
 Example:
 dbmcli on CER>recover_check BACKLog LOG ExternalBackupID "CER CER___6225285526 /tmp/sapdb/CER/log" AUTOIGNORE
 OK
 Returncode              0
 Date                    20091231
 Time                    00110347
 Server                  qslxmax01
 Database                CER
 Kernel Version          Kernel    7.7.06   Build 009-121-202-944
 Pages Transferred       312
 Pages Left              0
 Volumes                 1
 Medianame               BACKLog
 Location                /tmp/sapdb/CER/log
 Errortext
 Label                   LOG_000000001
 Is Consistent
 First LOG Page          0
 Last LOG Page           349
 DB Stamp 1 Date         20091230
 DB Stamp 1 Time         00111532
 DB Stamp 2 Date         20091231
 DB Stamp 2 Time         00104514
 Page Count              291
 Devices Used            1
 Database ID             qslxmax01:CER_20091231_104306
 Max Used Data Page
 Converter Page Count

Retrieved from "http://wiki.sepsoftware.com/wiki/index.php/SAP_R/3_with_MaxDB_EN"

Contents