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]