I have configured RMAN and TDP for oracle 8.1.7 - and its working great without any problem - Requires good knowledge of oracle . i.e. Creating catalog database -tablespace user in oracle etc... if you don't know oracle then it is difficult - ask help from your DBA , once you setup oracle part then second step is configure tdpo.option file - relink - write backup script --
f2n17 /d01/app/oracle > cat bkdb.sh . /d01/app/oracle/.tdp.ora rman target / rcvcat rman/rman cmdfile /d01/app/oracle/bkdb.scr msglog /tmp/bkdb.log f2n17 /d01/app/oracle > cat bkdb.scr run { allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; backup filesperset 4 format 'df_%t_%s_%p' (database); release channel t1; } f2n17 /d01/app/oracle > ./bkdb.sh f2n17 /d01/app/oracle > Done .. where is complexity? BTW : Does any one know if oracle 9.2.0.1.0 is supported with TDP 2.2.1 ? Cheers Shekhar Dhotre LEnd lease GSDC Atlanta ,GA-30346. Jin Bae Chi <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/06/2003 01:27 PM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: TSM for Oracle Orin, With due respect, I had a hard time to set it up. But, once I learned it, it has been working greate for me. If you could share more about the problem you're encounting, I believe everyone would be willing to help you. Actually, I got a big help from this list. Our Oracle db is not very big, but backups works great from TSM scheduler. I don't mean to doubt your pain dealing with the product. Thanks. Jin Bae Chi (Gus) System Admin/Tivoli Data Center, CSCC 614-287-5270 614-287-5488 Fax [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 02/06/03 12:04PM >>> Due to the complexity of using TSM for Oracle, management here is about ready to replace TSM altogether. Anyone know of a class available for this topic? BTW, IBM has a web page for such a course listed at http://www-3.ibm.com/software/tivoli/education/J104126F96394E48.html, but an IBM employee told me the course doesn't actually exist! Regards, Orin Orin Rehorst Port of Houston Authority (Largest U.S. port in foreign tonnage) e-mail: [EMAIL PROTECTED] Phone: (713)670-2443 Fax: (713)670-2457 TOPAS web site: <www.homestead.com/topas/topas.html>