Source:SAP ERP with Oracle

From SEPsesam
Revision as of 10:32, 21 January 2019 by Sta (talk | contribs) (Corrected as proposed by MA.)
Other languages:

Copyright © SEP AG 1999-2024. All rights reserved.

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.

Docs latest icon.png Welcome to the latest SEP sesam documentation version 4.4.3/4.4.3 Grolar. For previous documentation version(s), check SAP ERP archive.


Overview

SEP sesam manages the backup media during the backup of the SAP Oracle database. This means that the SAP BR*Tools have the complete control over the backup and restore processes. SEP sesam provides its functions for storage and data storage on any medium, depending on the backup media and a concept. For more information about the backup structure, see SAP documentation about the External Backup Programs.

Requirements

To ensure error-free operation of SEP sesam and improve performance, make sure that the following conditions are met:

  • SEP sesam Server v. 4.4.3 or higher. Check Hardware requirements for SEP sesam Server.
  • Install the SAP ERP or NetWeawer on Oracle database v. ≥ 7.x (with full functionality).
  • Install the SEP sesam Client package on the SAP ERP or NetWeaver server. You can download it from SEP Download Center. The installation procedure is slightly different depending on the operating system type (Unix or Windows). For details on OS specific installation, see SEP sesam Quick Install Guide.
  • Set the following environment variables for the SAP Oracle database:
    • ORACLE_SID
    • ORACLE_HOME
    • SAPDATA_HOME

Installing SEP sesam Oracle module on SAP ERP or NetWeaver server

Before proceeding, make sure that the requirements above are met.

On Unix

Once you have downloaded your SEP sesam Linux Client on the SAP ERP or NetWeaver server, proceed as follows:

  1. Unpack the tar-archive into a temporary directory. The archive contains the following files:
    • backint
    • init.utl
  2. Copy the backint file into the Oracle program files folder /usr/sap/<ORACLE_SID>/SYS/exe/run. If the backint file already exists, rename it first. This file has to be executable for the Oracle user.
  3. Check if the program sbc_com_interface is executable for the Oracle user in the directory <SESAM_BIN>/bin/sesam.
  4. Copy the file init.utl to $ORACLE HOME/dbs/init<ORACLE_SID>.utl for the Oracle database.

On Windows

Once you have downloaded your SEP sesam Windows Client on the SAP ERP or NetWeaver server, proceed as follows:

  1. Copy the backint.exe file which is already included in the SEP sesam installation package for Windows into the Oracle program directory <SAP_MNT>/%ORACLE SID%/SYS/exe/run. If the backint.exe file already exists, rename it first.
  2. Copy the file init.utl to %ORACLE_HOME%\databases\init%ORACLE SID%.utl.
  3. Create the directory %ORACLE_HOME%\saptrace, e.g., %SAPDATA_HOME%\saptrace.
  4. Make sure that you have the admin rights and/or the explicit SeSecurityPrivilege right to use the BR*Tools. For details, see Oracle Troubleshooting.

Configuration on SEP sesam Server

After you have installed the Oracle module on the SAP ERP or NetWeaver server, proceed as follows:

  1. Configure your SAP database server (ERP or NetWeaver) as a SEP sesam client by adding it to the SEP sesam environment: Main selection -> Components -> Topology -> New client -> add your SAP ERP or NetWeaver client. For details, see Configuring Clients.
  2. Run a test Path backup manually to ensure that the backups work.
  3. Additionally, you have to create at least one backup task with the NetWeaver task type. As a source, you have to enter the Oracle SID, e.g., CER, as shown in the screenshot below. For details, see Creating a Backup Task.
  4. NetWeaver bck task.jpg
    Information sign.png Note
    This task cannot be used for regular path backups. It is recommended that you configure more dedicated tasks, e.g., to distinguish database backups from archive log backups. Which data is actually backed up depends on the respective SAP database backup call.

Configuration on the SEP sesam SAP ERP or NetWeaver client

In order for SAP ERP (or NetWeaver) to be able to use the backint interface, you have to change the following entries for the Oracle database in the SAP init<ORACLE_SID>.sap profile file:

backup_dev_type= util_file #configure backup device type
util_par_file= $ORACLE HOME/dbs/init<ORACLE SID>.utl

You can create and use several SAP ERP or NetWeaver profiles for backup or restore. You can also set various util_par_file parameters for these profiles. By setting them, you can use, for example, different SEP sesam drives for different backup levels.

Set the following parameters in the util_par_file (e.g., $ORACLE HOME/dbs/ini<ORACLE SID>.utl):

SESAM_SERVER = <SEP_sesam_Server>
The name of the SEP sesam Server.
SESAM_JOB = <SEP_sesam_SAP_client_task>
The name of the backup task which you have configured before. For details, see section above Configuration on SEP sesam Server.
SESAM_DRIVE = <SEP_sesam_drive_number>
The number of the SEP sesam drive that you want to use for backup.
SESAM_POOL = <SEP_sesam_media_pool>
The name of the SEP sesam media pool that you want to use for backup.

Optionally, set the additional parameters:

