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 <ORACLEL
@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).
Received on Wed Dec 11 2002 - 13:30:09 CST
