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

2011-07-25 04:36:33
Subject: Re: [ADSM-L] AW: [ADSM-L] Rman not deleting old backups
From: Saravanan Palanisamy <evergreen.sarav AT GMAIL DOT COM>
Date: Mon, 25 Jul 2011 11:27:28 +0300
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.

from backups where BACKUP_DATE BETWEEN '2010-04-01 00:00:00.000000' and
'2010-04-07 23:59:59.000000' and node_name in('nodename')

On Mon, Jul 25, 2011 at 10:46 AM, Karl, Christian <
Christian.Karl AT huk-coburg DOT 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
> Bahnhofsplatz
> 96444 Coburg
> Telefon:  09561 96-44117
> Telefax:  09561 96-44104
> E-Mail:   christian.karl AT huk-coburg DOT de
> Internet:
> =======================================================================
> 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
> 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
> 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
> 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,
Mobile: +974-3344-1538
Email: evergreen.sarav AT gmail DOT com, <evergreen.sarav AT gmail DOT com>
evergreen.sarav AT DOT in

There are no secrets to success. It is the result of preparation, hard work
and learning from failure - Colin Powell