Results 1 to 23 of 23
  1. #1
    Member
    Join Date
    May 2008
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default TDP for SAP for oracle

    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. #2
    Senior Member toxy13's Avatar
    Join Date
    Sep 2003
    Location
    Leipzig
    Posts
    739
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    all permissions ok? database users need write/read permissions f.e. dsm.sys file and are all dsm environment variables set right?

  3. #3
    Member
    Join Date
    Mar 2008
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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.

  4. #4
    Member
    Join Date
    May 2008
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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 by bisaal46; 03-18-2009 at 06:16 AM.

  5. #5
    Member
    Join Date
    Jul 2008
    Location
    Germany
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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

  6. #6
    Member
    Join Date
    Apr 2009
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default 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 !

  7. #7
    Member
    Join Date
    Dec 2008
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default 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

  8. #8
    Newcomer
    Join Date
    Jun 2009
    Location
    Gurgaon (India)
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    please tell me how install TDP for SAP

  9. #9
    Member
    Join Date
    Apr 2009
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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 !







  10. #10
    Member
    Join Date
    Apr 2009
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Then Register node with TSM server and also configure DSM.OPT and DSM.SYS ..later run backint to generate password

  11. #11
    Member
    Join Date
    Dec 2008
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default 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/infoce...v1r1/index.jsp

    this link is for tdp for sap on oracle







    please tell me how install TDP for SAP

  12. #12
    Newcomer
    Join Date
    Jun 2009
    Location
    Gurgaon (India)
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Arrow

    Quote Originally Posted by tejodeep View Post
    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/infoce...v1r1/index.jsp

    this link is for tdp for sap on oracle







    please tell me how install TDP for SAP
    any user manual in pdf and what is scope of work in this project

  13. #13
    Member
    Join Date
    Dec 2008
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by daya View Post
    any user manual in pdf and what is scope of work in this project

    follow the link which i posted in previous quote

    Thanks

  14. #14
    Member
    Join Date
    Apr 2009
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Hi bissal

    Check the value of TCPServeraddress

    Problem is here !

    SErvername TSMSERVER_NAME
    COMMMethod TCPip
    TCPPort 1500
    TCPServeraddress Wrong here
    TCP Serveraddress NS 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

  15. #15
    Member
    Join Date
    Dec 2008
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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

  16. #16
    Member
    Join Date
    Mar 2007
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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

  17. #17
    Senior Member nezih's Avatar
    Join Date
    Oct 2002
    Location
    istanbul
    Posts
    765
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Default

    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..
    destruction is not negative! you must destroy to build...

  18. #18
    Member
    Join Date
    Mar 2007
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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?

  19. #19
    Senior Member nezih's Avatar
    Join Date
    Oct 2002
    Location
    istanbul
    Posts
    765
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Default

    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
    destruction is not negative! you must destroy to build...

  20. #20
    Member
    Join Date
    Jul 2008
    Location
    Germany
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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.

  21. #21
    Member
    Join Date
    Mar 2007
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by nezih View Post
    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
    Hi nezih,
    Assuming i'm using several node names to manage the retention and a configuration files set (initSID.sap & initSID.utl), how do i make different backups using BRTools?
    It looks like the BRBackup uses the default values inside the default config files.

    lets say I have the following config files:
    initSID.utl, initSID.sap
    initSID_weekly.utl, initSID_weekly.sap

    Once I run BRTools it uses the default values (initSID.utl, initSID.sap). How can I tell BRTools to use the other config files?

    Thanks

  22. #22
    Member
    Join Date
    Mar 2007
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    anyone?
    How to use several initSID.utl and initSID.sap to backup using the backint utility?

  23. #23
    Senior Member
    Join Date
    Oct 2002
    Location
    netherlands
    Posts
    335
    Thanks
    0
    Thanked 9 Times in 9 Posts

    Default

    Ask you SAP DBA for the brtools flags.

    -p init<SID>.utl for backint
    -p init<SID>.sap for brbackup/brtools

Similar Threads

  1. Replies: 1
    Last Post: 04-08-2008, 04:50 PM
  2. SAP Oracle Log backups
    By fresh in forum Oracle
    Replies: 7
    Last Post: 09-21-2007, 03:46 PM
  3. TDP for SAP (oracle) on HPUX
    By Neo in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 03-06-2007, 06:06 PM
  4. TDP for SAP R/3 on Oracle on Linux DSM question
    By cheffern in forum TDP/Application Layer Backup
    Replies: 4
    Last Post: 03-08-2006, 01:07 PM
  5. TDP for SAP - Multiple SAP DBs on same system
    By romeyer in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 01-22-2003, 07:25 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •