If you have the activity log, a cheap&dirty method would be to select from
volumeusage, then reconcile with the tapes that were used during that period
(ie, search=' mounted' on the act-log query)... alternatively, do a query
vol & query content for each tape returned from the volumeusage table. (You
could use the show cmd for volumeusage & other info, but that's another
story; search the archives for the full list of show cmd arguments.)
Consider the following SELECT query, to queue up the right tapes:
select distinct node_name,volume_name,stgpool_name from volumeusage \
where node_name='ClientXYZ' and stgpool_name='3570POOL'
-----Original Message-----
From: Jolley, Bill
Sent: Thursday, May 03, 2001 6:45 AM
To: [EMAIL PROTECTED]
Subject: Identify tape volumes
I am looking for a select statement to identify tape volumes used during an
oracle db backup
for a specific date (04/20/01). Can anyone help me?
Thanks
William M. Jolley
EDS
9014 Research Drive
Charlotte, NC 28226
Tel:704-548-5524
pag:877-471-5029
email:[EMAIL PROTECTED]
