We backup our Oracle databases using RMAN and Tivoli Storage Manager
(TDP for Oracle). I know how to query TSM server to find out all the
backup objects with the following TSM administrative command:

select state,ll_name,backup_date from backups where node_name='NODENAME'

However, does anyone know specifically how I can query the RMAN catalog
for the backup objects that are there for a specific node. I would like
to compare the backup objects that are in TSM server and the ones that
are in RMAN.

Any help will be greatlt appreciated. Thank you all.




Oracle LazyDBA home page