Oracle Technologies Blog

By ASKM

TIVOLI TAPE CONFIGURATION FOR DATABASE BACKUPS

Posted by Srikrishna Murthy Annam on May 27, 2011

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

Advertisements

6 Responses to “TIVOLI TAPE CONFIGURATION FOR DATABASE BACKUPS”

  1. Sunny said

    Very nice article and it helped to understand the tape configuration concepts so well. Thanks So much again.

  2. SMJ said

    Can you please share the video link my email id jani.smj@rediffmail.com

  3. learnwithme11g said

    you are given access to this video now.

  4. samz said

    Fantastic Stuff …I have gone through the web pages and found all the stuff (especially Videos) created , is really helpful. I must say u have put ur best efforts to make others understand the concepts. Hats off to u.

    I am added into ur followers list “Man”.

    Please keep on adding valuable videos regularly.

    Please get me the access of this video.

  5. Nolimer said

    Good day,

    Can i request to have a permission to view the video? it will help me alot. Thank you. nolimer.cabanilla@gmail.com

  6. Hi Sri,

    This is a great doc. So, I would like to see also the video.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: