NetWorker: Configure SAP Oracle Database Client for NMSAP Backup Not Using Wizard

Summary: Client cannot use wizard for configuration if rman_util option is to be used to backup SAP Oracle database with the NMSAP module.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Instructions

Steps performed on the client:

  1. Install NMSAP module on the client as per the NMSAP installation guide and establish an appropriate link to the libnsrnwora.xx library
  2. Update the $SAPDATA_HOME/sapprof/init<SID>.sap file with the following parameters as required (example):
backup_mode = full
restore_mode = all
backup_type = online_cons
backup_dev_type = rman_util
backup_root_dir = $SAPDATA_HOME/sapbackup
stage_root_dir = $SAPDATA_HOME/sapbackup
compress_dir = $SAPDATA_HOME/sapreorg
archive_function = save_delete
archive_copy_dir = $SAPDATA_HOME/sapbackup
archive_stage_dir = $SAPDATA_HOME/sapbackup
util_par_file = /oradata/T00/sapprof/init_oracle_nmsap.utl
util_par_file_arch = /oradata/T00/sapprof/init_oracle_nmsap.utl
util_path = /usr/sbin
util_path_arch = /usr/sbin
rman_channels=2
rman_send=("channel sbt_1 'NSR_ENV=(NSR_SERVER=<server_name>,NSR_CLIENT=<client_name>,NSR_DATA_VOLUME_POOL=<pool>)'", "channel sbt_2 'NSR_ENV=(NSR_SERVER=<server_name>,NSR_CLIENT=<client_name>,NSR_DATA_VOLUME_POOL=<pool>)'")
  1. Test the manual backup using brbackup command (it should backup the full database):
brbackup -c forc -u backupuser
  1. Create a nsrsapsv_<SID>.cfg file and encrypt it with the password using nsrsapadm program (see below). This file is to be used for a scheduled backup (example):
vi $SAPDATA_HOME/sapprof/nsrsapsv_<SID>.cfg

 BR_EXEC=brbackup
 ORACLE_HOME=/oradata/<SID>/12201
 SAPDATA_HOME=/oradata/<SID>
 SAP_BIN=/usr/sap/<SID>/SYS/exe/run
 SAPBACKUP=/oradata/<SID>/sapbackup
 ORACLE_SID=<SID>
NLS_LANG = AMERICAN_AMERICA.US7ASCII
 NSR_SAP_USING_RMAN_OPTION=TRUE
LD_LIBRARY_PATH = /oradata/<SID>/12201/lib

ORACLE_USR_PASSWD="    $1$XHWTSZHABPKWGCVO$49f9f2fd5252e16fb1e73d70a0a901b67677e8bb11f8c367e66e1a03b8242048"
  1. Create the file system client resource of the SAP Oracle host in NMC with save set and Backup command and the Protection group:
save set: backint:<SID>
Backup command:  nsrsapsv -f /oracle/<SID>/sapprof/nsrsapsv_<SID>.cfg

Select the appropriate Protection Group from the Protection group list.

  1. Test the backup by running it from NMC.


The following command is to encrypt the password using nsrsapadm program as below:

/usr/sbin/nsrsapadm -P oracle -z /oracle/<SID>/sapprof/nsrsapsv_<SID>.cfg

Products

NetWorker Module for SAP
Article Properties
Article Number: 000342034
Article Type: How To
Last Modified: 30 Jul 2025
Version:  1
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.