ADSM-L

Re: expiration Oracle backups

2005-10-13 11:59:49
Subject: Re: expiration Oracle backups
From: "Allen S. Rout" <asr AT UFL DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 13 Oct 2005 11:59:30 -0400
==> On Thu, 13 Oct 2005 07:38:18 -0700, Neil Rasmussen <rasmussn AT US.IBM DOT 
COM> said:


> 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.

Hmm, I thought they did move to inactive; They have their 'inactivate date'
set to the 1900, so unless you are retaining NOLIMIT, they'll dissapear next
expiration.  [ rustle through Oracle problem-trace logs ]  Here's an example.

These are from

 'select * from backups where node_name='WEBCT-DB' order by 
filespace_name,backup_date'



Before: [ query taken at 09:58 ]
WEBCT-DB        /webct-db       1       ACTIVE_VERSION  FILE    //      
df_WEBCT_4416_1_568435025       124553476       2005-09-08 02:42:02.000000      
        oracle  DEFAULT

After: [ query taken at 10:01 ]
WEBCT-DB        /webct-db       1       INACTIVE_VERSION        FILE    //      
df_WEBCT_4416_1_568435025       124553476       2005-09-08 02:42:02.000000      
1900-01-01 00:00:00.000000     oracle  DEFAULT


Is there something I'm missing about this?  Or is that just what happens in
the DB when the API issues a 'Delete this file' request?


> 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".

Second the motion.  We ran into this.


- Allen S. Rout

<Prev in Thread] Current Thread [Next in Thread>