Re: RMAN Reporting?

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).