Here are some reasons why you should monitor your Oracle ACM database and how:
Corruption can be logical or physical. For logical, one can't do much before it happens, for physical corruption, you should monitor the physical server that hosts the database.
2) Space issues in the database.
Your data volume grows, or the database needs large temporary space for specific statements, the database might run out of space in a tablespace. This will lead to either failure in work items in the database, or to a complete standstill of the database.
3) Other Oracle errors.
Like any software product, the ACM database might run into an Oracle issue that may or may not affect your database health. ANY ERROR MESSAGE in the database alert.log should be examined for its importance.
4) OS errors.
The Operating system will also alert to problems, which may in the end affect the health of your database.
How to monitor the database:
Oracle Enterprise Manager Database Control.
The Hardware Appliance, and the Software Appliance with local database are installed with the Oracle Enterprise Manager Database Console.
DBConsole is a light weight monitoring tool that comes with every Oracle database. It monitors just one database. Your organization might have more Oracle databases, and the Database Administrator team might have the more extensive Enterprise Manager Cloud Control, into which your ACM database could be integrated for monitoring.
The console is automatically started with ACM, and is available at this url: https://<acm-server>:1158/em/console
In the following example, you see in yellow the places where you would see errors and alerts show up.
You can also specify to receive email notifications. Refer to the Oracle documentation here on how to set these up.
Database Alert Log
The database alert log can be physically found at the location indicated by this query:
oracle@acm-691:~> sqlplus / as sysdba
SQL*Plus: Release 184.108.40.206.0 Production on Fri Oct 30 17:24:00 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Oracle Database 11g Release 220.127.116.11.0 - 64bit Production
With the Automatic Storage Management option
SQL> show parameter background_dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /u01/app/oracle/diag/rdbms/avdb/AVDB/trace b/AVDB/trace
It will show any errors that happen on the database, and each one should be carefully examined to determine if they can be ignored or measures should be taken to correct the issue.
Operating System Log
The Operating System Log for Hardware and Software Appliances is /var/log/messages
It will indicate any Hardware or OS issues. These should be carefully examined and mediated if necessary. Special attention should be paid to any disk related error messages. Disks are smart and can relocate bad blocks, however, a growing number of disk errors would be a good indication to have the disk swapped, if further diagnostics confirm a Hardware issue.
Any error in the database alert.log or the Operating System log should be detected in real time and reacted upon to prevent an outage to the ACM database.