TSM/RMAN

Tivoli Storage Manager

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


This installation needs approximately 3.6KB available in the /usr filesystem (this figure for v7.1, other versions may be different).

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

As 'root'...

smitty install_latest


 Install Software
Type or select values in entry fields.Press Enter AFTER making all desired changes.
 [Entry Fields]* INPUT device / directory for software /u01/img/TSM/TSMORA_AIX/usr/sys/inst.images* SOFTWARE to install [_all_latest] + PREVIEW only? (install operation will NOT occur) no + COMMIT software updates? yes + SAVE replaced files? no + AUTOMATICALLY install requisite software? yes + EXTEND file systems if space needed? yes + OVERWRITE same or newer versions? no + VERIFY install and check file sizes? yes + Include corresponding LANGUAGE filesets? yes + DETAILED output? no + Process multiple volumes? yes + ACCEPT new license agreements? yes + Preview new LICENSE agreements? no +
 WPAR Management Perform Operation in Global Environment yes + Perform Operation on Detached WPARs no + Detached WPAR Names [_all_wpars] + Remount Installation Device in WPARs yes + Alternate WPAR Installation Device []

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

** check - are /usr/tivoli/tsm/client/oracle/bin64/libobk64.a and /usr/lib/libobk64.a the same file?

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>

https://www.ibm.com/support/knowledgecenter/SSER7G_8.1.0/db.orc/r_dporc_cfg_options.html

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;

}