TDP for new ORACLE_HOMEs

If you have previously installed and configured TSM with TDP (Tivoli Data Protect/Tivoli for Databases) then you need to perform this step each time you install a new ORACLE_HOME (e.g. as part of an Upgrade).

ln -s /usr/lib/libobk64.a $ORACLE_HOME/lib/libobk.a

Install

Copy installation files to /u01/img/TSM on the target server and uncompress.

As 'root'...

smitty install_latest

Check that the fields are set as above and hit return to install.

As 'oracle'...

ln -s /usr/tivoli/tsm/client/oracle/bin64/libobk64.a $ORACLE_HOME/lib/libobk.a

Configure

Values in italics must be discussed with your TSM administrator...

tdpo.opt

cd /usr/tivoli/tsm/client/oracle/bin64

cp tdpo.opt.smp tdpo.opt

Edit the tdpo.opt file to include these options:

dsmi_orc_config /usr/tivoli/tsm/client/oracle/bin64/dsm.opt

dsmi_log <directory with write permissions>

dsm.opt

cd /usr/tivoli/tsm/client/oracle/bin64

 Create a dsm.opt file to include the following server stanza:

Servername tdpo

dsm.sys

cd /usr/tivoli/tsm/client/api/bin64 

ln -s /usr/tivoli/tsm/client/ba/bin/dsm.sys. dsm.sys

Edit the dsm.sys file to include another server stanza with the following options:

SErvername tdpo

COMMMethod TCPip

TCPServeraddress 99.99.99.99

PASSWORDAccess generate

passworddir /usr/tivoli/tsm/client/oracle/bin64/

nodename hostname_ORA

Register ORA Node

To be performed by TSM Admin

Register the node to the Tivoli Storage Manager server with the following command:

REG NODE hostname_oracle password maxnummp=n

Check File and Folder Permissions

ls -ld /usr/tivoli/tsm/client/oracle/bin64

drwxrwxrwx    3 root     system         4096 Jan 08 06:16 /usr/tivoli/tsm/client/oracle/bin64

ls -ld /usr/tivoli/tsm/client/api/bin64

drwxr-xr-x   18 root     system         4096 Nov 21 05:59 /usr/tivoli/tsm/client/api/bin64

Read permission (r-) to the tdpo.opt, dsm.opt, and dsm.sys files in the 

ls -l /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt

-rw-r--r--    1 root     system          143 Jan 30 2015  /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt

ls -l /usr/tivoli/tsm/client/oracle/bin64/dsm.opt

-rw-r--r--    1 root     system           35 Jan 30 2015  /usr/tivoli/tsm/client/oracle/bin64/dsm.opt

ls -l /usr/tivoli/tsm/client/api/bin64/dsm.sys

.lrwxrwxrwx    1 root     system           39 Oct 20 03:06 /usr/tivoli/tsm/client/api/bin64/dsm.sys -> /usr/tivoli/tsm/client/ba/bin64/dsm.sys

Set TDP Node Password

As 'oracle'...

cd /usr/tivoli/tsm/client/oracle/bin64

tdpoconf password 

Remember to update your secure password repository

Check TDP Conf

As 'oracle'...

tdpoconf showenvironment

Testing

The simplest test is to perform an RMAN backup of archived redo log files...

As 'oracle'...

rman target /

run{

allocate channel t1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

backup archivelog all;

delete archivelog all backed up 1 times to device type 'SBT_TAPE';

release channel t1;

}

Bibliography