Ramn backup monitoring

[Nijin K]

how can we monitor RMAN  backup monitoring in UIM

UIM -8.51 version

Reagrds
Nijin

[Luc Christiaens]

The question is:
- what commands or sql queries do you use to monitor your backups?
- what logs do you check?
Once you know what you want to monitor you can probably:
- monitor the logs via logmon
- if you have commands that generate meaningful output you can enter those also in logmon
- if you have sql queries to execute you can use the sql_response probe
The logmon and sql_response probes can generate alarms and/or QoS metrics

[Nijin K]

i do have the query to monitor the Rman backup in oracle servers but that query gives 20 days data 

our db team require data for 1 day to monitored which is not possible by Oracle probe

that is why i need another way to configure the Rman backup monitoring

[David Michel]

If your db team can provide the query it can be used for creating a custom checkpoint in the oracle probe.

------------------------------
Support Engineer
Broadcom
------------------------------

[Nijin K]

Yes David

i created the checkpoint in the oracle probe but the below mentioned script is fetching data from start of RMAN Backup on a particular server

select OUTPUT_DEVICE_TYPE,SESSION_KEY, INPUT_TYPE,OUTPUT_BYTES_DISPLAY,STATUS,to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key

and the output screenshot is pasted below

so it will create alarm for all the failed backup in past which is not helpful and our db team is not able to modify the query so that it only fetch data for 24 hours

regards
Nijin

[Luc Christiaens]

I do not know Oracle, but it should be possible to ask your DB admins to add a where clause in the query that displays only backup jobs with a start date in the last 24 hours?

[Nijin K]

hi 

i tried to add where clause and get start_time to sysdate but the data is coming up blank,PFB the query i am trying to run

select OUTPUT_DEVICE_TYPE,SESSION_KEY, INPUT_TYPE,OUTPUT_BYTES_DISPLAY,STATUS,to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS where start_time = sysdate and end_time = sysdate order by session_key

Please suggest any changes to get current day's data

[Franklin Ravi D'souza]

Hi

Here are some links 

https://dbatricksworld.com/how-to-check-rman-backup-status-and-timings/
https://oracle-base.com/articles/misc/oracle-dates-timestamps-and-intervals

Since this is modification of oracle query to get expected infomation should probably post this in oracle forums  

[Nijin K]

hi all

so i was finally able to modify the query to a point where it would only fetch data for 24 hours from current which almost fulfilled my requirement 

Pasting the screenshot of query for reference

thanks for the help

Regards
Nijin