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: arnaud.brion AT panalpina DOT com
***********************************************************************




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Justin Case
Sent: Tuesday, 16 March, 2004 17:25
To: ADSM-L AT VM.MARIST DOT EDU
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