Hello,
I am using the below query to get the daily current backup status report of a database group in OEM. But wanted to see the past backup status data for all the targets. Meaning target on one side and displaying its backup status day by day from the past. The set time period option in the report does work for this query. I am also playing with the start date but of no luck.
I know we get the individual historical backup report from the availability page of the database but that doesn't work for us as we need the report for a group of databases.
Is there any other management report view to get the historical backup data.
Please let me know if that works or do I need to go with any other way around, Please help.
SELECT SUBSTR(T.HOST_NAME,1,INSTR(T.HOST_NAME,'.',1,1)-1) AS "HOST",
C.MEMBER_TARGET_NAME AS "DATABASE",
H.STATUS AS "BACKUP STATUS",
H.START_TIME AS "START TIME",
H.END_TIME AS "END TIME",
H.OUTPUT_BYTES_DISPLAY AS "BYTES"
FROM MGMT$TARGET T, MGMT$HA_BACKUP H, MGMT$TARGET_COMPOSITE C, MGMT$TARGET TC
WHERE TC.TARGET_GUID = HEXTORAW(??EMIP_BIND_TARGET_GUID??)
AND TC.TARGET_NAME = C.COMPOSITE_NAME
AND T.TARGET_NAME = C.MEMBER_TARGET_NAME
AND H.TARGET_GUID = T.TARGET_GUID