Re: RMAN Reporting?

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 <ORACLE-L_at_fatcity.com> 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" <ORACLE-L_at_fatcity.com>
> 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-
> > L_at_fatcity.com>
> >
> > >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-
> > L_at_fatcity.com>
> > >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: ORA1034_at_sbcglobal.net
> > >>
> > >> 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: ListGuru_at_fatcity.com (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: rgramolini_at_tax.state.vt.us
> > >
> > >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: ListGuru_at_fatcity.com (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: ORA1034_at_sbcglobal.net
> >
> > 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: ListGuru_at_fatcity.com (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: rgramolini_at_tax.state.vt.us
>
> 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: ListGuru_at_fatcity.com (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: adar76_at_inter.net.il

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: ListGuru_at_fatcity.com (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).