Management reporting and documentation
Post Reply
gdecagna
Novice
Posts: 5
Liked: never
Joined: Jun 12, 2015 1:32 pm
Full Name: Gabriele De Cagna
Contact:

Oracle RMAN Report

Post by gdecagna »

Hi,
I have just one question.
Is possible to create reports for backup done with Oracle RMAN Plug-In?

Thank you
Gabriele
Egor Yakovlev
Veeam Software
Posts: 2536
Liked: 680 times
Joined: Jun 14, 2013 9:30 am
Full Name: Egor Yakovlev
Location: Prague, Czech Republic
Contact:

Re: Oracle RMAN Report

Post by Egor Yakovlev » 2 people like this post

Hi Gabriele.

As of today, no. Not through Veeam One at least.
You can use native RMAN Reporting though, like "LIST BACKUP SUMMARY;" will toss you a great list of all backups made - Veeam Plugin emulates "SBT_Tape" and that will be your target VBR server.

Thanks!
gdecagna
Novice
Posts: 5
Liked: never
Joined: Jun 12, 2015 1:32 pm
Full Name: Gabriele De Cagna
Contact:

Re: Oracle RMAN Report

Post by gdecagna »

Ok, thank you very much!
Havgon
Novice
Posts: 8
Liked: 1 time
Joined: Jun 17, 2016 1:19 pm
Full Name: Javier Gonzalez
Contact:

Re: Oracle RMAN Report

Post by Havgon »

How about today, does VeeamOne support RMAN reporting yet? We just got several instances and management would like daily reports on success of backups. We are running v10 currently. Thank you.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Oracle RMAN Report

Post by Vitaliy S. » 1 person likes this post

Hi Javier,

No changes yet, but this feature is still planned for our next updates.

Thanks!
mamosorre84
Veeam Legend
Posts: 336
Liked: 34 times
Joined: Oct 24, 2016 3:56 pm
Full Name: Marco Sorrentino
Location: Ancona - Italy
Contact:

Re: Oracle RMAN Report

Post by mamosorre84 »

+1 for this feature request!
wishr
Veteran
Posts: 3077
Liked: 453 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: Oracle RMAN Report

Post by wishr »

Noted, thanks!
werner.vergauwen
Influencer
Posts: 13
Liked: 3 times
Joined: Jun 16, 2020 8:36 am
Full Name: Werner Vergauwen
Contact:

Re: Oracle RMAN Report

Post by werner.vergauwen »

+1 from my side as well
wishr
Veteran
Posts: 3077
Liked: 453 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: Oracle RMAN Report

Post by wishr »

Hi Werner,

Could you please tell us what particular information you are looking for and how an ideal report would look like?

Thanks
werner.vergauwen
Influencer
Posts: 13
Liked: 3 times
Joined: Jun 16, 2020 8:36 am
Full Name: Werner Vergauwen
Contact:

Re: Oracle RMAN Report

Post by werner.vergauwen » 1 person likes this post

Hi Fedor

any information is already an improvement, as currently there is no information whatsoever. What is shown on the VBR console is already more than can be accessed via any other means.

What I would like to see
* Per Database (so, _not_ per VM, as it can host multiple DBs)
** Database Name
** host name
** data, data+archivelog or archivelog backup
** backup level & estimated retention (bc controlled by RMAN)
** capacity backed up
** RMAN return code (+ optionally RMAN log)

The RC is important bc we encountered already a couple of times that the plugin process froze and RMAN did not finish entirely. As a result subsequent backups could not be launched, resulting in several DBs not being backed up anymore.

The host name is useful, since it is possible for DBs to be "migrated" to another VM for load balancing reasons. That is another reason why it doesn't make sense to run a report per VM.

A DB can be backed up by different "scope" (only data, only logs, ...) so it would make sense to being able to aggregate per DB.
Moreover, we have a very busy DB generating like 2TB of redo logs per day. These logs are being backed up evey 15 minutes. So aggregating per day could also be useful.

Note that I am not an actual DBA, so any other Oracle DBAs out there are welcome to chime in.

Looking forward to see what you guys will make of this :)
wishr
Veteran
Posts: 3077
Liked: 453 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: Oracle RMAN Report

Post by wishr »

Hi Werner,

That's great! Thanks for sharing.
AhmedS
Influencer
Posts: 10
Liked: 3 times
Joined: Jun 28, 2019 2:43 am
Full Name: Ahmed Sayed
Contact:

Re: Oracle RMAN Report

Post by AhmedS » 1 person likes this post

+1 - also include backup copy job reports for the RMAN plugin
StanoSedliak
Service Provider
Posts: 94
Liked: 8 times
Joined: Mar 20, 2018 6:31 am
Full Name: Stano Sedliak
Contact:

[MERGED] SAP Hana plugin report

Post by StanoSedliak »

Hi,

do you have some information please if is possible to create some report for backups jobs done with SAP Hana plugin/backint?
I found only an older topic for Oracle plugin that its not possible:
reporting-f6/oracle-rman-report-t62658.html

Or is there any other way to setup the report with Veeam?

Thank you!
wishr
Veteran
Posts: 3077
Liked: 453 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: SAP Hana plugin report

Post by wishr »

Hi Stano,

Currently, with V11a, this is not possible, but we are planning to change that in the future versions.

I'll merge your question with the topic you linked.

Thanks
D.JA
Lurker
Posts: 1
Liked: never
Joined: Jan 25, 2024 9:38 am
Full Name: Davy Jacobs
Contact:

Re: Oracle RMAN Report

Post by D.JA »

Hi Vitaliy

Is there already an update yet?
When will VeeamOne support RMAN reporting?
This would help us immensely.

Thank you!
Mildur
Product Manager
Posts: 8549
Liked: 2223 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Oracle RMAN Report

Post by Mildur »

Hi Davy

Welcome to the forum.
V12 / V12.1 has the following two reports for by the backup server managed enterprise plugins and backup policies:
https://helpcenter.veeam.com/docs/one/r ... ml?ver=120

Best,
Fabian
Product Management Analyst @ Veeam Software
jorgedlcruz
Veeam Software
Posts: 1355
Liked: 613 times
Joined: Jul 17, 2015 6:54 pm
Full Name: Jorge de la Cruz
Contact:

Re: Oracle RMAN Report

Post by jorgedlcruz »

Hello,
Besides those two specific reports for managed plugins, we have as well:
  • Workload Protection History supports these types: https://helpcenter.veeam.com/docs/one/r ... le&ver=120
  • Dedicated Alarms: Database log backup job state, Job disabled, Job exceeded backup window, Restore activity, Suspicious incremental backup size, and Unusual job duration
    Dedicated Business view:
    Image
  • Dedicated view under Data Protection:
    Image
Let us know what you think after giving it a try. Thanks a lot for coming back and ask :)

PS: Unmanaged plugins visibility is planned, but we can not share any date, we are currently doing our research.
Jorge de la Cruz
Senior Product Manager | Veeam ONE @ Veeam Software

@jorgedlcruz
https://www.jorgedelacruz.es / https://jorgedelacruz.uk
vExpert 2014-2024 / InfluxAce / Grafana Champion
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests