TDP for SAP - Multiple SAP DBs on same system

[romeyer]

Hello,

in the inst. guide I read, that setup.sh must run to install soft links to SAP binaries into tdp bin dirs.

How do I configure TDP for SAP on a system with more than one SAP instance (different SAP binaries)? Do I install tdp twice or even mre times?



Thanks.

[tkostrevc]

You have to install TDP only once; what you need to do is a separate configuration for each R/3 instance. Let's assume we have two R/3 instances running on machine called sp03 - QA1 and PR1. The TSM server is running on other machine called SP04. First, we have to set some environment variables for each instance:



---------------------------------------------------------------------------------

sp03:/ # su - oraqa1

sp03raqa1 1> vi .login

setenv DSMI_CONFIG /usr/tivoli/tsm/tdp_r3/ora/dsm.opt.QA1

setenv DSMI_DIR /usr/tivoli/tsm/client/api/bin

setenv DSM_LOG /usr/tivoli/tsm/log/sap/qa1

sp03raqa1 2> exit

---------------------------------------------------------------------------------



then we edit the /usr/tivoli/tsm/tdp_r3/ora/dsm.opt.QA1 file:



---------------------------------------------------------------------------------

sp03:/ # vi /usr/tivoli/tsm/tdp_r3/ora/dsm.opt.QA1

SErvername SP04_QA1

Replace On

Tapeprompt No

DOM /usr/sap /sapmnt/QA1 /usr/sap/trans /oracle/QA1

---------------------------------------------------------------------------------



after that we edit the /usr/tivoli/tsm/client/api/bin/dsm.sys file which is needed by TDP4R/3:



---------------------------------------------------------------------------------

sp03:/ # vi /usr/tivoli/tsm/client/api/bin/dsm.sys

SErvername SP04_QA1

COMMmethod TCPip

TCPPort 1500

TCPServeraddress sp03.domain.si

NODENAME QA1_SAP

PASSWORDACCESS PROMPT

TCPNODELAY YES

LARGECOMMBUF YES

COMPRESSION OFF

---------------------------------------------------------------------------------



TSM scheduler for SAP also needs to know, some information about TSM server so ...



---------------------------------------------------------------------------------

sp03:/ # vi /usr/tivoli/tsm/client/ba/bin/dsm.sys

SErvername SP04_QA1

COMMmethod TCPip

TCPPort 1500

TCPServeraddress sp03.domain.si

NODENAME QA1_SAP

PASSWORDACCESS GENERATE

SCHEDLOGNAME /usr/tivoli/tsm/log/sap/sapsched.log.QA1

ERRORLOGNAME /usr/tivoli/tsm/log/sap/saperr.log.QA1

SCHEDLOGRETENTION 8,D

ERRORLOGRETENTION 90,D

---------------------------------------------------------------------------------



and finally the $ORACLE_HOME/QA1/dbs/initQA1.utl file:



---------------------------------------------------------------------------------

sp03:/ # su - oraqa1

sp03raqa1 1> vi dbs/initQA1.utl

LOG_SERVER SP04_QA1 DETAIL

SERVER SP04_QA1

SESSIONS 1

PASSWORDREQUIRED YES

ADSMNODE QA1_SAP

BRBACKUPMGTCLASS SAP_BACK_MC

BRARCHIVEMGTCLASS SAP_ARCH_MC

---------------------------------------------------------------------------------



through dsmadmc we update (or register) node:



---------------------------------------------------------------------------------

tsm: SP04> UPDATE NODE QA1_SAP qa1sap

ANR2063I Node QA1_SAP updated.

---------------------------------------------------------------------------------



we also have to make an initial login to the TSM server with a dsmc client:



---------------------------------------------------------------------------------

sp03:/ # dsmc -optfile=/usr/tivoli/tsm/tdp_r3/ora/dsm.opt.QA1

Tivoli Storage Manager

Command Line Backup/Archive Client Interface - Version 5, Release 1, Level 0.0

(C) Copyright IBM Corporation 1990, 2002 All Rights Reserved.



tsm> Q SCH

Node Name: QA1_SAP

Please enter your user id <QA1_SAP>:



Please enter password for user id "QA1_SAP":



Session established with server SP04: AIX-RS/6000

Server Version 5, Release 1, Level 1.6

Server date/time: 01/22/03 13:06:11 Last access: 01/22/03 11:54:28



There are no schedules associated with this node.

tsm>

---------------------------------------------------------------------------------



and finally initial login with backint:



---------------------------------------------------------------------------------

sp03:/ # su - oraqa1

sp03raqa1 1> backint –p /oracle/QA1/dbs/initQA1.utl –f password



Tivoli Data Protection for R/3



Interface between SAPDBA Utilities and Tivoli Storage Manager

- Version 3, Release 2, Level 0.3 for AIX LF -

Build: 138K compiled on Jul 4 2001

(c) Copyright IBM Corporation, 1996, 2001, All Rights Reserved.



BKI0005I: Start of backint program at: Wed Jan 22 13:12:57 2003 .

BKI0049I: Please enter password for node QA1_SAP on server SP04_QA1:

BKI0051I: Password successfully verified for node QA1_SAP on server SP04_QA1.

BKI0020I: End of backint program at: Wed Jan 22 13:13:07 2003 .

BKI0021I: Elapsed time: 10 sec .

BKI0024I: Return code is: 0.

sp03raqa1 2> exit

---------------------------------------------------------------------------------



the same procedure should be repeated for other R/3 instance, eg. PR1 or DE1. After that we just have to start schedulers for each node:



sp03:/ # dsmc sched -optfile=/usr/tivoli/tsm/tdp_r3/ora/dsm.opt.QA1

sp03:/ # dsmc sched -optfile=/usr/tivoli/tsm/tdp_r3/ora/dsm.opt.PR1



I hope this was helpful, anyhow it worked for me ...



Best regards

Tomaz Kostrevc