When Oracle is configured in ARCHIVELOG mode, once redo logs are filled, they are archived to another location, possibly for a standby database to apply or just for safekeeping. To monitor the archiver and ensure it's working properly, this custom alert will make use of the V$ARCHIVE_DEST view to check for errors.
Note that this query only watches for archive destinations with a STATUS='ERROR', but there may be additional status you want to check for as well. Here is a link to Oracle documentation for this V$ view: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-ARCHIVE_DEST.html.
To create this custom alert in DPA, create a Custom SQL - Multiple Numeric Alert and use the attached query for the SQL statement. It should look something like this:
