Is there a way in TSM that we can identify which tape the backup files of a particular database are going to. This is required because very few tapes are ejected out of TSM library everyday.
I would like to know the SQL query that should be run on the TSM library to identify correlation between backup files and tapes.
The reason why the number of tapes ejected daily may appear low in comparison to the amount of data backed up could be explained by the LTO2 drives compression capabilities. We have frequently observed LTO2 tapes storing up to 800 GB of database data with compression enabled (databases typically compress very well).
However, if there still is a requirement to keep track of which tapes contain database data, it might be advisable to create a separate tape pool for the RMAN backups. It would then be a little easier on the resources when running the SQL command mentioned above against tape volumes that store a low number of large files.
This was first published in April 2005