We backup all databases from one physical machine to one TSM node.
Every Oracle Database gets ist own tdpo.opt file in the RMAN definition.
When we backup database "DB01" our tdpo.opt file is named tdpo_DB01.opt
and the tdpo_fs is set to "DB01" as well.
So you can easily delete backup pieces on the tsm server when the database
gets obsolete.
Thomas Rupp
-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag
von goc
Gesendet: Montag, 13. November 2006 16:04
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: [ADSM-L] setting up TDPO / newbie help
thanks all, i managed this okay, it works ... but i have another question !
tdpo_fs is "virtual" file space name, right ? in manual it says i should use
it i have more than one oracle db (i have) , but how to use it ?
tdpo_node - is used for node name, but what if i have multiple oracle db's
which are using they own nodes, does this mean that i have to backup
all databases as one node only differentiating in "tdpo_fs" name or their
real filespace name ?
if license is not valid will i be able to do backups ? i have license for
version 2.2 but only for windows since the 2.2 cannot be installed on
AIX 5.3 ML5 64bit (bos.rte v=4, r<4)
sorry if questions are odd but i'm new in this and i have a lot of questions
since the ab5u0002.pdf is not what i expected :-)
thanks a lot
----- Original Message -----
From: "Ruud van Ruler" <ruud.vanruler AT SHELL DOT COM>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Monday, November 13, 2006 3:11 PM
Subject: Re: setting up TDPO / newbie help
check /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt and config file :
more /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the AIX Data Protection for Oracle 64bit
*********************************************************************
DSMI_ORC_CONFIG /local/etc/tsm/bin/dsm.opt
*DSMI_LOG <dirname>
*TDPO_FS orc9_db
TDPO_NODE pat2124
TDPO_OWNER oracle
TDPO_PSWDPATH /usr/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
/local/bin/oracle/tdp_settings
# more CMEMPRODconfig
DSMI_ORC_CONFIG /local/bin/oracle/tdp_settings/dsm.opt
DSMI_DIR /usr/tivoli/tsm/client/api/bin64
DSMI_LOG /local/bin/oracle/tdp_settings
TDPO_FS adsmorcCMEMPROD
TDPO_NODE pat2124
TDPO_OWNER oracle
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64
TDPO_AVG_SIZE 500
TDPO_NUM_BUFFERS 5
* TDPO_MGMT_CLASS_2 <class_name>
* TDPO_MGMT_CLASS_3 <class_name>
* TDPO_MGMT_CLASS_4 <class_name>
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
goc
Sent: maandag 13 november 2006 14:49
To: ADSM-L AT VM.MARIST DOT EDU
Subject: setting up TDPO / newbie help
hi, i'm running this ...
./tdpoconf
SHOWENV -TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt -OUTF=out.log
but i constantly get
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 3, Level 3.0
(C) Copyright IBM Corporation 1997, 2006. All rights reserved.
ANS1035S (RC406) Options file '*' could not be found.
#
the content of install dir ...
# pwd
/usr/tivoli/tsm/client/oracle/bin64
# ls -lrt
total 4560
-rwxr-xr-x 1 bin bin 691 May 26 03:19 tdpo.opt.smp64
-rwxr-xr-x 1 bin bin 825939 May 26 03:26 libobk64.a
-rwxr-xr-x 1 bin bin 757873 May 26 03:27 tdposync
-rwxr-xr-x 1 bin bin 727710 May 26 03:27 tdpoconf
drwxr-xr-x 2 root system 256 Nov 13 13:14 en_US
-rwxr-xr-x 1 root system 779 Nov 13 14:34 NEW_tdpo.opt
-rwxr-xr-x 1 root system 691 Nov 13 14:36 tdpo.opt
-rw------- 1 root system 589 Nov 13 14:43 tdpoerror.log
#
# cat tdpoerror.log
11/13/06 14:43:46 TID<778586> ==> ANS1035S (RC406) Options file '*' could
not be found.
1/13/2006 14:12:04 TID<839956> ==> ANU2615E Options file 'dsm.opt' not
found.
11/13/2006 14:14:11 TID<618804> ==> ANU2615E Options file '/tdpo.opt' not
found.
11/13/2006 14:36:54 TID<704968> ==> ANU2615E Options file
'/usr/tivoli/tsm/oracle/bin64/tdpo.opt' not found.
11/13/2006 14:39:15 TID<389582> ==> ANU2615E Options file
'/usr/tivoli/tsm/oracle/bin64/tdpo.opt' not found.
11/13/2006 14:41:34 TID<778564> ==> ANU2615E Options file
'/usr/tivoli/tsm/oracle/bin64/tdpo.opt' not found.
----
what am i doing wrong ? the pdf is confusing very much , for example :
"...Specify the complete path to the Tivoli Storage Manager client
user options
file (dsm.opt) used during the Data Protection for Oracle session.
If you do
not specify this option..."
that means that dsm.sys is not looked for ?
do i have to put something into /opt/tivoli/tsm/client/api/bin dir ?
thanks,
goran
AIX 5.3
TSM 5.3
client 5.3
tdpo 5.3
|