I seem to be running into some problems while trying to set up the TDP for
R/3. Can anyone offer any advice? I have set
DSMI_CONFIG=/usr/tivoli/tsm/tdp_r3/dsm.opt (which points to a new node:
sapeco_dev_r3) but it still doesn't seem to work. I can call out dsmadmc
fine (with the original node name sepco_dev).
I don't seem to understand where the exact problem lies. They say I do
not have my options file defined but DSM_CONFIG and DSMI_CONFIG have already
been set. I can't do a BRARCHIVE, and I can't call out backint properly so
that I can change the password. Ideas anyone?
Thanks in Advance.
sepco_dev:oraph1 7> brarchive -sd -p /oracle/PH1/dbs/initPH1.sap -c -l E -d
util_file -u system/ph2ok
BR002I BRARCHIVE 4.6D (16)
BR006I Start of offline redo log processing: adhwkusf.svd 2002-04-30
17.49.45
BR280I Time stamp 2002-04-30 17.49.46
BR008I Offline redo log processing for database instance: PH1
BR009I BRARCHIVE action ID: adhwkusf
BR010I BRARCHIVE function ID: svd
BR011I 39 offline redo log files found for processing, total size 770.897 MB
BR130I Backup device type: util_file
BR109I Files will be saved by backup utility
BR126I Unattended mode active - no operator confirmation required
BR280I Time stamp 2002-04-30 17.49.46
BR229I Calling backup utility...
BR278I Command output of '/usr/sap/PH1/SYS/exe/run/backint -u PH1 -f backup
-i /oracle/PH1/sapbackup/.adhwkusf.lst -t file -p
/oracle/PH1/dbs/initPH1.utl -c':
/oracle/PH1/dbs/initPH1.utl -c':
Tivoli Data Protection for R/3
Interface between SAPDBA Utilities and Tivoli Storage Manager
- Version 3, Release 2, Level 0.8 for AIX LF -
Build: 142H compiled on Dec 13 2001
(c) Copyright IBM Corporation, 1996, 2001, All Rights Reserved.
BKI0005I: Start of backint program at: Tue Apr 30 17:49:46 2002 .
BR266E Program '/usr/sap/PH1/SYS/exe/run/backint -u PH1 -f backup -i
/oracle/PH1/sapbackup/.adhwkusf.lst -t file -p /oracle/PH1/dbs/initPH1.utl
-c' interrupted, exit status: 8b
BR272E Execution of program '/usr/sap/PH1/SYS/exe/run/backint -u PH1 -f
BR272E Execution of program '/usr/sap/PH1/SYS/exe/run/backint -u PH1 -f
backup -i /oracle/PH1/sapbackup/.adhwkusf.lst -t file -p
/oracle/PH1/dbs/initPH1.utl -c' through pipe failed
BR280I Time stamp 2002-04-30 17.49.47
BR231E Backup utility call failed
BR016I 0 offline redo log files processed, total size 0.000 MB
BR007I End of offline redo log processing: adhwkusf.svd 2002-04-30 17.49.47
BR280I Time stamp 2002-04-30 17.49.48
BR005I BRARCHIVE terminated with errors
sepco_dev:oraph1 8>
sepco_dev:oraph1 8>
sepco_dev:oraph1 8>
sepco_dev:oraph1 8> logout
<mailto:root@sepco_dev:/> root@sepco_dev:/] su - ph1adm
sepco_dev:ph1adm 1> backint -p /oracle/PH1/dbs/initPH1.utl -f password
Tivoli Data Protection for R/3
Interface between SAPDBA Utilities and Tivoli Storage Manager
- Version 3, Release 2, Level 0.8 for AIX LF -
Build: 142H compiled on Dec 13 2001
(c) Copyright IBM Corporation, 1996, 2001, All Rights Reserved.
BKI0005I: Start of backint program at: Tue Apr 30 17:50:34 2002 .
BKI2000I: Successfully connected to ProLE on port 57321.
BKI9001E: Internal error: *** dsmstuff.cpp:307: setUpdsm(char **args):
ANS1035S (RC406) Options file not found
BKI9001E: Internal error: *** dsmstuff.cpp:307: setUpdsm(char **args):
ANS1035S (RC406) Options file not found
BKI0020I: End of backint program at: Tue Apr 30 17:50:35 2002 .
BKI0020I: End of backint program at: Tue Apr 30 17:50:35 2002 .
BKI0021I: Elapsed time: 01 sec .
BKI0024I: Return code is: 2.
BKI0101I: Session 0: Please enter 'cont' to continue or 'stop' to cancel.
sepco_dev:ph1adm 2>
sepco_dev:ph1adm 2> cd /usr/tivoli/tsm/tdp_r3
sepco_dev:ph1adm 3> cat dsm.opt
************************************************************************
* ADSTAR Distributed Storage Manager *
* *
* Sample Client User Options file for AIX and SunOS *
************************************************************************
SErvername sepco_dev_r3
Replace On
Tapeprompt No
DOM /usr/sap /sapmnt/PH1 /usr/sap/trans /oracle/PH1
sepco_dev:ph1adm 4> cat dsm.sys
SErvername sepco_dev
COMMmethod TCPip
TCPPort 1500
TCPServeraddress 107.10.86.43
PASSWORDACCESS GENERATE
TCPWindowsize 1024
TCPBuffsize 32
TCPNoDelay Yes
Compression Off
nodename sepco_dev
* InclExcl /usr/tivoli/tsm/client/ba/bin/inclexcl.list
SErvername sepco_dev_r3
COMMmethod TCPip
TCPPort 1500
TCPServeraddress 107.10.86.43
PASSWORDACCESS PROMPT
TCPWindowsize 1024
TCPBuffsize 32
TCPNoDelay Yes
Compression Off
* InclExcl /usr/tivoli/tsm/client/ba/bin/inclexcl.list
SErvername pvprod
COMMmethod TCPip
TCPPort 1500
TCPServeraddress 107.10.86.43
PASSWORDACCESS GENERATE
TCPWindowsize 1024
TCPBuffsize 32
TCPNoDelay Yes
Compression Off
nodename pvprod
* InclExcl /usr/tivoli/tsm/client/ba/bin/inclexcl.list
SErvername ab1_client
COMMmethod TCPip
TCPPort 1500
TCPServeraddress loopback
PASSWORDACCESS PROMPT
TCPWindowsize 1024
TCPBuffsize 32
TCPNoDelay Yes
Compression Off
nodename ab1_client
* InclExcl /usr/tivoli/tsm/client/ba/bin/inclexcl.list
SErvername ab2_client
COMMmethod TCPip
TCPPort 1500
TCPServeraddress loopback
PASSWORDACCESS PROMPT
TCPWindowsize 1024
TCPBuffsize 32
TCPNoDelay Yes
Compression Off
nodename ab2_client
* InclExcl /usr/tivoli/tsm/client/ba/bin/inclexcl.list
SErvername sea_rdw
COMMmethod TCPip
TCPPort 1500
TCPServeraddress loopback
PASSWORDACCESS generate
TCPWindowsize 1024
TCPBuffsize 32
TCPNoDelay Yes
Compression Off
nodename sea_rdw
* InclExcl /usr/tivoli/tsm/client/ba/bin/inclexcl.list
* SErvername myprod_client
* COMMmethod TCPip
* TCPPort 1500
* TCPServeraddress myprod
*
*
* SErvername sadevt_client
* COMMmethod TCPip
* TCPPort 1500
* TCPServeraddress sa_devt
*
* SErvername server_b
* COMMmethod TCPip
* TCPPort 1500
* TCPServeraddress loopback
* PASSWORDACCESS PROMPT
* TCPWindowsize 1024
* TCPBuffsize 32
* TCPNoDelay Yes
* Compression Off
* nodename sea_rdw
* * InclExcl /usr/tivoli/tsm/client/ba/bin/inclexcl.list
*
sepco_dev:ph1adm 6> echo $DSMI_CONFIG
/usr/tivoli/tsm/tdp_r3/dsm.opt
sepco_dev:ph1adm 7> dsmadmc
Tivoli Storage Manager
Command Line Administrative Interface - Version 4, Release 1, Level 2.0
(C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved.
Enter your user id: admin
Enter your password:
Session established with server PVPROD: AIX-RS/6000
Server Version 4, Release 1, Level 3.0
Server date/time: 04/30/02 17:51:35 Last access: 04/30/02 15:11:27
tsm: PVPROD>q node
Node Name Platform Policy Domain Days Since
Days Since Locked?
Name Last Acce-
Password
ss
Set
------------------------- -------- -------------- ----------
---------- -------
---------- -------
PVPROD AIX DAYDOM <1
PVPROD AIX DAYDOM <1
174 No
PV_DEVT AIX DAYDOM <1
174 No
SEPCO_DEV AIX DAYDOM <1
14 No
SEPCO_DEV_R3 (?) DAYDOM <1
<1 No
tsm: PVPROD>
<mailto:root@sepco_dev:/oracle/PH1/dbs> root@sepco_dev:/oracle/PH1/dbs]
echo $DSM_CONFIG
/usr/tivoli/tsm/client/ba/bin/dsm.opt
root@sepco_dev:/oracle/PH1/dbs <mailto:root@sepco_dev:/oracle/PH1/dbs> ] cat
~oraph1/dbs/initPH1.utl
#--------------------------------------------------------------------------
#
# Tivoli Data Protection for R/3 interface for SAP R/3 for ORACLE
#
# Sample profile for Tivoli Data Protection for R/3 Version 3.1 for UNIX
#
#--------------------------------------------------------------------------
#
# This file should be renamed to $ORACLE_HOME/dbs/init$ORACLE_PH1.utl
# where $ORACLE_HOME is the home directory of the Oracle database and
# $ORACLE_PH1 is the system ID of the Oracle database.
# Default is '/oracle/PH1/initPH1.utl'.
#
# See the 'Tivoli Data Protection for R/3 Installation & User's Guide'
# for a full description.
#
# For comment symbol the character '#' can be used.
# Everything following this character will be interpreted as comment.
#
# Tivoli Data Protection for R/3 V3R1 accesses its profile in "read only"
# mode only. All variable parameters like passwords, date of last
# password change, current version number will be written into the file
# specified with the CONFIG_FILE parameter. The passwords will be encrypted.
#--------------------------------------------------------------------------
# Prefix of the 'Backup ID' which will be used for communication with SAPDBA
# and stored in the description field of the Tivoli Storage Manager archive
# function.
# Maximum 6 characters.
# Default: none.
#--------------------------------------------------------------------------
BACKUPIDPREFIX PH1___
#--------------------------------------------------------------------------
# Number of total parallel sessions which will be established by Tivoli Data
# Protection for R/3. Note: this number should correspond with the number
# of simultaneously available tape drives specified for the Tivoli Storage
# Manager server.
# Default: none.
#--------------------------------------------------------------------------
MAX_SESSIONS 1 # 1 Tivoli Storage Manager client session is
default
#--------------------------------------------------------------------------
# Number of parallel sessions which will be established by Tivoli Data
# Protection for R/3 for the database backup.
# Note: this number should correspond with the number of simultaneously
# available tape drives specified for the Tivoli Storage Manager server.
# Default: none.
#--------------------------------------------------------------------------
MAX_BACK_SESSIONS 1 # 1 Tivoli Storage Manager client session for
backup
#--------------------------------------------------------------------------
# Number of parallel sessions which will be established by Tivoli Data
# Protection for R/3 for the archive log backup.
# Note: this number should correspond with the number of simultaneously
# available tape drives specified for the Tivoli Storage Manager server.
# Default: none.
#--------------------------------------------------------------------------
MAX_ARCH_SESSIONS 1 # 1 Tivoli Storage Manager client session for
archive
#--------------------------------------------------------------------------
# Number of parallel sessions which will be established by Tivoli Data
# Protection for R/3 for the restore of files.
# Note: this number should correspond with the number of simultaneously
# available tape drives specified for the Tivoli Storage Manager server.
# Default: none.
#--------------------------------------------------------------------------
MAX_RESTORE_SESSIONS 1 # 1 Tivoli Storage Manager client session for
restore
#--------------------------------------------------------------------------
# Number of backup copies of the archived redo logs.
# Default: 1.
#--------------------------------------------------------------------------
REDOLOG_COPIES 1 # 1 is default
#--------------------------------------------------------------------------
# Specifies whether Tivoli Data Protection for R/3 should perform a
# null block compression of the data before they are transmitted over the
# network to Tivoli Storage Manager. The null block compression consumes
# only little cpu resources. This compression in Tivoli Data Protection for
# R/3 is independent from the Tivoli Storage Manager compression.
# Do not compress twice !
# Default: NO
#--------------------------------------------------------------------------
RL_COMPRESSION YES # NO is default
#--------------------------------------------------------------------------
# Specifies how many files are multiplexed into one data stream
# to a Tivoli Storage Manager server. Multiplexing is usefull when the data
# rate to a Tivoli Storage Manager server is higher (fast tapes, fast
network)
# than the I/O rate from a single disk.
# The valid range of MULTIPLEXING is from 1 to 8.
# Default: 1 (meaning no multiplexing)
#--------------------------------------------------------------------------
#MULTIPLEXING 3 # 1 is default
#--------------------------------------------------------------------------
# Specifies the block size for disk I/O (in bytes). The valid range is
# from 4 KB to 256 KB.
# The default values have been chosen from our performance experiments in
# standard hardware environments.
# Default: 131072 (128 KB) on UNIX, 32768 (32 KB) on Windows NT.
#--------------------------------------------------------------------------
BUFFSIZE 131072 # block size in bytes
#--------------------------------------------------------------------------
# Name of a program that is called by Tivoli Data Protection for R/3
# before the backup task is started.
# Default: none.
#--------------------------------------------------------------------------
#FRONTEND pgmname parameterlist
#--------------------------------------------------------------------------
# Name of a program that is called by Tivoli Data Protection for R/3
# after the backup task is completed.
# Default: none.
#--------------------------------------------------------------------------
#BACKEND pgmname parameterlist
#--------------------------------------------------------------------------
# Maximum number of data base backup versions to be kept.
# Note: Version control by Tivoli Data Protection for R/3 is only
# activated if the SAP R/3 release is 3.0C and higher and the parameter
# MAX_VERSION is not 0.
# Default: 0.
#--------------------------------------------------------------------------
MAX_VERSIONS 20
#--------------------------------------------------------------------------
# Batch processing
# Default:
# The default for the BATCH parameter is YES for the backup run and NO for
# the restore run if the BATCH parameter is COMMENTED OUT in this profile.
#--------------------------------------------------------------------------
#BATCH YES # unattended automated operation
#BATCH NO # manual operation
#--------------------------------------------------------------------------
# Control of error situations
# Default: NO.
#--------------------------------------------------------------------------
#EXITONERROR 3 # don't exit if an error occurs
#--------------------------------------------------------------------------
# Control of information for reporting purposes, e.g. messages, statistics.
# Default: NO (no additional data will be reported).
#--------------------------------------------------------------------------
REPORT NO # no additional messages
#REPORT YES # all additional messages
#REPORT 2 # all additional messages +
summary
#--------------------------------------------------------------------------
# Controls generation of a trace file.
# Note: we recommend using the trace function only in cooperation with
# the hotline.
# Default: NO.
#--------------------------------------------------------------------------
#TRACE 100
#--------------------------------------------------------------------------
# Specify the trace file for Tivoli Data Protection for R/3 to store all
# trace information (if TRACE ON), full path and name of file.
# Note: for an actual trace the string '%BID' will be replaced by
# the current backupid.
# (.../backint_%BID.trace changes to .../backint_SAP___9809182300.trace).
# Default: stdout.
#--------------------------------------------------------------------------
#TRACEFILE /oracle/PH1/dbs/backint.trace
#TRACEFILE /oracle/PH1/dbs/backint_%BID.trace
#--------------------------------------------------------------------------
# Specify the configuration file for Tivoli Data Protection for R/3 to
# store all variable parameters, full path and name of the file.
# Default: none.
#--------------------------------------------------------------------------
CONFIG_FILE /oracle/PH1/dbs/initPH1.bki
#--------------------------------------------------------------------------
# Number of retries to be performed in case of errors when connecting to
# the Tivoli Storage Manager server.
# Default: 3.
#--------------------------------------------------------------------------
#RETRY 5
#--------------------------------------------------------------------------
# Specify time after which a retry has to be performed (seconds).
# Default: 1.
#--------------------------------------------------------------------------
#TCPWAIT 1
#--------------------------------------------------------------------------
# Number of times Tivoli Data Protection for R/3 retries to save/restore
# a file in case an error occurs.
# Default: 3.
#--------------------------------------------------------------------------
#FILE_RETRIES 3
#--------------------------------------------------------------------------
# Shall Tivoli Data Protection for R/3 send error/status information
# to a Tivoli Storage Manager server. The statement for servername must
# match one of the servers listed in a SERVER statement. Statements for
# verbosity can be ERROR, WARNING, or DETAIL.
# Default: none.
#--------------------------------------------------------------------------
#LOG_SERVER servername [verbosity]
#LOG_SERVER server_a ERROR
#--------------------------------------------------------------------------
# Shall Tivoli Data Protection for R/3 send error/status information
# to a network management program via SNMP traps?
# Default: none.
#--------------------------------------------------------------------------
#SNMPTRAP Hostname community level
#SNMPTRAP server_a public detail
#--------------------------------------------------------------------------
# Shall Tivoli Data Protection for R/3 use a manual sorting file for disk
# sorting ?
# Default: none.
#--------------------------------------------------------------------------
#SORT_FILE /oracle/PH1/dbs/manual_sort_file
#**************************************************************************
# Statement for multiple Servers and multiple Paths.
# may be used multiple times (one for each server).
#**************************************************************************
SERVER sepco_dev_r3 # Servername
SESSIONS 1 # Max sessions
PASSWORDREQUIRED YES # Use a password
ADSMNODE sepco_dev # Tivoli Storage Manager
Nodename
BRBACKUPMGTCLASS sapmc # Mgmt-Classes
BRARCHIVEMGTCLASS sapmc arch2mc # Mgmt-Classes
# USE_AT 0 1 2 3 4 5 6 # Days for backup
#SERVER server_b # Servername
# SESSIONS 2 # Max sessions
# PASSWORDREQUIRED YES # Use a password
# ADSMNODE NODE # Tivoli Storage Manager Nodename
# BRBACKUPMGTCLASS MDB # Mgmt-Classes
# BRARCHIVEMGTCLASS MLOG1 MLOG2 # Mgmt-Classes
# USE_AT 0 1 2 3 4 5 6 # Days for backup
#**************************************************************************
# USE_AT : 0=Su 1=Mo 2=Tu 3=We 4=Th 5=Fr 6=Sa
# Default: all days
#**************************************************************************
#--------------------------------------------------------------------------
# End of profile
END
root@sepco_dev:/oracle/PH1/dbs <mailto:root@sepco_dev:/oracle/PH1/dbs> ]
|
