Well, we don't do any reports off TSM, so not sure of any that are available.
But why couldn't you just report off of the RMAN catalog.
Here's a script to look at the backup sets.
Here's a script to see backup sizes of datafiles:Code:BREAK ON DATABASE skip 1 col elapsed for 99,999.9 set lines 120 SELECT name "DataBase", bs_key, set_count, status, DECODE(backup_type,'D','DATABASE','L','ARCHIVE LOG', I','INCREMENTAL') TYPE, incremental_level "Level", TO_CHAR(start_time, 'MM/DD/YY-HH24:MI') "Start Time", TO_CHAR(a.completion_time, 'MM/DD/YY-HH24:MI') "End Time", elapsed_seconds/60 "Elapsed" FROM rc_backup_set a, rc_database b WHERE start_time > sysdate - 14 AND name LIKE UPPER('&DataBase%') AND a.db_key = b.db_key AND elapsed_seconds BETWEEN 0 AND 86399 ORDER BY 1, 7
* You can use RC_Archived_log to get similar information on Archive Log backups.Code:col mbytes for 9,999,999.99 SELECT db_name, bs_key, sum((blocks*block_size)/(1024*1024)) MBytes FROM rc_backup_datafile WHERE db_name like upper('&database%') GROUP BY db_name, bs_key /
These should get you in the right direction to get the information you need.
Good luck!
Jodie




Reply With Quote