1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

TDP for SAP - Multiple SAP DBs on same system

Discussion in 'TDP/Application Layer Backup' started by romeyer, Nov 1, 2002.

  1. romeyer

    romeyer New Member

    Joined:
    Sep 10, 2002
    Messages:
    10
    Likes Received:
    1
    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.
     
  2.  
  3. tkostrevc

    tkostrevc New Member

    Joined:
    Sep 18, 2002
    Messages:
    34
    Likes Received:
    0
    Occupation:
    TSM EMEA L2 Support
    Location:
    Slovenia
    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

    sp03:eek:raqa1 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

    sp03:eek:raqa1 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

    sp03:eek:raqa1 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

    sp03:eek:raqa1 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.

    sp03:eek:raqa1 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
     

Share This Page