4 Operator

 • 

14.4K Posts

July 18th, 2013 11:00

You need to check in /nsr/applogs backint log for details.  Eventually place debug in util file.

4 Operator

 • 

14.4K Posts

July 18th, 2013 06:00

Remove NSR_NWPATH.  Not sure why people use wizards instead of reading documentation

1 Rookie

 • 

44 Posts

July 18th, 2013 10:00

hi, when i as your said, manual configuration backup.

the following content of configuration nsrsapsv.cfg

#
# This is the sample nsrsapsv.cfg file.
#
# This file contains settings for the NetWorker Module for SAP with
# Oracle (a.k.a. NMSAP) used during scheduled backups.
#
# Note: Comments have a "#" in the first column.
#
###########################################################################


# BR_EXEC specifies the command that nsrsapsv will execute. The BR_EXEC
# parameter can be any valid brbackup or brarchive command, including
# any command line options. If a username and password are required to
# execute the command, they should be encrypted into this file using the
# nsrsapsv -c command, rather than using the -u option in this parameter.
# For more information about when the username and password are required,
# and how to encrypt them into this file, see the EMC NetWorker Module
# for SAP with Oracle Administrator's Guide.
# This is a required parameter.
#
# BR_EXEC=brbackup
BR_EXEC=brbackup


# ORACLE_HOME specifies
# value of ORACLE_HOME for the Oracle instance that will be backed up.
# This is a required parameter.
#
# ORACLE_HOME=/export/home/oracle/product/8.1.5
ORACLE_HOME=/oracle/ZEP/102_64


# SAPDATA_HOME should be set to the value of the
# root directory of the SAP database files.
# This is a required parameter.
#
# SAPDATA_HOME=d:\orant\CER\
SAPDATA_HOME=/oracle/ZEP/


# NLS_LANG is a required environment variable.  The format should be
# LANGUAGE_TERRITORY.CHARACTERSET
# Refer to your Oracle documentation for more information of this variable.
#
# NLS_LANG = AMERICAN_AMERICA.US7ASCII
NLS_LANG = AMERICAN_AMERICA.UTF8


# SAP_BIN specifies the path to where the BrTools executables are installed.
# This should also be where the backint binary resides.  This path will be
# added to the PATH environment variable so that the BrTools and backint
# executables can be found.
# This is a required parameter.
#
# SAP_BIN=/usr/sap/SAP/SYS/exe/run
SAP_BIN=/usr/sap/ZEP/SYS/exe/run


# SAPBACKUP specifies the temporary directory for the backup logs should go.
# BrTools and backint both use this directory to store their temporary log
# files.  On UNIX systems, the default for this is $ORACLE_HOME/sapbackup.
# On Windows, this is a required parameter.  On UNIX, this parameter is only
# required if the default is not $ORACLE_HOME/sapbackup.
#
# SAPBACKUP=d:\orant\CER\sapbackup
SAPBACKUP=/oracle/ZEP/sapbackup

# ORACLE_SID specifies the SID of the Oracle instances to be backed up.  If
# this parameter is specified here, backint wil use the value of this
# parameter for the Oracle SID.  If this parameter is not specifed here, the
# Oracle SID will be obtained from the save set name you entered when this
# client was configured in the NetWorker software.  For example, if you
# entered backint:SAP:online_backup for the save set name during client
# configuration and you do not specify a value for ORACLE_SID in this file,
# then SAP will be used for the Oracle SID This parameter is only required
# if you want to override the one specified by the save set name.
#
# ORACLE_SID=SAP
ORACLE_SID=ZEP

# If RMAN is used for backing up database files, set NSR_SAP_USING_RMAN_OPTION
# to 'TRUE' by uncommenting the following line.
#
# NSR_SAP_USING_RMAN_OPTION=TRUE


# ORACLE_BIN specifies where the Oracle binaries are located.  This path will
# be appended to the PATH environment variable so that all Oracle binaries can
# be found if needed.  The default for this will be $ORACLE_HOME/bin.
# This parameter is only required if the Oracle binaries are not located in
# $ORACLE_HOME/bin.
#
# ORACLE_BIN


