Re: [ADSM-L] TDPO problem - can't delete old tdpo backups

Depending on the How long you need to keep the history of the old
backups, if not visible in the RMAN cat is to rename the tdpo FS on the
Backup Server - then the next RMAN backup will create new one based on
the name in the tdpo.opt ... You then wait x days for your retention
then go back to the TSM server and delete the TDP filespace you renamed
... Little less dangerous than the del obj, not to mention by doing the
Del obj - you are only deleting one copy (assuming you make an offsite) 

Charles  

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Mochnaczewski
Sent: Tuesday, February 10, 2009 2:22 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] TDPO problem - can't delete old tdpo backups

At this point, delete object is most likely your only option. We have
had to deal with orphaned backups in the past. It is not that difficult
to delete them. I have a step by step procedure to do this. Has not
failed me yet.

Rich

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Richard Rhodes
Sent: Tuesday, February 10, 2009 3:18 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TDPO problem - can't delete old tdpo backups


We've been using rman/tdpo backups for over a year now, and are still
trying to get our heads fully around it.  I've been working with TSM
support on a problem and not getting very far, so I thought I'd ask the
list.

We have several TDPO nodes in a TSM server  that have old backups we
cannot get rid of.  In all other ways TDP/TSM is working great.  When we
run TDPOSYNC it says the RMAN catalog and TDPO is INSYNC - nothing to
cleanup.  But, a list of objects form the backups table in TSM for the
node shows old backups.  we keep backups for 50 days - these old files
are well back into last year.

What we think happened:

Back in Oct/Nov/Dec time frame, we did RESTORES on several databases.
According to the DBA's, part of these restore was Oracle creating a new
DBID (Database ID).
In essence, after the restore we had a completely NEW DATABASE.
>From RMAN's perspective, these were NEW DATABASES.
The old objects in TSM that we can't get rid of appear to be from PRIOR
TO THE RESTORE.  It's as if both RMAN and TDPO have no knowledge of
these objects. The DBA who handles rman/tdpo (who is very good!) says
that these old objects are NOT in RMAN.  RMAN/TDPO/TSM is CORRECTLY
backing up and deleting backups SINCE the restore.  Also, we setup
rman/tdpo so that every Oracle db has it's own TSM node.

IBM suggested

1)  delete them with the BA client. It doesn't work.  It seems the files
in TSM have no owner, and the ba client won't/can't see them.

2)  rename the node and start over.  Yes, I can do this, but it seems to
be running around the problem.

or 3)  User error (the dba and myself) - we don't understand something
about RMAN/TDPO/TSM.

It seems to me that I have either a RMAN bug, or a TDPOSYNC bug.
 what I wish is that tdposync would list out the full set of files that
it is comparing from rman and tsm.

Yes, I'm aware of the "delete object" command . . . I really don't want
to go there!

=================

Here is an example of a the files in one of the problem nodes:


==> tsmsap2  TDPO-ONSITE  SAPEQ1D1_DB
==> q node:  SAPEQ1D1_DB        AIX     TDPO-ONSITE     1       1
No

<these lines are the old backups that tdposync/rman doesn't see>

i0jo7odu_1_1    ACTIVE_VERSION  2008-08-17
i8jo7tuc_1_1    ACTIVE_VERSION  2008-08-17
<deleted lines>
u7jrej66_1_1    ACTIVE_VERSION  2008-09-25
u8jrejb3_1_1    ACTIVE_VERSION  2008-09-25
<deleted lines>
ucjrejk0_1_1    ACTIVE_VERSION  2008-09-25
udjrejlo_1_1    ACTIVE_VERSION  2008-09-25

<GAP - no files - the lines below are GOOD backups that are
created/deleted
correctly>

4mk2gkvp_1_1    ACTIVE_VERSION  2008-12-17
4tk2gv5l_1_1    ACTIVE_VERSION  2008-12-17
<deleted lines>
o0k3bpge_1_1    ACTIVE_VERSION  2008-12-28
o5k3bvvt_1_1    ACTIVE_VERSION  2008-12-28
<delted lines>
6pk410jh_1_1    ACTIVE_VERSION  2009-01-05
6uk4173b_1_1    ACTIVE_VERSION  2009-01-05
<deleted lines>
btk4iavp_1_1    ACTIVE_VERSION  2009-01-11
buk4ib01_1_1    ACTIVE_VERSION  2009-01-11









Thanks

Rick



-----------------------------------------
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If the
reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby
notified that you have received this document in error and that any
review, dissemination, distribution, or copying of this message is
strictly prohibited. If you have received this communication in error,
please notify us immediately, and delete the original message.

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.