Hi Finn,

TDP for ORACLE for UNIX (and probably windows) states that all the files
generated have unique names. further down (pg 35/36) it states VERED and
RETO must be set to zero, and that the frequency, verexists, retextra, mode
and serialisation parameters are completely ignored.

You must remove them manually using the RMAN script. And ensure the node
setting for backdelete=yes on the server. look in the manual for more
detailed instructions.

hope this helps!

Matthew

-----Original Message-----
From: Leijnse, Finn F SITI-ISES-31 [mailto:[EMAIL PROTECTED]]
Sent: 13 November 2001 12:32
To: [EMAIL PROTECTED]
Subject: TDP for oracle and data growth.


Hi TSM specialists,

We have encountered a problem with a server that uses TDP for oracle.
One of our server now has a total of about 9 TB of data on our tape pool !!!
What we found out is that this is caused by the fact that everytime TDP
sents data to our TSM server it gives the "file" a new name so all versions
are still active and growing !! growing !! growing !!
Which is OK for the bill we send to the customer but not really a desirable
situation.

Any idea's on how to delete the data or how to prevent this from happening?

set up of mgt_class:

Vexits 28
Vdeleted 0
Rextra NOLIMIT
Ronly 0

> met vriendelijke groeten, regards et salutations,
>
> Finn Leijnse
>
> ISES/31 - Central Data Storage Management
> Shell Services International bv.
> email: [EMAIL PROTECTED]
>


http://www.phoenixitgroup.com
******************Internet Email Confidentiality Footer*******************

Phoenix IT Group Limited is registered in England and Wales under company
number 3476115.  Registered Office: Technology House, Hunsbury Hill Avenue,
Northampton, NN4 8QS

Opinions, conclusions and other information in this message that do not
relate to the official business of our firm shall be understood as neither
given nor endorsed by it.

No contracts may be concluded on behalf of our firm by means of email
communications.

Confidentiality: Confidential information may be contained in this message.
If you are not the recipient indicated (or responsible for delivery of the
message to such person), you may not take any action based on it, nor should
you copy or show this to anyone; please reply to this email and highlight
the error to the sender, then delete the message from your system.

Monitoring of Messages: Please note that we reserve the right to monitor and
intercept emails sent and received on our network.
Warning:  Internet email is not 100% secure. We ask you to understand and
observe this lack of security when emailing us. We do not accept
responsibility for changes made to this message after it was sent

Viruses: Although we have taken steps to ensure that this email and any
attachments are free from any virus, we advise that in keeping with good
computing practice the recipient should ensure they are actually virus free.

Reply via email to