RE: RMAN Reporting?

From: Walter K <ORA1034_at_sbcglobal.net>
Date: Wed, 11 Dec 2002 11:39:49 -0800
Message-ID: <F001.00517EA1.20021211113949@fatcity.com>

Sure. If I have three databases (AAA, BBB and CCC), I would like to see a report that says database AAA was backed up on 10-DEC-2002 starting at 21:00 and ended at 23:07.

I can produce such a report if AAA was ONLY backed up once for a given day but not if it was backed up multiple times in a day.

This seems like a pretty basic report a lot of people would want but it doesn't look like the schema was designed with much in the way of reporting/trending in mind.

Thanks.
-w

• Original Message --- To: Multiple recipients of list ORACLE-L <ORACLEL @fatcity.com>

>Walter - Can you explain your goal in a little more
detail? RMAN has some
>standard reports for listing the date of backups.
What do you mean by
>duration? The time interval that RMAN was backing up
your data? I doubt that
>RMAN stores that, probably just the completion time.
>Dennis Williams
>DBA, 40%OCP
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>
>-----Original Message-----
>Sent: Wednesday, December 11, 2002 12:11 PM
>To: Multiple recipients of list ORACLE-L
>
>
>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: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
>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:39:49 CST