Rman & Tsm

[Rouen]

Hi there

I have been setting up TDP for Oracle for quite a few servers on AIX but I usually do the TSM bit and the Oracle DBA does his bit.

However, I would like to do the initial bit myself.

After installing the software, linking the library, etc, I now need to make sure that RMAN 'talks' to TSM.

I've read the installation instructions but cannot get the "run ...... allocate channel....." bit to work.

Does anymore PLEASE have a very simple way for me to get this connectivity tested.

I always run into problems here and I look like a fool because I keep have to ask the Oracle DBA's to help. I would like to ensure that RMAN can talk to TSM ... BEFORE I handover to the DBA.

All advice will be highly appreciated.

Kind regards,

Rouen M. Oostewahl

 

[rchoudarapu]

The command TDPOCONF SHOWENV from the client should contact the server and you will see that a session started and ended at TSM server's actlog... This will serve as a connectivity test outside the RMAN part...

 

[toxy13]

The command TDPOCONF SHOWENV from the client should contact the server and you will see that a session started and ended at TSM server's actlog... This will serve as a connectivity test outside the RMAN part...

I think this will test the connectivity between TSM TDP Node and TSM Server, but not between RMAN and TDP Client - I think you should try start RMAN and use SHOW ALL to see all configured parameters and controll your settings!

 

[Flip]

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; }