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