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.
AW: [ADSM-L] Rman not deleting old backups
Hi, ...bell rings, yes. The certain case is, when the databaseID has changed in the RMAN. When and why that happens you should ask your local DBA. All files that have been created with the old DB-ID are not referenced any more from RMAN and therefore are not deleted by RMAN. By the way, it seems that you have to clean it up now. In that case TDPOSYNC etc. does not work as it does not list the old backups :) Best way is to define a new TSM-node for the affected DB's and let the old filespace (active data) expire. Deleting items inside TSM with the (not supported) delete command is not a good way to clean up the mess. Regards Chris Karl Christian Karl Abteilung Informatik Betrieb HUK-COBURG Bahnhofsplatz 96444 Coburg Telefon: 09561 96-44117 Telefax: 09561 96-44104 E-Mail: christian.k...@huk-coburg.de Internet: www.huk.de === HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021 Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg Vorsitzender des Aufsichtsrats: Werner Strohmayr. Vorstand: Dr. Wolfgang Weiler (Sprecher), Wolfgang Flaßhoff, Stefan Gronbach, Klaus-Jürgen Heitmann, Dr. Hans Olav Herøy, Jörn Sandig. === Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet. This information may contain confidential and/or privileged information. If you are not the intended recipient (or have received this information in error) please notify the sender immediately and destroy this information. Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden. === -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von molin gregory Gesendet: Montag, 25. Juli 2011 09:20 An: ADSM-L@VM.MARIST.EDU Betreff: Re: [ADSM-L] 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.
AW: [ADSM-L] Rman not deleting old backups
Hi, just for Info... The DB-ID does NOT change, if you do an unregister/register DB in the RMAN. In that case RMAN remembers the ID and you are save. The DB-ID changes, if you do a delete/register in the RMAN and then you have the mess. Regards Chris Karl Christian Karl Abteilung Informatik Betrieb HUK-COBURG Bahnhofsplatz 96444 Coburg Telefon: 09561 96-44117 Telefax: 09561 96-44104 E-Mail: christian.k...@huk-coburg.de Internet: www.huk.de === HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021 Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg Vorsitzender des Aufsichtsrats: Werner Strohmayr. Vorstand: Dr. Wolfgang Weiler (Sprecher), Wolfgang Flaßhoff, Stefan Gronbach, Klaus-Jürgen Heitmann, Dr. Hans Olav Herøy, Jörn Sandig. === Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet. This information may contain confidential and/or privileged information. If you are not the intended recipient (or have received this information in error) please notify the sender immediately and destroy this information. Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden. === -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von molin gregory Gesendet: Montag, 25. Juli 2011 09:20 An: ADSM-L@VM.MARIST.EDU Betreff: Re: [ADSM-L] 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: AW: [ADSM-L] Rman not deleting old backups
You can run crosscheck command in RMAN prompt and see whether all the old objects are able to identified or not. If not reported in report obsolete after running crosscheck then create the new node and retain the old node until it meets retention and remove the old node from TSM server. Also check what kind of files(i.e backup pieces, archive logs control files) are not expired and are they appearing in report obsolete output. select Node_name,FILESPACE_NAME,BACKUP_DATE,DEACTIVATE_DATE,CLASS_NAME,STATE,TYPE,HL_NAME,LL_NAME from backups where BACKUP_DATE BETWEEN '2010-04-01 00:00:00.00' and '2010-04-07 23:59:59.00' and node_name in('nodename') On Mon, Jul 25, 2011 at 10:46 AM, Karl, Christian christian.k...@huk-coburg.de wrote: Hi, ...bell rings, yes. The certain case is, when the databaseID has changed in the RMAN. When and why that happens you should ask your local DBA. All files that have been created with the old DB-ID are not referenced any more from RMAN and therefore are not deleted by RMAN. By the way, it seems that you have to clean it up now. In that case TDPOSYNC etc. does not work as it does not list the old backups :) Best way is to define a new TSM-node for the affected DB's and let the old filespace (active data) expire. Deleting items inside TSM with the (not supported) delete command is not a good way to clean up the mess. Regards Chris Karl Christian Karl Abteilung Informatik Betrieb HUK-COBURG Bahnhofsplatz 96444 Coburg Telefon: 09561 96-44117 Telefax: 09561 96-44104 E-Mail: christian.k...@huk-coburg.de Internet: www.huk.de === HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021 Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg Vorsitzender des Aufsichtsrats: Werner Strohmayr. Vorstand: Dr. Wolfgang Weiler (Sprecher), Wolfgang Flaßhoff, Stefan Gronbach, Klaus-Jürgen Heitmann, Dr. Hans Olav Herøy, Jörn Sandig. === Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet. This information may contain confidential and/or privileged information. If you are not the intended recipient (or have received this information in error) please notify the sender immediately and destroy this information. Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden. === -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von molin gregory Gesendet: Montag, 25. Juli 2011 09:20 An: ADSM-L@VM.MARIST.EDU Betreff: Re: [ADSM-L] 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. -- Thanks Regards, Sarav Mobile: +974-3344-1538 Email: evergreen.sa...@gmail.com, evergreen.sa...@gmail.com evergreen.sa...@yahoo.co.in http://qa.linkedin.com/pub/saravanan-palanisamy/36/584/482 There are no secrets to success. It is the result of preparation, hard work and learning from failure - Colin Powell
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
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
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