This alert monitors each active archive log destination and will tell you when any of the destinations are having problems, i.e. the status is anything other than 'VALID'.
To create this alert, create a Custom SQL Multiple Numeric Alert and use the attached query for the SQL Statement. Here is an example of an alert with thresholds:
