Try:
Select A.node_name, A.filespace_name, A.ll_name as File_Name, A.backup_date,
A.state, A.class_name, A.object_id \
from backups A, nodes B \
where A.node_name = '<Oracle node>' and A.filespace_name like '<database
filespace>' and A.node_name = B.node_name and B.platform_name like 'TDP
Oracle%' \
order by A.backup_date
Grigori G. Solonovitch
Senior Technical Architect
Information Technology Bank of Kuwait and Middle East http://www.bkme.com
Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: G.Solonovitch AT bkme
DOT com
Please consider the environment before printing this Email
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Mario Behring
Sent: Monday, December 21, 2009 3:25 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Visualizing RMAN backups through TDP for Oracle
Hi list,
How do I check if a RMAN backup operation was successful and the data copied at
the TSM Server or TDP for Oracle agent?
The TDP is running ok and the backup session occurred without errors.
Thanks
Mario
Please consider the environment before printing this Email.
"This email message and any attachments transmitted with it may contain
confidential and proprietary information, intended only for the named
recipient(s). If you have received this message in error, or if you are not the
named recipient(s), please delete this email after notifying the sender
immediately. BKME cannot guarantee the integrity of this communication and
accepts no liability for any damage caused by this email or its attachments due
to viruses, any other defects, interception or unauthorized modification. The
information, views, opinions and comments of this message are those of the
individual and not necessarily endorsed by BKME."
|