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:[EMAIL PROTECTED] Im Auftrag von goc Gesendet: Montag, 13. November 2006 16:04 An: ADSM-L@VM.MARIST.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" <[EMAIL PROTECTED]> To: <ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] Behalf Of goc Sent: maandag 13 november 2006 14:49 To: ADSM-L@VM.MARIST.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