Configuring NMSAP

Hi,

Looks like SAP is failing to locate the path for that library. Have you set the DIR_LIBRARY variable?

If you google that error yo

u will come up with lots of solutions, but this one seems to the most popular

The environment variable DIR_LIBRARY was needed to satisfy a requirement for SAP's brbackup so that brbackup could find the SAP library - libsapsecu.so.  This variable was added to the environment with the following commands (HP-UX):

      # cd /opt/omni/lbin

      # ./util_cmd_putopts SAP DIR_LIBRARY '/usr/sap//SYS/exe/run' \
      -sublist Environment

The problem is solved by setting the DIR_LIBRARY environment variable via your backup GUI (In this case there is no such GUI):

This is especially important if you use an external scheduler (cron, at or BACKINT scheduler) to start BR*Tools. In that case, this variable must be set in the environment of this scheduler (for example, in an environment file).

Thank you.

Carlos.

Further to add to Carlos, your database is complaining for archivce mode settings. Seems your DB is in no archive mode. If so change it to archivelog mode, before taking onine backup. You can run archive log list command from sql to check the settings and change accordingly.

If you could provide your sap profile and networker util file, we can look at the configuration if the issue still persists.

  thank you for the archive log problem i resolved it .

but my problem of the library persist:

profile file is :

# @(#) $Id: //bas/701_REL/src/ccm/rsbr/initAIX.sap#3 $ SAP

########################################################################

#                                                                      #

# SAP BR*Tools sample profile.                                         #

# The parameter syntax is the same as for init.ora parameters.         #

# Enclose parameter values which consist of more than one symbol in    #

# double quotes.                                                       #

# After any symbol, parameter definition can be continued on the next  #

# line.                                                                #

# A parameter value list should be enclosed in parentheses, the list   #

# items should be delimited by commas.                                 #

# There can be any number of white spaces (blanks, tabs and new lines) #

# between symbols in parameter definition.                             #

# Comment lines must start with a hash character.                      #

#                                                                      #

########################################################################

# backup mode [all | all_data | full | incr | sap_dir | ora_dir

# | all_dir | | | -

# | | ( )]

# default: all

backup_mode = all

# restore mode [all | all_data | full | incr | incr_only | incr_full

# | incr_all | | | -

# | | ( ) | partial | non_db

# redirection with '=' is not supported here - use option '-m' instead

# default: all

restore_mode = all

# backup type [offline | offline_force | offline_standby | offline_split

# | offline_mirror | offline_stop | online | online_cons | online_split

# | online_mirror | online_standby | offstby_split | offstby_mirror

# default: offline

backup_type = offline

# backup device type

# [tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk

# | disk_copy | disk_standby | stage | stage_copy | stage_standby

# | util_file | util_file_online | rman_util | rman_disk | rman_stage

# | rman_prep]

# default: tape

backup_dev_type = util_file_online

# backup root directory [ | ( )]

# default: $SAPDATA_HOME/sapbackup

backup_root_dir = /oracle/PR1/sapbackup

# stage root directory [ | ( )]

# default: value of the backup_root_dir parameter

stage_root_dir = /oracle/PR1/sapbackup

# compression flag [no | yes | hardware | only]

# default: no

compress = no

# compress command

# first $-character is replaced by the source file name

# second $-character is replaced by the target file name

# = .Z

# for compress command the -c option must be set

# recommended setting for brbackup -k only run:

# "compress -b 12 -c $ > $"

# no default

compress_cmd = "compress -c $ > $"

# uncompress command

# first $-character is replaced by the source file name

# second $-character is replaced by the target file name

# = .Z

# for uncompress command the -c option must be set

# no default

uncompress_cmd = "uncompress -c $ > $"

# directory for compression [ | ( )]

# default: value of the backup_root_dir parameter

compress_dir = /oracle/PR1/sapreorg

# brarchive function [save | second_copy | double_save | save_delete

# | second_copy_delete | double_save_delete | copy_save

# | copy_delete_save | delete_saved | delete_copied]

# default: save

archive_function = save

# directory for archive log copies to disk

# default: first value of the backup_root_dir parameter