# SAPARCH, SAPREORG, SAPTRACE, and SAPCHECK are SAP environment variables that
# are normally set in your SAP environment on Windows platforms.  These
# environment variables may be required for brbackup to run properly on Windows.
# If these variables are not set on your Windows system, or if they need to be
# overridden, they should be set here.
#
# SAPARCH=d:\orant\CER\saparch
# SAPREORG=d:\orant\CER\sapreorg
# SAPTRACE=d:\orant\CER\saptrace
# SAPCHECK=d:\orant\cer\sapcheck


# PATH is used to add more search paths to the environment.  Anything specified
# here will be appended to the PATH environment variable.  You may specify as
# many PATH variables as you desire.  You may specify multiple search paths,
# using either one of the following methods:
# This is an optional parameter.
#
# PATH=/export/home/dir1:/export/home/dir2:/home/dir1/dir2/dir3
# or
# PATH=/export/home/dir1
# PATH=/export/home/dir2
# PATH=/home/dir1/dir2/dir3


# Any _path= pair.  This parameter can be used to append values
# to an environment variable named _path (for example, LD_LIBRARY_PATH).
# If an environment variable with this name already exists, then the value
# listed here will be appended to the existing value for this environment
# variable. If an environment variable with this name does not exist, it will
# be created.
# This is an optional parameter.
#
# LD_LIBRARY_PATH=/export/home/oracle/product/8.1.5/lib:/usr/openwin/lib


# Any = pair.  This parameter can be used to add any environment
# variable named .  You may specify any name=value pair.  If the
# environment variable specified by name already exists, then it will be
# overwritten. For example:
#
# BR_TRACE=1
#
# will set the BR_TRACE environment variable equal to 1 in your environment,
# which will instruct brbackup or brarchive to print out additional trace
# information.  This will override any other setting for BR_TRACE.
# This is an optional parameter.


# NSR_SAP_SECURE_RUN Set to "TRUE" or "FALSE". This is a Unix only parameter. It may be set
# under Windows but it has no effect.
#
# If an encrypted username/password is used, the unencrypted password used to
# run brbackup or brarchive may be visible in a ps listing while the backup is
# running. Setting this parameter to "TRUE" will suppress this behaviour and
# increase password security.
#
# NSR_SAP_SECURE_RUN=TRUE
#
# This is an optional parameter.

