Yes, that's what I was looking for. Thanks, David Ehresman
>>> David Bronder <david-bron...@uiowa.edu> 7/22/2011 8:18 PM >>> David E Ehresman wrote: > > Awhile back someone shared on this list their commands/scripts for > verifying that rman was not leaving any old backups on the TSM server. > I can't seem to find it now. Ring a bell with anyone? David, is this the thread you're remembering (both Eric van Loon & I provided select statements that seem related to what you're looking for)? Nested SQL? http://www.mail-archive.com/adsm-l@vm.marist.edu/msg82918.html (My Oracle DBA just cleaned up about 45 TB of stale/orphaned/obsolete RMAN backups based on the report I send him monthly...) -- Hello World. David Bronder - Systems Admin Segmentation Fault ITS-EI, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. david-bron...@uiowa.edu