Re: Rman not deleting old backups
Hello, In certain case, rman do not remove expired backup. You have to use tdposync for find/remove manualy backups. Regards, Cordialement, Grégory Molin Tel : 0141628162 gregory.mo...@afnor.org -Message d'origine- De : ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] De la part de David E Ehresman Envoyé : vendredi 22 juillet 2011 17:35 À : ADSM-L@VM.MARIST.EDU Objet : [ADSM-L] Rman not deleting old backups Awhile back someone shared on this list their commands/scripts for verifying that rman was not leaving any old backups on the TSM server. I can't seem to find it now. Ring a bell with anyone? David ATTENTION. Ce message et les pièces jointes sont confidentiels et établis à l'attention exclusive de leur destinataire (aux adresses spécifiques auxquelles il a été adressé). Si vous n'êtes pas le destinataire de ce message, vous devez immédiatement en avertir l'expéditeur et supprimer ce message et les pièces jointes de votre système. This message and any attachments are confidential and intended to be received only by the addressee. If you are not the intended recipient, please notify immediately the sender by reply and delete the message and any attachments from your system.
Re: Rman not deleting old backups
Yes, that's what I was looking for. Thanks, David Ehresman David Bronder david-bron...@uiowa.edu 7/22/2011 8:18 PM David E Ehresman wrote: Awhile back someone shared on this list their commands/scripts for verifying that rman was not leaving any old backups on the TSM server. I can't seem to find it now. Ring a bell with anyone? David, is this the thread you're remembering (both Eric van Loon I provided select statements that seem related to what you're looking for)? Nested SQL? http://www.mail-archive.com/adsm-l@vm.marist.edu/msg82918.html (My Oracle DBA just cleaned up about 45 TB of stale/orphaned/obsolete RMAN backups based on the report I send him monthly...) -- Hello World.David Bronder - Systems Admin Segmentation Fault ITS-EI, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. david-bron...@uiowa.edu
Re: Rman not deleting old backups
I think you are looking for the tdposync utility: http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=%2Fcom.ibm.itsmfd.doc%2Fab5u000464.htm Also check the following: http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=%2Fcom.ibm.itsmfd.doc%2Fab5u000457.htm http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=%2Fcom.ibm.itsmfd.doc%2Fab5u000458.htm Regards, Shawn Shawn Drew Internet deehr...@louisville.edu Sent by: ADSM-L@VM.MARIST.EDU 07/22/2011 11:35 AM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject [ADSM-L] Rman not deleting old backups Awhile back someone shared on this list their commands/scripts for verifying that rman was not leaving any old backups on the TSM server. I can't seem to find it now. Ring a bell with anyone? David This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. Please note that certain functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc.
Re: Rman not deleting old backups
Simplest way I've found: select ll_name, filespace_name, date(backup_date) from backups where node_name='ORACLENODENAME' Then get your Oracle person to pull a list of the Oracle pieces from the RMAN catalog, you can match up the names and dates to the ll_names from this query. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David E Ehresman Sent: Friday, July 22, 2011 11:35 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Rman not deleting old backups Awhile back someone shared on this list their commands/scripts for verifying that rman was not leaving any old backups on the TSM server. I can't seem to find it now. Ring a bell with anyone? David
Re: Rman not deleting old backups
David E Ehresman wrote: Awhile back someone shared on this list their commands/scripts for verifying that rman was not leaving any old backups on the TSM server. I can't seem to find it now. Ring a bell with anyone? David, is this the thread you're remembering (both Eric van Loon I provided select statements that seem related to what you're looking for)? Nested SQL? http://www.mail-archive.com/adsm-l@vm.marist.edu/msg82918.html (My Oracle DBA just cleaned up about 45 TB of stale/orphaned/obsolete RMAN backups based on the report I send him monthly...) -- Hello World.David Bronder - Systems Admin Segmentation Fault ITS-EI, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. david-bron...@uiowa.edu