Yes there is a way to change this. By specifying the option:

TDPO_AVG_SIZE   n  (where 'n' is the size estimate, in MB, you want TDP
Oracle to use with the TSM Server)

Using this option overrides any size that Oracle specifies and can cause
other performance problems on the the TSM Server. However, this option is
very useful if you are using compression and the TSM Server is up against
the wall with regards to availabe storage space for backups.


Regards,

Neil Rasmussen
Software Development
Data Protection for Oracle
rasmussn AT us.ibm DOT com




"Wholey, Joseph (IDS DM&DS)" <joseph_wholey AT ML DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
12/06/2004 09:24 AM
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: TDP/ORACLE Backup






Is it possible to change the estimated size?

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Neil Rasmussen
Sent: Monday, December 06, 2004 12:07 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TDP/ORACLE Backup


Keep in mind that TDP Oracle just passes on what Oracle/Rman asks it to.
So for DB estimation, TDP Oracle uses the value that Oracle passes to it
(which probably is overestimated). If compression is turned on then this
value is grossly overestimated.


Regards,

Neil Rasmussen
Software Development
Data Protection for Oracle
rasmussn AT us.ibm DOT com




"Wholey, Joseph (IDS DM&DS)" <joseph_wholey AT ML DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
12/06/2004 08:08 AM
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
TDP/ORACLE Backup






When running a TDP for Oracle backup, does TDP lock the estimated amount
of the storage pool which it thinks it needs to complete the backup?
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain
or redistribute it. Click here for important additional terms relating to
this e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------