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:[EMAIL PROTECTED]] Sent: Friday 24 January 2003 16:18 To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED]