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 weforget the pencil and paper?Ruth- Original Mess
Shame on you Ruth. Paper ???
select sum(my data) from Rman_tables;
Really, Paper That archaic method of cutting trees and using them :-(
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, December 16, 2002 10:14 P
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
/12/2002 -0800, you wrote:
From: "Walter K" <[EMAIL PROTECTED]>
Date: Wed, 11 Dec 2002 15:01:02 -0500
Subject: RE: RMAN Reporting?
I agree. I can get what I want by looking at time
stamps on log files, grepping, etc. but that can be a
lot of work to put together. I have a need to do
I agree. I can get what I want by looking at time
stamps on log files, grepping, etc. but that can be a
lot of work to put together. I have a need to do some
trending analysis and was expecting that I could get
this info out of the RMAN tables but it's looking like
that's just wishful thinking
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 o
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
Perhaps looking at the last update time on the log files?
And I assume you know what time the backup started ... ?
> 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?
--
Please see the official ORACLE-L FAQ: http
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%O
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" <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 1:11 PM
> Is there no way to produce a report from the RMAN
> views/tables tha
10 matches
Mail list logo