Is there a script that will alert a DBA if a database has been in backup mode for a specified period of time. (Ex. 1 hr, 2hr, etc…) that can be registered in OEM as an alert.
Apologies for late reply. You will have to write a OS script and then register it OS defined metrics. You can also have it as User defined metric with query on V$BACKUP view.