With little information to go on the only difference I can see is the recommendation to put this node into its own domain. Since everything else seems to be the same are you saying that the errors they received on the restore are related to that? Because according to the dba it was not the backup that reported the problem it was the restore.
Thanks, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: Wednesday, November 22, 2006 8:46 AM To: [email protected] Subject: Re: Oracle Agent help 1). When you install the client, the default dir for config files is: /usr/tivoli/tsm/client/oracle/bin64 (or bin) 2). We just installed and did a basic config and a successful backup. The DBA set up the Oracle catalog on a server and I configured the tdpo.opt file as so: DSMI_ORC_CONFIG /usr/tivoli/tsm/client/api/bin64/dsm.opt DSMI_LOG /home/oracle/tsm TDPO_FS TDPO_FS TDPO_NODE TDP_DBA2DBMS TDPO_OWNER oracle TDPO_PSWDPATH /usr/tivoli/tsm/client/api/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 *----------------------------------------------------------------------- ----------------- TDPO_FS TDPO_FS (is as the file will show as the filespace name when you do a 'q file' under TSM) TDPO_NODE TDP_DBA2DBMS( is the node name registered with TSM) 3) The install manual recommends setting up a separate domain with explicit management class definitions so they are the defaults for Oracle backups. We did that. DSM.OPT: /usr/tivoli/tsm/client/api/bin64 # more dsm.opt SErvername backup DSM.SYS /usr/tivoli/tsm/client/api/bin64 # more dsm.sys SErvername backup * COMMMETHOD TCPIP * TCPPort 1500 TCPServeraddress 172.30.3.86 passwordaccess prompt * mailprog /bin/mail root * errorlogretention 7 nodename TDP_DBA2DBMS >>> [EMAIL PROTECTED] 11/22/06 11:19 AM >>> Admittedly I have very limited knowledge on this subject so I hope you can pardon my ignorance while I ask some questions. This is something we (the dbas) have not used for some years and are only now trying to get working again. The TSM server is on AIX 5.3 TSM 5.3.3.0, and this particular client is at 5.3.4 on HP-UX Itanium. The agent level they installed is 5.2.3.0 from the looks of the info they sent me, yet they say they just got it from IBM so I am confused since I have 5.3.3. for them if they would have just talked to me. Perhaps the best thing to do is upgrade but I think it will not fix the errors since it is more than likely some sort of config problem to start. The dbas here now have no experience with this product, and although he says hes configured it properly some things stick out at me as being wrong based on some of the email I have saved from the group. To start I have created a management class and node specifically for this client. It is not in its own domain so it is not the default class, and I dont think that is a problem, however I am guessing the tdpo.opt needs this information, see below, but they have that section commented out and the names listed are not the one I created. Should this be fixed and is there something else missing from the file. The dsm.opt for the client only has the servername and the dsm.sys a bit more but not sure if those entries are relevant so they are not listed here. Hopefully someone can decipher all of this and help me out. DSMI_ORC_CONFIG /opt/tivoli/tsm/client/api/bin64/dsm.opt DSMI_LOG /opt/tivoli/tsm/client/oracle/logs TDPO_FS oracle10gdb TDPO_NODE o-cppsdbd1 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 They say they ran a backup, and from a TSM perspective what I see is one filespace, oracle10gdb, within TSM which seems to be 4 files. RMAN> run 2> { 3> ALLOCATE CHANNEL t1 TYPE 'sbt_tape' parms 4> 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; 5> backup backupset all; 6> } allocated channel: t1 channel t1: sid=504 instance=PSHDMO1 devtype=SBT_TAPE channel t1: Data Protection for Oracle: version 5.2.3.0 Starting backup at 06-NOV-06 input backupset count=125 stamp=605788428 creation_time=06-NOV-06 channel t1: starting piece 1 at 06-NOV-06 channel t1: backup piece /d1/app/oracle/product/cur_rev/db/dbs/3ti1n68c_1_1 piece handle=3ti1n68c_1_2 comment=API Version 2.0,MMS Version 5.2.3.0 channel t1: finished piece 1 at 06-NOV-06 channel t1: backup set complete, elapsed time: 00:00:25 Finished backup at 06-NOV-06 released channel: t1 A restore however failed and below is most of what was in the logs. I have cut out numerous data file lines between 5 and 123 as they were all the same. RMAN> run 2> { 3> ALLOCATE CHANNEL t1 TYPE 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; 4> RESTORE DATABASE VALIDATE; 5> } using target database control file instead of recovery catalog allocated channel: t1 channel t1: sid=500 instance=PSHDMO1 devtype=SBT_TAPE channel t1: Data Protection for Oracle: version 5.2.3.0 Starting restore at 10-NOV-06 data file 5 will be created automatically during restore operation data file 123 will be created automatically during restore operation released channel: t1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 11/10/2006 16:58:09 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 4 found to restore RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no backup or copy of datafile 2 found to restore RMAN-06023: no backup or copy of datafile 1 found to restore Thanks and Happy Thanksgiving to all who celebrate, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED] The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments.
