I'm no oracle DBA but I learned how to do the complete install process and
RMAN backup.
Here's the steps I take for a Solaris box........
Installing TDP client
using the TDP tar file disk I got from Passport Advantage........
cd /cdrom0
find the subdir for the CD you loaded
mkdir /opt/tivoli/tsm/tdpfiles
copy the tar file to that dir example....
cp LK4T-2454-00.tar /opt/tivoli/tsm/tdpfiles
cd /opt/tivoli/tsm/tdpfiles
tar xvf LK4T-2454-00.tar
cd LK4T-2454-00/oracle/solaris64
chmod u+x 5.4.1.0-TIV-TSMORA-SolarisSparc64.bin
./5.4.1.0-TIV-TSMORA-SolarisSparc64.bin -console to extract
OR for x86 TDP client
cd /var/tmp/TDP/LK4T-2454-00/oracle/solarisx86_64
cp 5.4.1.0-TIV-TSMORA-SolarisX86_64.bin /opt/tivoli/tsm/tdpfiles
cd /opt/tivoli/tsm/tdpfiles
chmod u+x 5.4.1.0-TIV-TSMORA-SolarisX86_64.bin
./5.4.1.0-TIV-TSMORA-SolarisX86_64.bin -console to install
verify installation by entering these commands:
pkginfo TDPOLic64
pkginfo TDPOUt64
pkginfo TDPOrc64
///////////////////////////////////////////////////////
Client is now installed. Time to configure
cd /opt/tivoli/tsm/client/oracle/bin64
cp tdpo.opt.smp tdpo.opt
vi tdpo.opt to make it look like this..(change node name).........
*******************************************************
* TDPO.OPT
*******************************************************
DSMI_ORC_CONFIG /opt/tivoli/tsm/client/ba/bin/dsmfortdp.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/bin
TDPO_FS xxxxORC
TDPO_NODE xxxxDB01-DB
TDPO_OWNER oracle
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin
*TDPO_DATE_FMT 1
*TDPO_NUM_FMT 1
*TDPO_TIME_FMT 1
*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4
***********************************************************************
Now set ownership of TDP utilites to oracle:dba
cd /opt/tivoli/tsm/client
chown -R oracle:dba oracle
chmod -R 775 oracle
Next cd /opt/tivoli/tsm/client/ba/bin
Then edit the dsm.sys file to look like this..(make your edits)..
vi dsm.sys
***********************************************************************
*dsm.sys
************************************************************************
Servername TSMSVRxx
TCPSERVERADDRESS xxx.xxx.x.x
TCPPort 1500
Nodename xxxxxx
Passwordaccess generate
compression yes
schedlogretention 7,s
errorlogretention 30,s
inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl.txt
Servername TSMSVRxx-TDP
TCPSERVERADDRESS xxx.xxx.x.x
TCPPort 1500
Nodename xxxxxx
compression yes
schedlogretention 3,s
errorlogretention 30,s
Passwordaccess Prompt
Next, create a new file called dsmfortdp.opt
vi dsmfortdp.opt
************************************************************************
* dsmfortdp.opt
************************************************************************
Servername TSMSVRxx-TDP
Domain /
CompressA No
Tapeprompt No
dateformat 1
Subdir yes
If there isn't already a tsm client on the machine create the dsm.opt
********************************************************
* dsm.opt
************************************************************************
Servername TSMSVRxx
Domain /
CompressA No
Tapeprompt No
dateformat 1
Subdir yes
*****************************************************
Before starting any software....... Define the client to the TSM server using ISC
1. Define new Policy ( for Databases )
2. Have all data sent to existing stg pool
3. Edit standard management class to
verdeleted=0
retonly=0 (days)
4. Make that the default mgmt class
5. Use ISC to create client NODE (your already under the correct domain)
Leave ISC and go back to the client machine.
/opt/tivoli/tsm/client/oracle/bin64
Update the password using this command.....
tdpoconf passw
then check out the environment usig .......
tdpoconf showenv
you should see something like this....
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 4, Level 1.0
(C) Copyright IBM Corporation 1997, 2007. All rights reserved.
Data Protection for Oracle Information
Version: 5
Release: 4
Level: 1
Sublevel: 0
Platform: 64bit TDP Oracle SUN
Tivoli Storage Manager Server Information
Server Name: TSMSVRxx-TDP
Server Address: xx.xxx.xx.x
Server Type: Solaris SPARC
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name: oracle
Node Name: xxxxxx-DB
Node Type: TDP Oracle SUN
DSMI_DIR: /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/ba/bin/dsmfortdp.opt
TDPO_OPTFILE: /opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory: /opt/tivoli/tsm/client/oracle/bin64
Compression: TRUE
License Information: License file exists and contains valid license data.
Now test you media manager
> sbttest a -libname /opt/tivoli/tsm/client/oracle/bin64/libobk.so
you need a return code of 0
Congrats - you've installed and configured TDP
GO backup the database!
RMAN>
run { allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup database plus archivelog; }