All Apps and Add-ons

How to create a dashboard for oracle rman increment backup?

lousplunk
Engager

I am trying to create a dashboard which shows the oracle increment dashboard. I can see that splunk have a
sourcetype=oracle:rman
I am trying to create a dashboard which shows in a week from Monday-Sunday (daily basis) and how much it backs up.

0 Karma
1 Solution

nishad_tupe
Explorer

Hi,
I don't think Splunk Oracle Add-On TA App provides the source type oracle:rman.
http://docs.splunk.com/Documentation/AddOns/released/Oracle/Datatypes
There is something called as SYS.UNIFIED_AUDIT_TRAIL with 12c , where Splunk mentions that using oracle:audit:unified may capture Oracle RMAN information.
http://docs.splunk.com/Documentation/AddOns/released/Oracle/Releasenotes

I would suggest creating a custom app and source type to monitor your backup logs. You can write a custom script to extract the necessary information from logs. Use DBX Input to monitor oracleRMAN views (v$backup_files etc) only if you are unable to extract information. I am working on POC to build the dashboard for RMAN backups.

You output log / csv should have roughly these headers.
Instance Host Version Type Level Backup_start_Date Status Message Size_MB Duration_Min

Optionally you can also monitor the archive log gap sequence through logs.

If you happen to know the standard source type provided by Splunk along with configuration inputs please post here.

Regards,
Nishad

View solution in original post

0 Karma

nishad_tupe
Explorer

Hi,
I don't think Splunk Oracle Add-On TA App provides the source type oracle:rman.
http://docs.splunk.com/Documentation/AddOns/released/Oracle/Datatypes
There is something called as SYS.UNIFIED_AUDIT_TRAIL with 12c , where Splunk mentions that using oracle:audit:unified may capture Oracle RMAN information.
http://docs.splunk.com/Documentation/AddOns/released/Oracle/Releasenotes

I would suggest creating a custom app and source type to monitor your backup logs. You can write a custom script to extract the necessary information from logs. Use DBX Input to monitor oracleRMAN views (v$backup_files etc) only if you are unable to extract information. I am working on POC to build the dashboard for RMAN backups.

You output log / csv should have roughly these headers.
Instance Host Version Type Level Backup_start_Date Status Message Size_MB Duration_Min

Optionally you can also monitor the archive log gap sequence through logs.

If you happen to know the standard source type provided by Splunk along with configuration inputs please post here.

Regards,
Nishad

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...