I want to get reflect RMAN job details to the Dashboard

Grafana Dashboards
1

image

I am having trouble with creating the dashboard for Rman jobs. Does anyone have experience in that particular area?

2

are you using the oracle plugin?

1 Like
3

No @sowdenraymond should i have that for this?

4

That info is stored in a database, Grafana needs some way to access that data, so you either need the plugin to connect to the database, or you can write a stored proc or script that will connect to the database and extract that data, and save it in a csv file that Grafana can then access…

5

Actually, in my case, Prometheus is the service that accesses the Database. So we are running Grafana on top of Prometheus.

6

if you are already using prometheus as the exporter, then you can add custom sql’s, please see below for some examples:

7

in my case below works without any issues

image
image895×98 15.2 KB

image
image796×55 2.32 KB

But below doesn’t work

image
image917×217 51.3 KB

8

This one won’t work, because the name you are selecting as, and the description don’t match:

image
image768×102 53.8 KB

9

ah yes, Thank you for noticing. what about the other one?

10

the description does not seem to match the query, do you have a duplicate metric with that name?