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 <Jbaechi AT CSCC DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
02/06/2003 01:27 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        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
jbaechi AT cscc DOT edu


>>> rehorst AT POHA DOT COM 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:  rehorst AT poha DOT com
Phone:  (713)670-2443
Fax:      (713)670-2457
TOPAS web site: <www.homestead.com/topas/topas.html>