Shame on you Ruth. Paper ??????? select sum(my data) from Rman_tables;
Really, Paper???? That archaic method of cutting trees and using them :-( Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, December 16, 2002 10:14 PM > Add them together! Or are we so in need of a technical solution that we > forget the pencil and paper? > > Ruth > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, December 11, 2002 2:30 PM > > > > Yes. The completion_time is available for the backup > > piece (BP) and the backup set (BS) but not for the > > entire backup. That would be fine if there was a way > > of relating the "pieces" or "sets" to a single backup > > but I see no way of doing this. > > > > > > --- Original Message --- > > To: Multiple recipients of list ORACLE-L <ORACLE- > > [EMAIL PROTECTED]> > > > > >Did you try running a query against rman.bp. It has > > a column called > > >completion_time. > > > > > >Ruth > > >----- Original Message ----- > > >To: "Multiple recipients of list ORACLE-L" <ORACLE- > > [EMAIL PROTECTED]> > > >Sent: Wednesday, December 11, 2002 1:11 PM > > > > > > > > >> Is there no way to produce a report from the RMAN > > >> views/tables that lists the date and duration of the > > >> backups for each database? I have pored through the > > RC > > >> views and can produce such a report at the backup > > set > > >> level but not at the database level. > > >> > > >> Am I missing something? Any suggestions? > > >> > > >> Thanks. > > >> -w > > >> > > >> -- > > >> Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > >> -- > > >> Author: Walter K > > >> INET: [EMAIL PROTECTED] > > >> > > >> Fat City Network Services -- 858-538-5051 > > http://www.fatcity.com > > >> San Diego, California -- Mailing list and > > web hosting services > > >> ---------------------------------------------------- > > ----------------- > > >> To REMOVE yourself from this mailing list, send an > > E-Mail message > > >> to: [EMAIL PROTECTED] (note EXACT spelling > > of 'ListGuru') and in > > >> the message BODY, include a line containing: UNSUB > > ORACLE-L > > >> (or the name of mailing list you want to be removed > > from). You may > > >> also send the HELP command for other information > > (like subscribing). > > >> > > > > > >-- > > >Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > >-- > > >Author: Ruth Gramolini > > > INET: [EMAIL PROTECTED] > > > > > >Fat City Network Services -- 858-538-5051 > > http://www.fatcity.com > > >San Diego, California -- Mailing list and web > > hosting services > > >------------------------------------------------------ > > --------------- > > >To REMOVE yourself from this mailing list, send an E- > > Mail message > > >to: [EMAIL PROTECTED] (note EXACT spelling > > of 'ListGuru') and in > > >the message BODY, include a line containing: UNSUB > > ORACLE-L > > >(or the name of mailing list you want to be removed > > from). You may > > >also send the HELP command for other information > > (like subscribing). > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Walter K > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ruth Gramolini > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
