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 <ORACLE- [EMAIL PROTECTED]> >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. >[EMAIL PROTECTED] > > >-----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: [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: DENNIS WILLIAMS > 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 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).