OS_USR_PASSWD=znhr(qzry536<("

ORACLE_USR_PASSWD=mswYehactw)b{rWcfel

but when i to perform a backup group , shown  the following messages:

/oracle/ZEP/origlogA/cntrl/cntrlZEP.dbf         22102016    0      3342337  NOLINK  FILE
/oracle/ZEP/origlogB/cntrl/cntrlZEP.dbf         22102016    0      3342338  NOLINK  FILE
/oracle/ZEP/sapdata1/cntrl/cntrlZEP.dbf         22102016    0      3407875  NOLINK  FILE

BR0280I BRBACKUP time stamp: 2013-07-19 01.04.54
BR0057I Backup of database: ZEP
BR0058I BRBACKUP action ID: belrchon
BR0059I BRBACKUP function ID: anf
BR0110I Backup mode: ALL
BR0077I Database file for backup: /oracle/ZEP/sapbackup/cntrlZEP.dbf
BR0061I 144 files found for backup, total size 1613212.195 MB
BR0143I Backup type: online
BR0130I Backup device type: util_file_online
BR0109I Files will be saved by backup utility at file level
BR0142I Files will be switched to backup status during the backup
BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0280I BRBACKUP time stamp: 2013-07-19 01.04.55
BR0229I Calling backup utility with function 'backup'...

BR0280I BRBACKUP time stamp: 2013-07-19 01.04.55
BR0279E Return code from '/usr/sap/ZEP/SYS/exe/run/backint -u ZEP -f backup -i /oracle/ZEP/sapbackup/.belrchon.lst -t file_online -p /oracle/ZEP/102_64/dbs/initorazep.utl -c': 2

BR0232E 0 of 144 files saved by backup utility
BR0280I BRBACKUP time stamp: 2013-07-19 01.04.55
BR0231E Backup utility call failed

BR0056I End of database backup: belrchon.anf 2013-07-19 01.04.55
BR0280I BRBACKUP time stamp: 2013-07-19 01.04.57
BR0054I BRBACKUP terminated with errors

1 Rookie

 • 

44 Posts

July 18th, 2013 17:00

for content of

backintZEP.log.raw

0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 71 output of file data failed for `/oracle/ZEP/sapdata9/sr3_80/sr3.data80'
0 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 67 waiting on nsrmmd to get lock... lost connection to server, exiting
18432 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 52 Session: %d, pid: %lu completed with exit status: %d 3 1 1 4 2 7 4653390 1 1
1
52828 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 111 Unable to open output file %s. Child process %lu is terminated abnormally.
No output to brtools for this child. 2 23 35 /nsr/applogs/LGTOSAPssapZEP.4653390 2 7 4653390
39373 1374163661 2 0 0 1 1704128 0 boot1_dbs backint 77 Session: %d, pid: %lu, total files in the session: %d, %s. Retried %d time(s
) 5 1 1 4 2 7 4653390 1 2 10 0 6 Failed 1 1 0
0 1374163687 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 29 waitchild reaped, pid 4391724
18396 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 33 Semaphore file deleted in %d secs 1 1 1 1
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 14 Switch log: %s 1 0 0
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 14 Switch log: %s 1 0 49 BR0280I BRCONNECT time stamp: 2013-07-19 00.08.07
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 14 Switch log: %s 1 0 50 #END /oracle/ZEP/sapdata11/sr3usr_13/sr3usr.data13
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 14 Switch log: %s 1 0 50 #END /oracle/ZEP/sapdata11/sr3usr_14/sr3usr.data14
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 14 Switch log: %s 1 0 50 #END /oracle/ZEP/sapdata11/sr3usr_15/sr3usr.data15
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 14 Switch log: %s 1 0 59 BR0317I 'Alter tablespace PSAPSR3USR end backup' successfu
l
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 14 Switch log: %s 1 0 49 BR0280I BRCONNECT time stamp: 2013-07-19 00.08.07
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 14 Switch log: %s 1 0 8 #SUCCESS
52818 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 34 Switch log file indicates success. 0
0 1374163611 2 0 0 1 4391724 0 boot1_dbs backint 2 %s 1 0 150 c_tcp.c:332 Failed to create connection to 192.168.100.36 on port 7938
for RPC client handle: A remote host did not respond within the timeout period.

0 1374163611 2 0 0 1 4391724 0 boot1_dbs backint 2 %s 1 0 70 c_tcp.c:499 Encountered a system error when creating TCP client handle

0 1374163687 2 0 0 1 4391724 0 boot1_dbs backint 2 %s 1 0 149 c_tcp.c:332 Failed to create connection to 192.168.100.36 on port 111
for RPC client handle: A remote host did not respond within the timeout period.

0 1374163687 2 0 0 1 4391724 0 boot1_dbs backint 2 %s 1 0 70 c_tcp.c:499 Encountered a system error when creating TCP client handle

73157 1374163687 2 0 0 1 4391724 0 boot1_dbs backint 39 Registration to the Jobs daemon failed. 0

42503 1374163687 3 2 5 1 4391724 0 boot1_dbs backint 2 %s 1 49 118 80720 9 %s%s - %s 3 24 0  11 23 352:Remote system error 11 56 A r
emote host did not respond within the timeout period.

0 1374163687 2 0 0 1 4391724 0 boot1_dbs backint 2 %s 1 0 0

0 1374163687 2 0 0 1 4391724 0 boot1_dbs backint 48 ------------------------------------------------ 0

39549 1374163687 2 0 0 1 4391724 0 boot1_dbs backint 34 Starting save with pid %lu at %s:  2 2 7 4391724 35 15 Jul 19 00:08:07

0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 5 save
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -f
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 38 /nsr/applogs/.nsr.backint.ZEP.1704128
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 4 -LL
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -N
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 12 backint:ZEP
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -s
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 16 windows-vp7l237
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -c
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 10 boot1_dbs
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -u
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -i
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -g
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 9 ERP_FULL
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -b
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 8 ERP_PLM
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -q
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -l
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 5 Full
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -a
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 23 Save subdirectories=no
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 3 -a
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 25 De-duplication backup=No
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 46 /oracle/ZEP/sapdata11/sr3usr_13/sr3usr.data13
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 46 /oracle/ZEP/sapdata11/sr3usr_14/sr3usr.data14
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 46 /oracle/ZEP/sapdata11/sr3usr_15/sr3usr.data15
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 0
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 147 c_tcp.c:332 Failed to create connection to 192.168.100.36 on port 7938
for RPC client handle: A remote host refused an attempted connect operation.
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 70 c_tcp.c:499 Encountered a system error when creating TCP client handle
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 146 c_tcp.c:332 Failed to create connection to 192.168.100.36 on port 111
for RPC client handle: A remote host refused an attempted connect operation.
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 70 c_tcp.c:499 Encountered a system error when creating TCP client handle
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 94 lgto_parms failed: Remote system error - A remote host refused an attem
pted connect operation.
52902 1374163687 2 0 0 1 4391724 0 boot1_dbs backint 50 Save with pid %lu completed at %s: return_code: %d 3 2 7 4391724 35 15 Jul 1
9 00:08:07 1 1 2

0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 155 70922:backint: Backint exiting at with fatal error:  Cannot connect to
server Remote system error - A remote host refused an attempted connect operation.:
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 0
18432 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 52 Session: %d, pid: %lu completed with exit status: %d 3 1 1 8 2 7 4391724 1 1
2
52828 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 111 Unable to open output file %s. Child process %lu is terminated abnormally.
No output to brtools for this child. 2 23 35 /nsr/applogs/LGTOSAPssapZEP.4391724 2 7 4391724
39373 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 77 Session: %d, pid: %lu, total files in the session: %d, %s. Retried %d time(s
) 5 1 1 8 2 7 4391724 1 1 3 0 6 Failed 1 1 0
0 1374163688 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 30 (interrupted), backint exiting
0 1374163689 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 29 waitchild reaped, pid 4063498
0 1374163689 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 29 waitchild reaped, pid 2294264
0 1374163689 2 0 0 1 1704128 0 boot1_dbs backint 2 %s 1 0 29 waitchild reaped, pid 1966904

4 Operator

 • 

14.4K Posts

July 19th, 2013 00:00

What it says is that your client could not connect to server - if using multihomed client or server, make sure proper interfaces are used (via backup server interface and storage node interface field).

1 Rookie

 • 

44 Posts

July 19th, 2013 01:00


hi, Hrvoje Crvelin:

        can you help me  again,

         when i try to test backup from SAP with brtools , shown the following messags, any ideas ?

   

BR0130I Backup device type: util_file_online
BR0109I Files will be saved by backup utility at file level
BR0142I Files will be switched to backup status during the backup

BR0280I BRBACKUP time stamp: 2013-07-19 15.54.23
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:
c
BR0280I BRBACKUP time stamp: 2013-07-19 15.54.26
BR0258W Wrong reply: 'cc'
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:
c
BR0280I BRBACKUP time stamp: 2013-07-19 15.54.30
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRBACKUP time stamp: 2013-07-19 15.54.30
BR0229I Calling backup utility with function 'backup'...

BR0280I BRBACKUP time stamp: 2013-07-19 15.54.30
BR0279E Return code from '/usr/sap/ZEP/SYS/exe/run/backint -u ZEP -f backup -i /oracle/ZEP/sapbackup/.belrfinb.lst -t file_online -p /oracle/ZEP/102_64/dbs/initorazep.utl': 2

BR0232E 0 of 144 files saved by backup utility
BR0280I BRBACKUP time stamp: 2013-07-19 15.54.30
BR0231E Backup utility call failed


BR0056I End of database backup: belrfinb.anf 2013-07-19 15.54.30
BR0280I BRBACKUP time stamp: 2013-07-19 15.54.33
BR0054I BRBACKUP terminated with errors

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

BR0292I Execution of BRBACKUP finished with return code 5

BR0280I BRTOOLS time stamp: 2013-07-19 15.54.33
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
BR0280I BRTOOLS time stamp: 2013-07-19 15.54.33
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
^D
BR0280I BRTOOLS time stamp: 2013-07-19 15.54.35
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

4 Operator

 • 

14.4K Posts

July 19th, 2013 03:00

Usually rc2 means not found, but it may also apply where no permissions exist.  You are lucky that I'm just about to configure one SAP instance for backup so here we go... Note that values and names might be different in your case so make sure to check that first.  As always, you wish to make sure to use SAP user for backup.  Here we go.

First I set 2 cfg files (environment files) for DB and arch backup.  I renamed mine SID to EMC here.

# cat nsrsapsv_EMC_data.cfg

BR_EXEC=brbackup -r initEMC_data.utl -p initEMC_data.sap

ORACLE_HOME=/oracle/EMC/112_64

SAPDATA_HOME=/oracle/EMC

NLS_LANG = AMERICAN_AMERICA.UTF8

SAP_BIN=/usr/sap/EMC/SYS/exe/run

SAPBACKUP=/oracle/EMC/sapbackup

ORACLE_SID=EMC

NSR_UMASK=022

#NSR_DEBUG_LEVEL=9

SAPARCH=/oracle/EMC/saparch

SAPREORG=/oracle/EMC/sapreorg

SAPTRACE=/oracle/EMC/saptrace

SAPCHECK=/oracle/EMC/sapcheck

LD_LIBRARY_PATH=/usr/sap/EMC/SYS/exe/run:/oracle/EMC/112_64/lib

DIR_LIBRARY=/usr/sap/EMC/SYS/exe/run

# BR_TRACE=1

# cat nsrsapsv_EMC_arch.cfg

BR_EXEC=brarchive -r initEMC_arch.utl -p initEMC_arch.sap

ORACLE_HOME=/oracle/EMC/112_64

SAPDATA_HOME=/oracle/EMC

NLS_LANG = AMERICAN_AMERICA.UTF8

SAP_BIN=/usr/sap/EMC/SYS/exe/run

SAPBACKUP=/oracle/EMC/sapbackup

ORACLE_SID=EMC

NSR_UMASK=022

SAPARCH=/oracle/EMC/saparch

SAPREORG=/oracle/EMC/sapreorg

SAPTRACE=/oracle/EMC/saptrace

SAPCHECK=/oracle/EMC/sapcheck

LD_LIBRARY_PATH=/usr/sap/EMC/SYS/exe/run:/oracle/EMC/112_64/lib

DIR_LIBRARY=/usr/sap/EMC/SYS/exe/run

# BR_TRACE=1

As you can see, the only difference between them is BR_EXEC line in terms what they use and what they do.  Next, I will add username and password to it.

# nsrsapadm -P -z nsrsapsv_EMC_data.cfg

Enter Operating System username:  emcadm

Enter password:  *******

Confirm password:  *******

Configuration file 'nsrsapsv_EMC_data.cfg' updated successfully.

Is Oracle database authentication used? : N

73967:nsrsapadm: To disable Oracle database authentication, comment out or delete the ORACLE_USR_PASSWD line in 'nsrsapsv_EMC_data.cfg'.

# nsrsapadm -P -z nsrsapsv_EMC_arch.cfg

Enter Operating System username:  emcadm

Enter password:  *******

Confirm password:  *******

Configuration file 'nsrsapsv_EMC_arch.cfg' updated successfully.

Is Oracle database authentication used? : N

73967:nsrsapadm: To disable Oracle database authentication, comment out or delete the ORACLE_USR_PASSWD line in 'nsrsapsv_EMC_arch.cfg'

OK, this is done now.  Now, I only have to set utl and sap files.  This are always in $ORACLE_HOME/dbs... They should also be owned by Oracle user:

-rwxr-xr-x   1 oraemc     dba           1375 Jul 19 10:46 initEMC_arch.sap

-rwxr-xr-x   1 oraemc     dba            286 Jul 19 10:47 initEMC_arch.utl

-rwxr-xr-x   1 oraemc     dba           1383 Jul 19 10:47 initEMC_data.sap

-rwxr-xr-x   1 oraemc     dba            339 Jul 19 10:48 initEMC_data.utl

Here is content for each:

# cat initEMC_data.sap

backup_mode = all

restore_mode = all

backup_type = online

backup_dev_type = util_file_online

backup_root_dir = /oracle/EMC/sapbackup

stage_root_dir = /oracle/EMC/sapbackup

compress = no

compress_cmd = "compress -c $ > $"

uncompress_cmd = "uncompress -c $ > $"

compress_dir = /oracle/EMC/sapreorg

archive_function = save_delete

archive_copy_dir = /oracle/EMC/sapbackup

archive_stage_dir = /oracle/EMC/sapbackup

tape_copy_cmd = cpio

disk_copy_cmd = copy

stage_copy_cmd = rcp

cpio_flags = -ovB

cpio_in_flags = -iuvB

cpio_disk_flags = -pdcu

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

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

saveset_members = 1

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

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

rewind = "mt -t $ rew"

rewind_offline = "mt -t $ offl"

tape_pos_cmd = "mt -t $ fsf $"

tape_size = 11000M

exec_parallel = 0

tape_address = /dev/rmt/0mn

tape_address_rew = /dev/rmt/0m

volume_archive = (EMCA01, EMCA02, EMCA03, EMCA04, EMCA05,

                  EMCA06, EMCA07, EMCA08, EMCA09, EMCA10,

                  EMCA11, EMCA12, EMCA13, EMCA14, EMCA15,

                  EMCA16, EMCA17, EMCA18, EMCA19, EMCA20,

                  EMCA21, EMCA22, EMCA23, EMCA24, EMCA25,

                  EMCA26, EMCA27, EMCA28, EMCA29, EMCA30)

volume_backup =  (EMCB01, EMCB02, EMCB03, EMCB04, EMCB05)

expir_period = 5

tape_use_count = 100

util_par_file = /oracle/EMC/112_64/dbs/initEMC_data.utl

# cat initEMC_data.utl

#debug_level = 9

#nsr_debug_msg = yes

group = EMC_SAP_DB_DEV_TC_remote_1

NSR_DIRECT_ACCESS = Yes

pool =

expiration = 9 Days

savesets = 20

parallelism = 4

server =

client =

verbose = yes

#ss_group_by_fs = yes

ps_exclude_backup_bi_run_nums = 2

ps_exclude_archive_bi_run_nums = 1;2

# cat initEMC_arch.sap

backup_mode = all

restore_mode = all

backup_type = online

backup_dev_type = util_file

backup_root_dir = /oracle/EMC/sapbackup

stage_root_dir = /oracle/EMC/sapbackup

compress = no

compress_cmd = "compress -c $ > $"

uncompress_cmd = "uncompress -c $ > $"

compress_dir = /oracle/EMC/sapreorg

archive_function = save_delete

archive_copy_dir = /oracle/EMC/sapbackup

archive_stage_dir = /oracle/EMC/sapbackup

tape_copy_cmd = cpio

disk_copy_cmd = copy

stage_copy_cmd = rcp

cpio_flags = -ovB

cpio_in_flags = -iuvB

cpio_disk_flags = -pdcu

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

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

saveset_members = 1

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

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

rewind = "mt -t $ rew"

rewind_offline = "mt -t $ offl"

tape_pos_cmd = "mt -t $ fsf $"

tape_size = 11000M

exec_parallel = 0

tape_address = /dev/rmt/0mn

tape_address_rew = /dev/rmt/0m

volume_archive = (EMCA01, EMCA02, EMCA03, EMCA04, EMCA05,

                  EMCA06, EMCA07, EMCA08, EMCA09, EMCA10,

                  EMCA11, EMCA12, EMCA13, EMCA14, EMCA15,

                  EMCA16, EMCA17, EMCA18, EMCA19, EMCA20,

                  EMCA21, EMCA22, EMCA23, EMCA24, EMCA25,

                  EMCA26, EMCA27, EMCA28, EMCA29, EMCA30)

volume_backup =  (EMCB01, EMCB02, EMCB03, EMCB04, EMCB05)

expir_period = 5

tape_use_count = 100

util_par_file = /oracle/EMC/112_64/dbs/initEMC_arch.utl

# cat initEMC_arch.utl

#debug_level = 9

#nsr_debug_msg = yes

#backint_tmpdir=/nsr/applogs/EMCa

group = SAP_ARCH_DEV_TC_remote_1

NSR_DIRECT_ACCESS = Yes

pool =

expiration = 9 Days

server =

client =

verbose = yes

parallelism = 2

#ss_group_by_fs = yes

Few notes about above:

  • I use template so I usually find&replace for SID
  • because I use PowerSnap in my landscape (not in this case), my template for util file has 3 lines for ps - they are not needed, but they do not hurt being there neither
  • you will need to set server, client and pool in util file as per your own setup
  • unless you are not using DD Boost, you MUST set NSR_DIRECT_ACCESS = No

Last thing, and also important, is permissions on backint and BRTools.  Sometimes this is dirty business unless SAP admin didn't run saproot script.  There is an article on SAP KB which states exactly how this should be (KB id escapes me now), but you will just have to trust me about following:

# cd /usr/sap/SBX/SYS/exe/run

# ll b*

-rwxr-xr-x   1 emcadm     sapsys     8211864 Jan 15  2013 backint

-rwsrwxr-x   1 oraemc     sapsys     16489848 Apr  2  2012 brarchive

-rwsrwxr-x   1 oraemc     sapsys     16996712 Apr  2  2012 brbackup

-rwsrwxr-x   1 oraemc     sapsys     21364240 Apr  2  2012 brconnect

-rwxrwxr-x   1 emcadm     sapsys     17722736 Apr  2  2012 brrecover

-rwxrwxr-x   1 emcadm     sapsys     7357008 Apr  2  2012 brrestore

-rwxrwxr-x   1 emcadm     sapsys     23279072 Apr  2  2012 brspace

-rwxrwxr-x   1 emcadm     sapsys     9574576 Apr  2  2012 brtools

With this in place, all I need to do is make sure backup group and clients are there:

  • create group just as defined in util file
  • place groups into pools just as defined in util file
  • create client for DB backup, saveset is backint:EMC and backup command is nsrsapsv -f /nsr/res/nsrsapsv_EMC_data.cfg and assign it to DB group
  • create client for ARCH backup, saveset is backint:EMC and backup command is nsrsapsv -f /nsr/res/nsrsapsv_EMC_arch.cfg and assign it to ARCH group

And finally, run backup. 

One note; I use FQDN everywhere on my servers, but I know this is not always the case elsewhere.  As a matter of fact, recently I worked on server where server and client were defined as hostname.  Then I got error that server hostname and FQDN are defined (I could see it after I enabled debug in util file).  It turned out that server value in util was was the one set in backup server interface value of the client itself. So, if you run multihomed environment with multiple choice, it all comes down to what you set and use.  This applies only to scheduled backups.

Now, to make it more exciting, I did get an error like you:

BR0280I BRBACKUP time stamp: 2013-07-19 11.24.50

BR0057I Backup of database: EMC

BR0058I BRBACKUP action ID: belrfqnu

BR0059I BRBACKUP function ID: anf

BR0110I Backup mode: ALL

BR0077I Database file for backup: /oracle/EMC/sapbackup/cntrlEMC.dbf

BR0061I 14 files found for backup, total size 148909.180 MB

BR0143I Backup type: online

BR0130I Backup device type: util_file_online

BR0109I Files will be saved by backup utility at file level

BR0142I Files will be switched to backup status during the backup

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0280I BRBACKUP time stamp: 2013-07-19 11.24.50

BR0229I Calling backup utility with function 'backup'...

BR0280I BRBACKUP time stamp: 2013-07-19 11.24.51

BR0279E Return code from '/usr/sap/EMC/SYS/exe/run/backint -u EMC -f backup -i /oracle/EMC/sapbackup/.belrfqnu.lst -t file_online -p /oracle/EMC/112_64/dbs/initEMC_data.utl -c': 2

BR0232E 0 of 14 files saved by backup utility

BR0280I BRBACKUP time stamp: 2013-07-19 11.24.51

BR0231E Backup utility call failed

BR0056I End of database backup: belrfqnu.anf 2013-07-19 11.24.51

BR0280I BRBACKUP time stamp: 2013-07-19 11.24.53

BR0054I BRBACKUP terminated with errors

Now, I did something wrong somewhere, but I have no idea where of course.  Not to waste my time, I will enable those documented lines for debug in util file and check again (debug_level = 9 and nsr_debug_msg = yes).  Logs will be placed in /nsr/applogs.  Now I see following:

Backint exiting at with fatal error: checking for deletion of semaphore file: Permission denied

I have no idea what this means really except that backint running as SAP user could not access semaphore (memory) files indicating some issue with permissions. At this point, this indicates to me issue on SAP side. And since I use setup which is exactly the same for all SAP instances I backup, I'm 100% sure nothing is wrong with my setup.  Checking docs quickly shows:

ecn178.PNG.png

OK, so let's check:

# cd /oracle/EMC/sapbackup

# ls -ltra

total 34784

-rw-------   1 oraemc     dba        1808476 Jul 12 13:54 archEMC.log

-rw-------   1 oraemc     dba          16427 Jul 12 13:59 belprxwl.anf

-rw-------   1 oraemc     dba           8054 Jul 12 14:42 relpxtuw.rsb

-rw-------   1 oraemc     dba           1277 Jul 12 15:33 relpybyz.rsa

-rw-------   1 oraemc     dba           1284 Jul 12 15:35 relpycdh.rsa

-rw-rwx---   1 oraemc     dba           1048 Jul 12 15:41 restEMC.log

-rw-------   1 oraemc     dba           2835 Jul 12 15:41 relpycki.rsa

drwxrwxrwx  17 oraemc     dba           8192 Jul 18 15:38 ..

-rw-r--r--   1 oraemc     sapsys        7339 Jul 19 11:24 belrfqnu.anf

-rw-r--r--   1 oraemc     sapsys          48 Jul 19 11:30 .switch.lis

-rw-r--r--   1 oraemc     sapsys           0 Jul 19 11:30 .switch.sem

-rw-r--r--   1 oraemc     sapsys        7339 Jul 19 11:30 belrfrak.anf

-rw-------   1 oraemc     dba          69385 Jul 19 11:30 backEMC.log

drwxrwx---   2 oraemc     dba           8192 Jul 19 11:30 .

# rm .switch.*

Removed, tried again, same.  OK, so SAP user has to be able to remove file owned by Oracle user.  From above we see this is not possible of course. At this point I check sapadm user and see following:

emcadm 21> umask

077

Now, you wish this to be 022 and not 077.  Time to walk to the SAP guys   It turns out that UNIX guys created user, but failed to setup profile according to SAP wishes.  After that being fixed, it works (not that both oracle and SAP user had umask set wrong)

If you wish to run it manually from the box, for DB backup you can run

brbackup -c force -u / -r initEMC_data.utl -p initEMC_data.sap

and for archive log backup:

brarchive -c force -u / -r initEMC_arch.utl -p initEMC_arch.sap

I hope this helps you configure it and get an idea of initial troubleshooting steps.

4 Operator

 • 

14.4K Posts

July 19th, 2013 04:00

One more thing... from my experience, sapbackup folder needs read and execute writes for others in almost all SAP implementations I have seen so far - without it, you may get issues too.

No Events found!

Top