We let RMAN handle the deletion of backup sets and pieces. Every backup
has an unique set and piece name and will never be duplicated.  RMAN
will tell the TSM server when to expire the backups. 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Kelly Lipp
Sent: Thursday, January 21, 2010 1:31 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Data retention period 60days

Figure out which management class is governing your Oracle backups.  Q
node nodename where nodename is the name the client uses to identify
itself.  Check to see which policy domain the node is in.

Q copy domainname f=d

You'll probably see verexists=2, verdel=1 retextra=30 retonly=60.

The most accurate settings for a 60 day retention (which is a long time
for a database IMHO) should be 

verexists=60, verdel=60 retextra=60 retonly=60

So,

Update copy domainname policysetname magagementclassname STANDARD
verexists=60 verdel=60 retextra=60 retonly=60

Then activate the policyset:

Activate policyset domainname policysetname

And you're done.

It is likely that the policyset and managementclassname is STANDARD as
well.  If I had set up your system the commands would look like

Update copy ORACLE STANDARD STANDARD STANDARD verexists=60 verdel=60
retextra=60 retonly=60
Activate ORACLE STANDARD

Kelly Lipp
Chief Technology Officer
www.storserver.com
719-266-8777 x7105
STORServer solves your data backup challenges. 
Once and for all.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Sujatha chk
Sent: Thursday, January 21, 2010 12:43 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Data retention period 60days

Hi Gurus,

we backup our oracle database using rman to TAPE by TSM media
management. Currently  Backup Retention policy has been set to 30 days.
Please guide me on how to configure Back up Retention period to 60 days?

-Sujatha

+----------------------------------------------------------------------
|This was sent by sujatha.chk AT gmail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------