Re: RMAN Reporting?

[Walter K]

Ha ha. You tell me how to group the records together so they can be added, electronically or manually, and I will be glad to do so...

 Ruth Gramolini <[EMAIL PROTECTED]> wrote:

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 > [EMAIL PROTECTED]>
>
> >Did you try running a query against rman.bp. It has
> a column called
> >completion_time.
> >
> >Ruth
> >----- Original Message -----
> >To: "Mul! tiple recipients of list ORACLE-L" > [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 Dieg! o, 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 th! is 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 HEL! P command for other information (like subscribing).