ADSM-L

[ADSM-L] AW: [ADSM-L] Rman not deleting old backups

2011-07-25 03:53:23
Subject: [ADSM-L] AW: [ADSM-L] Rman not deleting old backups
From: "Karl, Christian" <Christian.Karl AT HUK-COBURG DOT DE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 25 Jul 2011 09:46:40 +0200
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.karl AT huk-coburg DOT 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 AT VM.MARIST DOT EDU] Im Auftrag 
von molin gregory
Gesendet: Montag, 25. Juli 2011 09:20
An: ADSM-L AT VM.MARIST DOT 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.molin AT afnor DOT org
-----Message d'origine-----
De : ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] De la part de 
David E Ehresman
Envoyé : vendredi 22 juillet 2011 17:35
À : ADSM-L AT VM.MARIST DOT 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. "