Database System Check (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Database System Check

Purpose

This section helps you develop an approach to checking the database system. By running regular checks of the database system, you can identify potential problems and take the necessary action. You can schedule regular checks in the Computing Center Management System (CCMS) of the SAP System, using the DBA Planning Calendar. You can also run checks with BRCONNECT.

Prerequisites

For more information on how BRCONNECT performs database system check, see Database System Check with BRCONNECT. This is the same functionality as used in the DBA Planning Calendar.

Process Flow

You choose a method to run the database system check:

Regularly, preferably daily, by scheduling it in the DBA Planning Calendar – recommended for normal use

Recommendation

We recommend you to select an action pattern in the DBA Planning Calendar. Action pattersn enable you to schedule the database system check daily.

One-off by using the BRCONNECT command -f check – recommended for non-standard checks

Recommendation

We strongly recommend you to use this BRCONNECT function rather than the equivalent SAPDBA one, sapdba -check. The reason is that we will in future no longer develop the SAPDBA functions, whereas BRCONNECT functions will always be fully up-to-date.

You check the results using CCMS and take any necessary action:

You normally use the alert monitor to check the results of the system check.

For a detailed technical view, see Displaying Alert Messages from Database System Check.

If required, you configure database system check using CCMS. This includes activating or deactivating conditions and changing the threshold and severity levels (that is, error, warning, or exception). For more information, see Configuring Database System Check (Oracle).