New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


How can I monitor RMAN backup status on an Oracle Database?

Votes:

0

Your Vote:

Up

Down

I want to monitor the current and last RMAN backup status on an Oracle Database. How can I do it?

backup backup-monitoring oracle prtg

Created on Nov 4, 2016 2:06:49 PM by  abostico (120) 1 2



2 Replies

Accepted Answer

Votes:

7

Your Vote:

Up

Down

I resolve this using Oracle SQL v2 sensor and Custom Lookups according to this manual on Paessler KB:

  • I create the file Custom Sensors\sql\oracle\rmanmonitor.sql on the PRTG installation directory with this content: SELECT CASE WHEN status = 'RUNNING' THEN 1 WHEN status = 'COMPLETED' THEN 2 WHEN status = 'RUNNING WITH WARNINGS' THEN 3 WHEN status = 'COMPLETED WITH WARNINGS' THEN 4 WHEN status = 'RUNNING WITH ERRORS' THEN 5 WHEN status = 'COMPLETED WITH ERRORS' THEN 6 WHEN status = 'FAILED' THEN 7 ELSE 0 END as status, status as description FROM v$rman_backup_job_details WHERE start_time = (SELECT MAX(start_time) FROM v$rman_backup_job_details);
  • I then create the file lookups\custom\oid.paessler.oracle.rmanstatus.ovl file on the PRTG installation directory with all the possible RMAN statuses and the status conditions on PRTG:
<?xml version="1.0" encoding="UTF-8"?>
  <ValueLookup id="oid.paessler.oracle.rmanstatus" desiredValue="0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="PaeValueLookup.xsd">
		<Lookups>
		  <SingleInt state="Warning" value="0">
				Unknown
		  </SingleInt>
		  <SingleInt state="OK" value="1">
				RUNNING
		  </SingleInt>
		  <SingleInt state="Ok" value="2">
				COMPLETED
		  </SingleInt>
		  <SingleInt state="Warning" value="3">
				RUNNING WITH WARNINGS
		  </SingleInt>
		  <SingleInt state="Warning" value="4">
				COMPLETED WITH WARNINGS
		  </SingleInt>
		  <SingleInt state="Error" value="5">
				RUNNING WITH ERRORS
		  </SingleInt>
		  <SingleInt state="Error" value="6">
				COMPLETED WITH ERRORS
		  </SingleInt>
		  <SingleInt state="Error" value="7">
				FAILED
		  </SingleInt>
		</Lookups>
  </ValueLookup>
  • Then create an Oracle SQL v2 sensor pointing to the .sql file and the .ovl files created previously, as described in the manual.

Note: Remember to reload the defined lookups in the custom folder by clicking the Load Lookups button in the PRTG web interface under Setup | System Administration | Administrative Tools after creating the .ovl file.

Created on Nov 4, 2016 4:09:21 PM by  abostico (120) 1 2



Votes:

0

Your Vote:

Up

Down

Awesome, thanks for sharing! :)

Created on Nov 7, 2016 9:46:02 AM by  Stephan Linke [Paessler Support]



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.