archive_copy_dir = /oracle/PR1/sapbackup

# directory for archive log copies to stage

# default: first value of the stage_root_dir parameter

archive_stage_dir = /oracle/PR1/sapbackup

# delete archive logs from duplex destination [only | no | yes | check]

# default: only

# archive_dupl_del = only

# new sapdata home directory for disk_copy | disk_standby

# no default

# new_db_home = /oracle/C11

# stage sapdata home directory for stage_copy | stage_standby

# default: value of the new_db_home parameter

# stage_db_home = /oracle/C11

# original sapdata home directory for split mirror disk backup

# no default

# orig_db_home = /oracle/C11

# remote host name

# no default

# remote_host =

# remote user name

# default: current operating system user

# remote_user =

# tape copy command [cpio | cpio_gnu | dd | dd_gnu | rman | rman_gnu

# | rman_dd | rman_dd_gnu]

# default: cpio

tape_copy_cmd = cpio

# disk copy command [copy | copy_gnu | dd | dd_gnu | rman | rman_gnu

# | rman_set | rman_set_gnu | ocopy]

# default: copy

disk_copy_cmd = copy

# stage copy command [rcp | scp | ftp]

# default: rcp

stage_copy_cmd = rcp

# pipe copy command [rsh | ssh]

# default: rsh

pipe_copy_cmd = rsh

# flags for cpio output command

# default: -ovB

cpio_flags = -ovB

# flags for cpio input command

# default: -iuvB

cpio_in_flags = -iuvB

# flags for cpio command for copy of directories to disk

# default: -pdcu

# use flags -pdu for gnu tools

cpio_disk_flags = -pdcu

# flags for dd output command

# default: "obs=16k"

# recommended setting:

# Unix:    "obs=nk bs=nk", example: "obs=64k bs=64k"

# Windows: "bs=nk",        example: "bs=64k"

dd_flags = "obs=64k bs=64k"

# flags for dd input command

# default: "ibs=16k"

# recommended setting:

# Unix:    "ibs=nk bs=nk", example: "ibs=64k bs=64k"

# Windows: "bs=nk",        example: "bs=64k"

dd_in_flags = "ibs=64k bs=64k"

# number of members in RMAN save sets [ 1 | 2 | 3 | 4 | tsp | all ]

# default: 1

saveset_members = 1

# additional parameters for RMAN

# rman_channels and rman_filesperset are only used when rman_util,

# rman_disk or rman_stage

# rman_channels defines the number of parallel sbt channel allocations

# rman_filesperset = 0 means:

# one file per save set - for non-incremental backups

# all files in one save set - for incremental backups

# the others have the same meaning as for native RMAN

# rman_channels = 1

# rman_filesperset = 0

# rman_maxpiecesize = 0   # in KB - former name rman_kbytes

# rman_rate = 0           # in KB - former name rman_readrate

# rman_maxopenfiles = 0

# rman_maxsetsize = 0     # in KB - former name rman_setsize

# additional parameters for RMAN version 8.1

# the parameters have the same meaning as for native RMAN

# rman_diskratio = 0      # deprecated in Oracle 10g

# rman_pool = 0

# rman_copies = 0 | 1 | 2 | 3 | 4 # former name rman_duplex

# rman_proxy = no | yes | only

# special parameters for an external backup library, example:

# rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)"

# rman_send = "''"

# rman_send = ("channel sbt_1 ' ' parms=' '",

#              "channel sbt_2 ' ' parms=' '")

# rman_compress = no | yes

# rman_maxcorrupt = ( | : , ...)

# remote copy-out command (backup_dev_type = pipe)

# $-character is replaced by current device address

# no default

copy_out_cmd = "dd ibs=8k obs=64k of=$"

# remote copy-in command (backup_dev_type = pipe)

# $-character is replaced by current device address

# no default

copy_in_cmd = "dd ibs=64k obs=8k if=$"

# rewind command

# $-character is replaced by current device address

# no default

# operating system dependent, examples:

# HP-UX:   "mt -f $ rew"

# TRU64:   "mt -f $ rewind"

# AIX:     "tctl -f $ rewind"

