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 for oracle

Discussion in 'TDP/Application Layer Backup' started by bisaal46, Mar 17, 2009.

  1. bisaal46

    bisaal46 New Member

    Joined:
    May 25, 2008
    Messages:
    94
    Likes Received:
    0
    i installed and configured every thing ...i tried the following command from AIX client node..as an oracle user
    $backint -p /oracle/SNT/102_64/dbs/initSNT.utl -f password

    it gives the followinf error...


    Data Protection for SAP(R)
    Interface between BR*Tools and Tivoli Storage Manager
    - Version 5, Release 5, Modification 0.0 for AIX LF 64-bit -
    Build: 316B compiled on Oct 23 2007
    (c) Copyright IBM Corporation, 1996, 2007, All Rights Reserved.

    BKI5014E: Tivoli Storage Manager Error:
    ANS1035S (RC406) Options file '*' could not be found.

    BKI0020I: End of program at: Tue Mar 17 13:14:21 GMT+05:30 2009 .
    BKI0021I: Elapsed time: 00 sec .
    BKI0024I: Return code is: 2.


    what must be the probable solution?
     
  2.  
  3. toxy13

    toxy13 Senior Member

    Joined:
    Sep 24, 2003
    Messages:
    739
    Likes Received:
    12
    Occupation:
    Administrator
    Location:
    Leipzig
    all permissions ok? database users need write/read permissions f.e. dsm.sys file and are all dsm environment variables set right?
     
  4. tenshi

    tenshi New Member

    Joined:
    Mar 16, 2008
    Messages:
    26
    Likes Received:
    0
    Depending on what OS you use check that dsm.sys / dsm.opt files are in /usr/tivoli/tsm/client/api/bin<64>/

    Normally the errormsg shows that the dsm files are not in the appropriate folder.
     
  5. bisaal46

    bisaal46 New Member

    Joined:
    May 25, 2008
    Messages:
    94
    Likes Received:
    0
    can any one help me what should be the content in
    /usr/tivoli/tsm/client/api/bin<64>/dsm.sys
    file ...
    i have following content...in that file


    SErvername TSMSERVER_NAME
    COMMMethod TCPip
    TCPPort 1500
    TCPServeraddress TSMSERVER_NAME

    in the dsm.opt
    /usr/tivoli/tsm/client/api/bin<64>/dsm.opt

    SErvername TSMSERVER_NAME

    MY initSND.sap file has the following entry
    backup_dev_type=rman_util
    rman_parms="ENV=(XINT_PROFILE=<path>/init<SID>.utl,PROLE_PORT=<portnumber>,&BR_INFO)"

    what port number should i use for PROLE_PORT??
     
    Last edited: Mar 18, 2009
  6. Rai

    Rai New Member

    Joined:
    Jul 22, 2008
    Messages:
    54
    Likes Received:
    4
    Location:
    Germany
    ANS1035S (RC406) Options file '*' could not be found.
    check directory /usr/tivoli/tsm/api/bin64 for dsm.sys and dsm.opt or use DSMI_CONFIG for the ***.opt file XINT_PROFILE=<path>/init<SID>.utl,PROLE_PORT=<portnumber>,&BR_INFO
    port=57323 or check your /etc/services
    Next error will be "permission denied"
    add "errorlogname /..../...log" onto the server stanza in the dsm.sys or set the env variable DSMI_LOG
     
  7. Shhyam

    Shhyam New Member

    Joined:
    Apr 7, 2009
    Messages:
    16
    Likes Received:
    0
    Occupation:
    TSM Administrator
    Modify TCPServeraddress in DSM.SYS

    TSMServername is TSM Instance name

    TCPServeraddress will be localhost name where tsmserver is configured

    consider TSM Instance name is tsmserver1
    Hostname containing tsmserver1 is UNIX2

    Modify the value of TCPServeraddress in dsm.sys

    Then Contents of DSM.SYS and DSM.OPT can be

    Dsm.opt

    SErvername tsmserver1

    Dsm.sys

    SErvername tsmserver1
    COMMmethod TCPip
    TCPPort 1500
    TCPServeraddress unix2

    Hope this helps !
     
  8. tejodeep

    tejodeep New Member

    Joined:
    Dec 24, 2008
    Messages:
    17
    Likes Received:
    0
    i have a problem with configuring tsm tdp for sap on oracle

    i want to add environment variables in oracle user .profile
    can any one help me to configure it thankx in advance
     
  9. daya

    daya New Member

    Joined:
    Jun 2, 2009
    Messages:
    21
    Likes Received:
    0
    Occupation:
    ibm tivoli storage manager
    Location:
    Gurgaon (India)
    please tell me how install TDP for SAP
     
  10. Shhyam

    Shhyam New Member

    Joined:
    Apr 7, 2009
    Messages:
    16
    Likes Received:
    0
    Occupation:
    TSM Administrator
    Data Protection for mySAP.com for UNIX systems is delivered as a single
    executable file named install_tdpr3_ora_<operating system>.bin

    where <operating system> is aix43 for AIX 4.3, or
    aix51 for AIX 5.1, or
    solaris or
    hpux or
    linux

    Perform the following steps to install Data Protection for mySAP.com on a UNIX
    machine:

    1. Log in as root user on the mySAP.com database server machine.
    2. Make sure that you use the file that fits to your Oracle database.
    3. The installer guides you through the installation via a graphical X-Window.
    Ensure that you have set the DISPLAY variable correctly.
    4. Invoke the Data Protection for mySAP.com executable file that fits your Oracle
    database.
    5. The “Welcome” panel comes up. Click on Next.
    6. Read the license agreement carefully and decide whether to accept it or not.
    Click on Next.
    7. Enter the Oracle SID. This is the name of the Oracle instance for which you
    want to use Data Protection for mySAP.com. Click on Next.
    8. The installer needs the location of two directories:

    Directory for executables.
    This is the directory where the SAP BR-Tools are located. In the directory,
    the installer creates soft links to the backint and backfm executables.
    Directory for the configuration files:
    This is the directory where the Oracle instance configuration file
    (init<SID>.ora) and the SAP configuration file for backup/restore
    (init<SID>.sap) are located. The installer will copy the following files into
    that directory: init<SID>.utl, init<SID>.bki, agent.lic
    agent.lic is not included if you have downloaded the installation
    package from the Web.
    <SID>must be replaced by the Oracle SID.
    If the configuration files were already installed by an earlier
    installation, the files will not be overwritten.
    Click on Next.

    9. If you want Data Protection for mySAP.com to connect to the Administration
    Assistant Server you have to specify the connection information:
    Network address of the Administration Assistant
    You can either specify the IP address or the host name.
    Port number of the Administration Assistant
    Click on Next.
    10. On the next panel, you can decide if you want the installer to help you with
    the connection settings for the TSM server:
    If you select No, the current settings will be retained, these are either the
    default settings or the values you set for an earlier release of Data Protection
    for mySAP.com.
    If you select Yes, the installer will update the Data Protection for mySAP.com
    configuration file init<SID>.utl with the information you provide in these
    fields:

    TSM server
    Enter the TSM server name. This name must also exists in the TSM file
    dsm.sys.
    TSM node name
    Backup management classes
    TSM management classes used by a brbackup run
    Archive management classes
    TSM management classes used by a brarchive run
    Click on Next.
    11. If you want to install the RMAN support, click on Yes otherwise, click No.

    12. Click on Next until the installation is complete.
    During the installation, the following files are updated automatically:
    an entry will be created in/etc/inittab to start the background process prole
    an entry will be created in/etc/services needed for internal communication.
    After the installation, the TSM password handling method is set to
    PASSWORDACCESS prompt
    13. Log on as Oracle user.
    14. Enter the following command
    backint -p <full path to UTL file>init<SID>.utl -f password
    Enter the password when prompted.

    Also Please Ensure the following

    In INITSID.UTL check and Comment out the Parameters
    BACKUPIDPREFIX Sd__
    MAX SESSIONS
    BUFFSIZE
    CONFIG_FILE= /oracle/SID/dbs/initsid.bki

    Server name : Tsm server name
    Paramers below ....

    Check following in init<SID>.sap file
    SAP Backup profile (init<SID>.sap) contains the following
    backup_dev_type = util_file
    util_par_file = <initsid.utl> /* Data Protection for mySAP.com profile


    Hope this helps !






     
  11. Shhyam

    Shhyam New Member

    Joined:
    Apr 7, 2009
    Messages:
    16
    Likes Received:
    0
    Occupation:
    TSM Administrator
    Then Register node with TSM server and also configure DSM.OPT and DSM.SYS ..later run backint to generate password
     
  12. tejodeep

    tejodeep New Member

    Joined:
    Dec 24, 2008
    Messages:
    17
    Likes Received:
    0
    installation of tdp for sap

    before you install tdp for sap you have many points to remember

    1) o.s. bit if it is 32 or 64 ( the default directory changes if it is 64)
    2) database used by sap either db2 or oracle (backend)
    3) if you want to take backup either daily full or incremental ( if you want incremental then you need to integrate with RMAN settings or if you want to use BRTOOLs then no need of RMAN ( depends on your requirement )

    This is the link to follow more about installation

    Hope this helps

    http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp

    this link is for tdp for sap on oracle







    please tell me how install TDP for SAP
     
  13. daya

    daya New Member

    Joined:
    Jun 2, 2009
    Messages:
    21
    Likes Received:
    0
    Occupation:
    ibm tivoli storage manager
    Location:
    Gurgaon (India)
    any user manual in pdf and what is scope of work in this project
     
  14. tejodeep

    tejodeep New Member

    Joined:
    Dec 24, 2008
    Messages:
    17
    Likes Received:
    0

    follow the link which i posted in previous quote

    Thanks
     
  15. Shhyam

    Shhyam New Member

    Joined:
    Apr 7, 2009
    Messages:
    16
    Likes Received:
    0
    Occupation:
    TSM Administrator
    Hi bissal

    Check the value of TCPServeraddress

    Problem is here !

    SErvername TSMSERVER_NAME
    COMMMethod TCPip
    TCPPort 1500
    TCPServeraddress Wrong here
    TCP Serveraddress :DNS Host name of server (Not TSM server name )

    output of hostname cmd is the value

    # hostname

    Pls check the host name of system and change the value
     
  16. tejodeep

    tejodeep New Member

    Joined:
    Dec 24, 2008
    Messages:
    17
    Likes Received:
    0
    HI bisaal,

    please check if you have given full permissions for dsm.sys and dsmerror.log in default tdp_r3 directory if its 64 bit make sure that you use 64 bit dsm.sys

    and also .profile you need to enter environment variables like
    DSMI_DIR
    DSMI_CONFIG
    DSMI_LOG

    export them in oracle user .profile

    and also make sure that /usr/tivoli/..../api/bin64/dsm.sys
    you have given parameters same as in dsm.sys in tdp_r3/bin64/dsm.sys

    and it is linked as showed in redbook

    and also make sure that prole is running in background with port 57323
     
  17. avinim8

    avinim8 New Member

    Joined:
    Mar 9, 2007
    Messages:
    54
    Likes Received:
    1
    Hi guys,
    I have managed to configure TDP for SAP and run proper backups using the BRtools command line wizard (that uses the BACKINT to start the backup).
    I have several options of managing retentions for the backed up data:
    1. using the backup copy group values
    2. setting those settings to NOLIMIT and configure the retention using the UTL file.

    How can I manage retention for different backups (Daily, Weekly, Monthly, Yearly)?
    Should I use different nodes for that?

    Thank you very much
     
  18. nezih

    nezih Senior Member

    Joined:
    Oct 1, 2002
    Messages:
    765
    Likes Received:
    9
    Location:
    istanbul
    SAP recommends 28 days for retention, what would you do with the older backups than 1 month? would you really need it? who builds the sap backup strategy? I never see any restore older than 3 days on sap..
     
  19. avinim8

    avinim8 New Member

    Joined:
    Mar 9, 2007
    Messages:
    54
    Likes Received:
    1
    Well, that may be right but the organization is obliged to regulations that requires several sets of backups
    daily
    weekly
    monthly
    yearly

    do you any clue in how to achive this kind of regulations directed backup?
     
  20. nezih

    nezih Senior Member

    Joined:
    Oct 1, 2002
    Messages:
    765
    Likes Received:
    9
    Location:
    istanbul
    use more than one initSID.utl file contains different node names and management class for your server... than you'll need use more than one initSID.sap
     
  21. Rai

    Rai New Member

    Joined:
    Jul 22, 2008
    Messages:
    54
    Likes Received:
    4
    Location:
    Germany
    you do not need to use different nodename, it's enough to use different management classes. With different nodenames you may run into an restore nightmare.
     
: sap, tdp oracle

Share This Page