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': 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 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 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> ]