# Solaris: "mt -f $ rewind"

# Windows: "mt -f $ rewind"

# Linux:   "mt -f $ rewind"

rewind = "tctl -f $ rewind"

# rewind and set offline command

# $-character is replaced by current device address

# default: value of the rewind parameter

# operating system dependent, examples:

# HP-UX:   "mt -f $ offl"

# TRU64:   "mt -f $ offline"

# AIX:     "tctl -f $ offline"

# Solaris: "mt -f $ offline"

# Windows: "mt -f $ offline"

# Linux:   "mt -f $ offline"

rewind_offline = "tctl -f $ offline"

# tape positioning command

# first $-character is replaced by current device address

# second $-character is replaced by number of files to be skipped

# no default

# operating system dependent, examples:

# HP-UX:   "mt -f $ fsf $"

# TRU64:   "mt -f $ fsf $"

# AIX:     "tctl -f $ fsf $"

# Solaris: "mt -f $ fsf $"

# Windows: "mt -f $ fsf $"

# Linux:   "mt -f $ fsf $"

tape_pos_cmd = "tctl -f $ fsf $"

# mount backup volume command in auto loader / juke box

# used if backup_dev_type = tape_box | pipe_box

# no default

# mount_cmd = " $ $ $ [$]"

# dismount backup volume command in auto loader / juke box

# used if backup_dev_type = tape_box | pipe_box

# no default

# dismount_cmd = " $ $ [$]"

# split mirror disks command

# used if backup_type = offline_split | online_split | offline_mirror

# | online_mirror

# no default

# split_cmd = " [$]"

# resynchronize mirror disks command

# used if backup_type = offline_split | online_split | offline_mirror

# | online_mirror

# no default

# resync_cmd = " [$]"

# additional options for SPLITINT interface program

# no default

# split_options = " "

# resynchronize after backup flag [no | yes]

# default: no

# split_resync = no

# pre-split command

# no default

# pre_split_cmd = " "

# post-split command

# no default

# post_split_cmd = " "

# pre-shut command

# no default

# pre_shut_cmd = " "

# post-shut command

# no default

# post_shut_cmd = " "

# volume size in KB = K, MB = M or GB = G (backup device dependent)

# default: 1200M

# recommended values for tape devices without hardware compression:

# 60 m   4 mm  DAT DDS-1 tape:    1200M

# 90 m   4 mm  DAT DDS-1 tape:    1800M

# 120 m  4 mm  DAT DDS-2 tape:    3800M

# 125 m  4 mm  DAT DDS-3 tape:   11000M

# 112 m  8 mm  Video tape:        2000M

# 112 m  8 mm  high density:      4500M

# DLT 2000     10/20 GB:         10000M

# DLT 2000XT   15/30 GB:         15000M

# DLT 4000     20/40 GB:         20000M

# DLT 7000     35/70 GB:         35000M

# recommended values for tape devices with hardware compression:

# 60 m   4 mm  DAT DDS-1 tape:    1000M

# 90 m   4 mm  DAT DDS-1 tape:    1600M

# 120 m  4 mm  DAT DDS-2 tape:    3600M

# 125 m  4 mm  DAT DDS-3 tape:   10000M

# 112 m  8 mm  Video tape:        1800M

# 112 m  8 mm  high density:      4300M

# DLT 2000     10/20 GB:          9000M

# DLT 2000XT   15/30 GB:         14000M

# DLT 4000     20/40 GB:         18000M

# DLT 7000     35/70 GB:         30000M

tape_size = 100G

# volume size in KB = K, MB = M or GB = G used by brarchive

# default: value of the tape_size parameter

# tape_size_arch = 100G

# level of parallel execution

# default: 0 - set to number of backup devices

exec_parallel = 0

# address of backup device without rewind

# [ | ( )]

# no default

# operating system dependent, examples:

# HP-UX:   /dev/rmt/0mn

# TRU64:   /dev/nrmt0h

# AIX:     /dev/rmt0.1

# Solaris: /dev/rmt/0mn

# Windows: /dev/nmt0

# Linux:   /dev/nst0

tape_address = /dev/rmt0.1

# address of backup device without rewind used by brarchive