SBC = <SEP_sesam_path>
Full path of the SEP sesam backup program. Only required if you use the standard sbc.
PORT = <SEP_sesam_Server_communication_port>
Only required if the STPD port was changed during the SEP sesam Server installation.
SESAM_TAPESERVER = <tape_server>
IP name of the tape server for backup. By using this entry you can specify the backup net.

SAP ERP and NetWeaver log files on Oracle

The following log files are written by the individual SEP sesam SAP ERP or NetWeaver backup module in the $ORACLE HOME/saptrace, e.g., $SAPDATA HOME/saptrace:

  • backint
  • Name: backint_<ORACLE_SID>.log Max. log levels: 3 (ERROR, WARNING, INFO) Description: Messages of the backint program
  • sbc
  • Name: sbc_<ORACLE_SID>.log Max. log levels: 6 Description: Messages of the SEP sesam backup client init<ORACLE_SID>.utl: SBC TRACE LEVEL (default: 2)
  • sbc_com_interface
  • Name: sbc_com_<ORACLE_SID>.log Max. log levels: 3 (ERROR, WARNING, INFO) Description: Logging of the sbc_com_interface program init<ORACLE_SID>.utl: SBC_COM_TRACE_LEVEL (default: 0)

BR*Tools for SAP ERP or NetWeaver on Oracle database

SAP BR*Tools (brbackup, brarchive, and brrestore) manage and protect the data on your Oracle database. They provide the backint interface which is used to access the SEP sesam Server.

You can invoke BR*Tools calls directly from the command line by executing the relevant command:

brbackup

  • complete offline backup
  • brbackup -d util_file -t offline -m all [-u internal/passwd] [-c]
  • complete online backup
  • brbackup -d util_file_online -t online -m all [-u internal/passwd] [-c]
  • complete online backup with specific or different parameter file
  • brbackup -d util_file_online -t online -m all [-u internal/passwd] [-c] -p F:\sap\oracle\CER\11201\database\initCERsep.sap
  • partial offline backup
  • brbackup -d util_file -t offline -m PSAPSTABI,PSAPPOOLD[,TBLSP3, ...]
  • partial online backup
  • brbackup -d util_file -t online -m PSAPSTABI,PSAPPOOLD[,TBLSP3, ..]
  • partial online backup with a dynamic BEGIN/END BACKUP switch
  • brbackup -d util_file_online -t online -m PSAPSTABI,PSAPPOOLD[,TBLSP3, ..]

brarchive

  • offline redo log files backup
  • brarchive -d util_file -s
  • to copy and delete the backed up offline redo log files and back up the new redo logs
  • brarchive -d util_file -cd

brrestore

  • full restore of the offline backup after a full offline backup
  • brrestore -d util_file -b last -m full
  • full restore of the redo log full online backup after a full online backup (with a dynamic switch)
  • brrestore -d util_file -b last -m all
  • partial restore of the partial offline backup into a different restore directory
  • brrestore d util_file -b <partial_offline_backup_log> -m PSAPSTABI=<restore_directory>
  • restore of the offline redo log files written between the partial offline and partial online backup
  • brrestore -d util_file -a <log nr2>-<log nr5>=<restore_directory>
Information sign.png Note
In some cases the restore of single tablespaces or offline redo logs (partial restore) with the BR*Tools does not execute recovery; instead, it performs restore. In this case, the database cannot be started. To start the database, login as internal user, execute the command shutdown instance, and then startup open recover.

Messages and return codes for BR*Tools

BR*Tools have several return codes. For details on various return codes, see Messages and return codes for BR*Tools.

Note that when executing a remote command with SEP sesam, the SEP sesam program differs only between successful (return code 0) and error (all other return codes) messages. When BR*Tools send return code 1 (which actually means successful with warnings), the remote command is incorrectly treated as error in this case.

To solve this issue, instead of executing the BR*Tools commands adjust the following wrapper script for the relevant BR*Tool (brbackup, brarchive, etc.):

 #!/bin/bash

 <relevant_BR*Tool>
 lastexit=$?

 case $lastexit in
     0)	 echo "STATUS=SUCCESS MSG=<relevant_BR*Tool> exited successfully with exit code $lastexit"
         exit 0
	 ;;
     1)	 echo "STATUS=WARNING MSG=<relevant_BR*Tool> exited successfully with warnings, exit code $lastexit"
            exit 0
         ;;
     *)	 echo "STATUS=ERROR MSG=<relevant_BR*Tool> exited with error, exit code $lastexit"
            exit 1
	 ;;
 esac

NAS/SAN extension for Oracle

For backups in NAS/SAN environments, SEP sesam allows you to store the data to a directly connected NAS/SAN device. This means that the data communication works on the database server and the data transfer works on a dedicated server on which the data stand by in the identical way. Backup-related load (network resp. CPU) will be displaced to the dedicated server. A special license is required for such backup.

You have to configure an additional entry for the remote client from which the data available on NAS/SAN will be backed up in the util_par_file, e.g., $ORACLE_HOME/dbs/ini<ORACLE_SID>.utl:

SESAM_REMOTE_CLIENT=<remote_client>

Known issues

If you have problems, check the Oracle Troubleshooting.

See also

SAP ERP