Andrew,
directly backing up the database files tends to wasting lots of storage
space in TSM as you not only do uncompressed but very uncompressed
backups (especially when your db is quite new and has larger free
capacity). When you have enough diskspace on your Oracle server, why not
use RMAN to write backups (and subsequent incremental backups) on disk
and back up these files with TSM?

Best regards,
Michael
--
Michael Bartl, Dipl. Inform. (FH)           mailto:michael.bartl AT cw DOT com
Michael Bartl, Dipl. Inform. (FH)           mailto:michael.bartl AT cw DOT com
Backup Services, IT Germany/Austria         Tel: +49-89-92699-806
Cable & Wireless Deutschland GmbH.          Fax: +49-89-92699-302
Landsberger Str. 155, D-80687 Muenchen      http://www.cw.com/de


Andrew Hull wrote:
>
> I want to be able to backup a mixture of oracle 8 and 9 databases. I will
> shut oracle down at night so i don't have to use the TDP.
> I am using TSM4.2.1 on NT4.0 , when i backup the databases files will every
> file need backing up. for example. one of our databases is spread over 19
> 4gb files. will each one get backed up each night?
>
> Andy
>
> DISCLAIMER: The information contained in this e-mail is confidential and may
> be privileged. It is intended for the addressee only.   If you are not the
> intended recipient, please delete this e-mail immediately.   The contents of
> this e-mail must not be disclosed or copied without the sender's consent. We
> cannot accept any responsibility for viruses, so please scan all
> attachments. The statements and opinions expressed in this message are those
> of the author and do not necessarily reflect those of the company. The
> company does not take any responsibility for the views of the author.
>
> ________________________________________________________________________
> This e-mail has been scanned for all viruses by Star Internet. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
> ________________________________________________________________________