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:[email protected]] On Behalf Of Kelly Lipp Sent: Thursday, January 21, 2010 1:31 PM To: [email protected] 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:[email protected]] On Behalf Of Sujatha chk Sent: Thursday, January 21, 2010 12:43 PM To: [email protected] 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 [email protected] via Backup Central. |Forward SPAM to [email protected]. +----------------------------------------------------------------------