# default: value of the tape_address parameter

# operating system dependent

# tape_address_arch = /dev/rmt0.1

# address of backup device with rewind

# [ | ( )]

# no default

# operating system dependent, examples:

# HP-UX:   /dev/rmt/0m

# TRU64:   /dev/rmt0h

# AIX:     /dev/rmt0

# Solaris: /dev/rmt/0m

# Windows: /dev/mt0

# Linux:   /dev/st0

tape_address_rew = /dev/rmt0

# address of backup device with rewind used by brarchive

# default: value of the tape_address_rew parameter

# operating system dependent

# tape_address_rew_arch = /dev/rmt0

# address of backup device with control for mount/dismount command

# [ | ( )]

# default: value of the tape_address_rew parameter

# operating system dependent

# tape_address_ctl = /dev/...

# address of backup device with control for mount/dismount command

# used by brarchive

# default: value of the tape_address_rew_arch parameter

# operating system dependent

# tape_address_ctl_arch = /dev/...

# volumes for brarchive

# [ | ( ) | SCRATCH]

# no default

volume_archive = (PR1A01, PR1A02, PR1A03, PR1A04, PR1A05,

                  PR1A06, PR1A07, PR1A08, PR1A09, PR1A10,

                  PR1A11, PR1A12, PR1A13, PR1A14, PR1A15,

                  PR1A16, PR1A17, PR1A18, PR1A19, PR1A20,

                  PR1A21, PR1A22, PR1A23, PR1A24, PR1A25,

                  PR1A26, PR1A27, PR1A28, PR1A29, PR1A30)

# volumes for brbackup

# [ | ( ) | SCRATCH]

# no default

volume_backup = (PR1B01, PR1B02, PR1B03, PR1B04, PR1B05,

                 PR1B06, PR1B07, PR1B08, PR1B09, PR1B10,

                 PR1B11, PR1B12, PR1B13, PR1B14, PR1B15,

                 PR1B16, PR1B17, PR1B18, PR1B19, PR1B20,

                 PR1B21, PR1B22, PR1B23, PR1B24, PR1B25,

                 PR1B26, PR1B27, PR1B28, PR1B29, PR1B30)

# expiration period for backup volumes in days

# default: 30

expir_period = 30

# recommended usages of backup volumes

# default: 100

tape_use_count = 100

# backup utility parameter file

# default: no parameter file

### util_par_file uncommented for NMSAP configuration

util_par_file = /oracle/PR1/102_64/dbs/initPR1.utl

# mount/dismount command parameter file

# default: no parameter file

# mount_par_file = initPR1.mnt

# Oracle connection name to the primary database

# [primary_db = | LOCAL]

# no default

# primary_db =

# Oracle connection name to the standby database

# [standby_db = | LOCAL]

# no default

# standby_db =

# description of parallel instances for Oracle RAC

# parallel_instances = | ( )

#    - [, ...]

#         - : @

#        - Oracle system id for parallel instance

#       - Oracle home for parallel instance

#         - Oracle connection name to parallel instance

# Please include the local instance in the parameter definition!

# default: no parallel instances

# example for initRAC001.sap:

# parallel_instances = (RAC001:/oracle/RAC/920_64@RAC001,

# RAC002:/oracle/RAC/920_64@RAC002, RAC003:/oracle/RAC/920_64@RAC003)

# handling of Oracle RAC database services [no | yes]

# default: no

# db_services = yes

# database owner of objects to be checked

# | ( )

# default: all SAP owners

# check_owner = sapr3

# database objects to be excluded from checks

# all_part | non_sap | [ .]

# | [ .][ ]*[ ] | | ( )

# default: no exclusion, example:

# check_exclude = (SDBAH, SAPR3.SDBAD)

# special database check conditions

# (" : : : :[ ]:[ ]:[ ]", ...)

# check_cond = ( )

# database owner of SDBAH, SDBAD and XDB tables for cleanup

# | ( )

# default: all SAP owners

# cleanup_owner = sapr3

# retention period in days for brarchive log files

# default: 30

# cleanup_brarchive_log = 30

# retention period in days for brbackup log files

