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 PM
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
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
: 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 some
trending analysis and was expecting that I
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?
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,
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:
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
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
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
10 matches
Mail list logo