askMLabs

In the present article i am going to explain the tivoli tape configuration for oracle backups to tape. I am explaining this considering the oracle DBAs and not from the scratch how it should be installed.
DBAs need to configure the tape backups after system administrators installing the tape libraries.
DBAs start their configuration with the confirmation that the tape libraries are installed properly. To check the tape installation , try to execute the commands tdpoconf or tdposync and if they are not found, get the installation directory from the system admins and include the directory in the PATH env variable. Then  execute the command again and you should be able to execute the commands tdpoconf and tdposync successfully. If you still not able to execute, check if the tape libraries are installed for 32bit or 64bit. Make proper corrections that these executable are linked to correct bit version corresponding to your OS.

Example :

[root@b600e6tr01 bin]# ls -lrt tdpo*
lrwxrwxrwx 1 root root 42 Dec 21 20:56 tdposync -> /opt/tivoli/tsm/client/oracle/bin/tdposync
lrwxrwxrwx 1 root root 42 Dec 21 20:56 tdpoconf -> /opt/tivoli/tsm/client/oracle/bin/tdpoconf
[root@b600e6tr01 bin]#
[root@b600e6tr01 bin]# ln -s /opt/tivoli/tsm/client/oracle/bin64/tdpoconf tdpoconf
[root@b600e6tr01 bin]# ln -s /opt/tivoli/tsm/client/oracle/bin64/tdposync tdposync
[root@b600e6tr01 bin]# ls -lrt tdpo*
lrwxrwxrwx 1 root root 44 May  2 02:12 tdpoconf -> /opt/tivoli/tsm/client/oracle/bin64/tdpoconf
lrwxrwxrwx 1 root root 44 May  2 02:12 tdposync -> /opt/tivoli/tsm/client/oracle/bin64/tdposync
[root@b600e6tr01 bin]#

After confirming that the tape libraries are installed properly, now you need to configure the tape configuration to backup the databases. There are two important configuration files which are important to DBAs for configuration. They are tdpo.opt tape configuration file and password file.

Edit the tdpo.opt file and modify the parameter to reflect to your environment. Important parameters to modify in the tdpo.opt file are TDPO_FS,TDPO_NODE and TDPO_OWNER.

Using this modified configuration file, create a password file using command

tdpoconf passw -tdpo_optfile=tdpo.opt

The password file will be of the form TDPO.<node name> where the node name is defined in the tdpo.opt file.

After creating a new password file, modify the parameter TDPO_PSWDPATH in tdpo.opt file again to include the newly created password file.

Then the final step is to check the tape configuration ....

tdpoconf showENVironment -TDPO_OPTfile=tdpo.opt

If you are able to execute the above command successfully, then your tape configuration is complete.

Sample Configuration file :

$ cat tdpo.opt
***************************************************************************
* IBM Tivoli Storage Manager for Databases
*    Data Protection for Oracle
*
* Sample tdpo.opt for the LinuxAMD64 Data Protection for Oracle
*********************************************************************
DSMI_ORC_CONFIG    /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG           /var/log/tdp
*TDPO_FS            /tdp_<sid>
TDPO_FS             /tdp_TESTDB
TDPO_NODE           tdpb600e6tr01
TDPO_OWNER          oracle
TDPO_PSWDPATH      /opt/tivoli/tsm/client/oracle/bin64
*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
[oracle@b600e6tr01 tdpo]$

NOTE : The * mark in the above file indicates that  the parameter is commented.

$ tdpoconf showENVironment -TDPO_OPTfile=tdpo.opt
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 5, Level 2.0
(C) Copyright IBM Corporation 1997, 2009. All rights reserved.
Data Protection for Oracle Information
Version:              5
Release:              5
Level:                2
Sublevel:             0
Platform:             64bit TDPO Linux86-64
Tivoli Storage Manager Server Information
Server Name:          TDPAURORA
Server Address:       GBTSMSERVER
Server Type:          AIX-RS/6000
Server Port:          1500
Communication Method: TCP/IP
Session Information
Owner Name:           oracle
Node Name:            tdpb600e6tr01
Node Type:            TDPO Linux86-64
DSMI_DIR:             /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG:      /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE:         tdpo.opt
Password Directory:   /opt/tivoli/tsm/client/oracle/bin64
Compression:          FALSE
License Information:  License file exists and contains valid license data.
[oracle@b600e6tr01 tdpo]$

Now backups are performed by configuring a channel to tape using above tape configuration file

run
{
allocate channel t1 type 'SBT_TAPE' parms="ENV=(TDPO_OPTFILE=tdpo.opt)";
allocate channel t2 type 'SBT_TAPE' parms="ENV=(TDPO_OPTFILE=tdpo.opt)";
allocate channel t3 type 'SBT_TAPE' parms="ENV=(TDPO_OPTFILE=tdpo.opt)";
....
your backup commands
...
}

Please follow the below video for more details .....( Send me a personal request if you want to access this VIDEO )


Reference Link:
http://publib.boulder.ibm.com/tividd/td/ITSMFD/SC32-9065-00/en_US/HTML/ab5w0009.htm

HOPE IT HELPS

SRI