Hi Justin, Try those ones :
select date(days(current_date)-1) as "DATA date",entity as nodename,((sum(bytes)/1024)/1024) as MB_backed_up from summary where activity='BACKUP' and days(current_date)-days(start_time)=1 group by entity order by MB_backed_up desc select (sum(bytes)/1024)/1024 as "Total in MB" from summary where activity='BACKUP' and days(current_date)-days(start_time)=1 Enjoy ! Arnaud Brion *********************************************************************** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] *********************************************************************** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Justin Case Sent: Tuesday, 16 March, 2004 17:25 To: [EMAIL PROTECTED] Subject: RMAN ? Need a way to get the amount of data backed up by RMAN nightly ? Does anyone have a select query that would be useful to run it once a day to get the amount of data backed up in a 24 hour period ? Thanks Justin Case Duke University Durham NC
