Kurt,

When deleting Rman objects on the TSM Server, TDP Oracle uses the delete
function on objects....the objects do not move to inactive they are just
simply deleted from the TSM Server. So if you are certain that Rman is
deleting the objects from the controlfile, then my guess is that your TSM
Node is not configured with "backdel=yes". One simple way to know what is
going on during the deletion is to look in the tdpoerror.log this should
tell you if the objects are being deleted or if there is an error
occurring during the delete. Unfortunately, Oracle ignores errors that
come from the delete functions so any error that TDP Oracle gives during
deletion is lost, the only way to know for sure is the "tdpoerror.log"


Regards,

Neil Rasmussen
Software Development
Data Protection for Oracle
rasmussn AT us.ibm DOT com




Kurt Beyers <Kurt.Beyers AT DOLMEN DOT BE>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
10/13/2005 06:19 AM
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
expiration Oracle backups






Hello,

My environment is the following:

TSM 5.3.2 server on Windows2003
Sun Solaris 5.8 with Oracle 8.1.7.4 with a TSM BA client 5.3.x and the TDP
for databases 5.3

The backup of the Oracle databases is already working. The metadata of the
backups is written in the control files of the Oracle database.

The backups are bound to a mgmt class with the correct settings (as every
object receives a unique name in TSM).

The expiration must first be done in Oracle with a script, eg expire the
backups older than X days. Could anybody share a working script? I'm still
struggling to get it working as it should.

But how are the backups made inactive in the TSM database after they have
been deleted in Oracle? The 'tdposync' tool only works when the metadata
is stored in a recovery catalog database. And after a forced deletion of
the backups in RMAN, they do not become inactive in TSM either. How can
the metadata in the TSM database be synchronized with the metadata in
Oracle (control file) .

I know this must have been discussed in the past already, but a search of
the old threads didn't  clear it out yet.

thanks a lot,
Kurt