# default: 30

# cleanup_brbackup_log = 30

# retention period in days for brconnect log files

# default: 30

# cleanup_brconnect_log = 30

# retention period in days for brrestore log files

# default: 30

# cleanup_brrestore_log = 30

# retention period in days for brrecover log files

# default: 30

# cleanup_brrecover_log = 30

# retention period in days for brspace log files

# default: 30

# cleanup_brspace_log = 30

# retention period in days for archive log files saved on disk

# default: 30

# cleanup_disk_archive = 30

# retention period in days for database files backed up on disk

# default: 30

# cleanup_disk_backup = 30

# retention period in days for brspace export dumps and scripts

# default: 30

# cleanup_exp_dump = 30

# retention period in days for Oracle trace and audit files

# default: 30

# cleanup_ora_trace = 30

# retention period in days for records in SDBAH and SDBAD tables

# default: 100

# cleanup_db_log = 100

# retention period in days for records in XDB tables

# default: 100

# cleanup_xdb_log = 100

# retention period in days for database check messages

# default: 100

# cleanup_check_msg = 100

# database owner of objects to adapt next extents

# | ( )

# default: all SAP owners

# next_owner = sapr3

# database objects to adapt next extents

# all | all_ind | special | [ .]

# | [ .][ ]*[ ] | | ( )

# default: all abjects of selected owners, example:

# next_table = (SDBAH, SAPR3.SDBAD)

# database objects to be excluded from adapting next extents

# all_part | [ .]

# | [ .][ ]*[ ] | | ( )

# default: no exclusion, example:

# next_exclude = (SDBAH, SAPR3.SDBAD)

# database objects to get special next extent size

# all_sel: [/ ] | [ .]

# | [ .] : [/ ]

# | [ .][ ]*[ ]: [/ ]

# | ( )

# default: according to table category, example:

# next_special = (SDBAH:100K, SAPR3.SDBAD:1M/200)

# maximum next extent size

# default: 2 GB - 5 *

# next_max_size = 1G

# maximum number of next extents

# default: 0 - unlimited

# next_limit_count = 300

# database owner of objects to update statistics

# | ( )

# default: all SAP owners

# stats_owner = sapr3

# database objects to update statistics

# all | all_ind | all_part | missing | info_cubes | dbstatc_tab

# | dbstatc_mon | dbstatc_mona | [ .]

# | [ .][ ]*[ ] | | ( )

# | harmful | locked | system_stats | oradict_stats | oradict_tab

# default: all abjects of selected owners, example:

# stats_table = (SDBAH, SAPR3.SDBAD)

# database objects to be excluded from updating statistics

# all_part | info_cubes | [ .]

# | [ .][ ]*[ ] | | ( )

# default: no exclusion, example:

# stats_exclude = (SDBAH, SAPR3.SDBAD)

# method for updating statistics for tables not in DBSTATC

# E | EH | EI | EX | C | CH | CI | CX | A | AH | AI | AX | E= | C= | =H

# | =I | =X | +H | +I

# default: according to internal rules

# stats_method = E

# sample size for updating statistics for tables not in DBSTATC

# P | R

# default: according to internal rules

# stats_sample_size = P10

# number of buckets for updating statistics with histograms

# default: 75

# stats_bucket_count = 75

# threshold for collecting statistics after checking

# | ( [, all_part:

# | info_cubes: | [ .]

# | [ .][ ]*[ ]:

# | : | ])

# default: 50%

# stats_change_threshold = 50

# number of parallel threads for updating statistics

# default: 1

# stats_parallel_degree = 1

# processing time limit in minutes for updating statistics

# default: 0 - no limit

# stats_limit_time = 0

# parameters for calling DBMS_STATS supplied package

# all:R|B[ |A|S|R]:0| A|D

# | all_part:R|B[ |A|S|R]:0| A|D

# | info_cubes:R|B:A|D|0|

# | [ .]

# | [ .][ ]*[ ]:R|B[ |A|S|R]:0| A|D

# | ( ) | NO

# R|B[ |A|S|R]:

# 'R' - row sampling, 'B' - block sampling,

# - histogram buckets count, 'A' - auto buckets count,

