TDP for SAP for oracle

[bisaal46]

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?

 

[toxy13]

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

 

[tenshi]

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.

 

[bisaal46]

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??

 

[Rai]

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

 

[Shhyam]

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 !

 

[tejodeep]

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

 

[daya]

please tell me how install TDP for SAP

 

[Shhyam]

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 !

 

[Shhyam]

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

 

[tejodeep]

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

 

[daya]

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

any user manual in pdf and what is scope of work in this project

 

[tejodeep]

any user manual in pdf and what is scope of work in this project

follow the link which i posted in previous quote

Thanks

 

[Shhyam]

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

 

[tejodeep]

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

 

[avinim8]

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

 

[nezih]

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..

 

[avinim8]

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?

 

[nezih]

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

 

[Rai]

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.