Well I'm not sure about the latest TDP versions but in the older 2.1 or so
the options are a
little limited.
RMAN thinks in terms of redundant backups. The delete scripts that are
delivered with RMAN give a small insight on how to delete the old backups.
But it's based on deleting any files that are part of a backupset that is
above a redundancy level.
Not really the daily weekly monthly stuff.
I might have some scripts hanging around that you can have but they only
really deal with one month of backups and then over and out.
>From memory do not try do achieve this using TSM management classes as RMAN
expects to be in complete control of backup files/pieces.

Regards

-----Original Message-----
From: TSM [mailto:tsm AT PROFI-AG DOT DE]
Sent: Friday 24 January 2003 16:18
To: ADSM-L AT VM.MARIST DOT EDU
Subject: TSM/RMAN scripts for backing up Oracle DBs and deleting backups


Hello  list,

We are organizing an Oracle 9i backup using RMAN and TDP 2.2.1. on W2K.
TSM server 5.1.5 is running on AIX.
We want to make
     daily backups (30 versionen),
     weekly backups (4 Versions)
     monthly backups (12 versions).
using different management classes.
I am rather familiar with TSM but not with Oracle/RMAN.

   Are there scripts available for performing these (or similar) backups
   automatically?
and - what would be still more appreciated:
   Are there scripts available for deleting overaged backups?  (deleting
   backups from mgmt class X and older than y days)?

Thank you for your preposals and answers
and for your readyness to let me participate in your experience

Gernot

g.espelage AT profi-ag DOT de