# 'S' - skew only, 'R' - repeat

# A|D:

# - dbms_stats parallel degree, '0' - table degree,

# 'A' - auto degree, 'D' - default degree

# default: ALL:R:0

# stats_dbms_stats = ([ALL:R:1,][ .]

# definition of info cube tables

# default | rsnspace_tab | [ .]

# | [ .][ ]*[ ] | ( ) | null

# default: rsnspace_tab

# stats_info_cubes = (/BIC/D*, /BI0/D*, ...)

# special statistics settings

# (

# stats_special = ( )

# recovery type [complete | dbpit | tspit | reset | restore | apply

# | disaster]

# default: complete

# recov_type = complete

# directory for brrecover file copies

# default: $SAPDATA_HOME/sapbackup

# recov_copy_dir = /oracle/PR1/sapbackup

# time period for searching for backups

# 0 - all available backups, >0 - backups from n last days

# default: 30

# recov_interval = 30

# degree of paralelism for applying archive log files

# 0 - use Oracle default parallelism, 1 - serial, >1 - parallel

# default: Oracle default

# recov_degree = 0

# number of lines for scrolling in list menus

# 0 - no scrolling, >0 - scroll n lines

# default: 20

# scroll_lines = 20

# time period for displaying profiles and logs

# 0 - all available logs, >0 - logs from n last days

# default: 30

# show_period = 30

# directory for brspace file copies

# default: $SAPDATA_HOME/sapreorg

# space_copy_dir = /oracle/PR1/sapreorg

# directory for table export dump files

# default: $SAPDATA_HOME/sapreorg

# exp_dump_dir = /oracle/PR1/sapreorg

# database tables for reorganization

# [ .]

# | [ .][ ]%[ ] | ( )

# no default

# reorg_table = (SDBAH, SAPR3.SDBAD)

# database indexes for rebuild

# [ .] | [ .][ ]*[ ]

# | [ .][ ]%[ ] | ( )

# no default

# rebuild_index = (SDBAH~0, SAPR3.SDBAD~0)

# database tables for export

# [ .]

# | [ .][ ]%[ ] | ( )

# no default

# exp_table = (SDBAH, SAPR3.SDBAD)

# database tables for import

#

# no default

# do not specify table owner in the list - use -o|-owner option for this

# imp_table = (SDBAH, SDBAD)

######## added for NMSAP module for networker  #######

util_path=/usr/bin

the utl file is:

###########################################################################

#

# This is the .utl file.

#

# This file contains settings for the NetWorker Module for SAP with

# Oracle (a.k.a. NMSAP).

#

# Note: Comments have a "#" in the first column.

#

###########################################################################

# Default Value: 8

# Valid Values: > 0 integer

# Number of simultaneous savesets/savestreams to send to server.

# Be sure your server and devices are configured to support at least

# as many streams.

#

# parallelism = 8

parallelism = 6

# Default Value: no

# Valid Values: no/yes

# Group saveset by file system

# If set to 'yes', savesets parameter will be ignored

#

# ss_group_by_fs = yes

ss_group_by_fs = FALSE

# Additional configuration options.

# These are optional fields.

#

LIBPATH = /oracle/PR1/102_64/lib:/usr/lib/nsr:/usr/lib:/usr/sap/PR1/SYS/exe/run

NSR_NWPATH = /usr/bin/

hi,

carlos i use IBM AIX and not HP-UX could you tell me how can i do that with IBM AIX 7.1.

util file seem to be a bit short, but perhaps you run out of the copy and paste buffer.  You must put the variable in nsrsapsv.cfg file. It is simple, try brarchive or brbackup from client.  If that works, you know that env variables are wrong somewhere or missing.  Get those from user where it works (oracle user in your case) and set it in nsrsapsv file. HPUX or IBM - it does not matter - it is the same advice and same solution.

Hi,

Can you please tell me where can I set the DIR_LIBRARY variable for Avamar ? I have a parameter set in my data set as DIR_LIBRARY=

/usr/sap/ /SYS/exe/run 

Not sure for Avamar, but you should check this in Avamar forum - here we discussed NMSAP.