sapdba -check (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

sapdba -check

Use

You can use this SAPDBA command with the Oracle database to check the database system, as follows:

Space monitoring (fill and fragmentation)

Monitoring of Oracle alert messages

Check on the init.ora profile parameters

Physical consistency (availability of data files, control files and redo log files)

Check on certain problem situations, based on our experience of SAP database administration

Recommendation

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

Prerequisites

When you start SAPDBA with a command option (which does not invoke the SAPDBA initial menu), you can use the operating system to substitute the password by reading a data file. Then the password does not appear in the process list of the operating system.
In the following example, the file <file_name> contains the password:

Example

sapdba -check -l system < <file_name>

Syntax

Use the command sapdba -check -e <no._of_extents> to adjust the default number of extents (2), for checking the tablespace overflow. However, we recommend you to make individual adjustments to the database system check in the table DBCHECKORA (transaction DB17) using the Computing Center Management System (CCMS) of the SAP System.

Start the database system check function weekly, if possible as a background process. For more information, see DBA Planning Calendar (Oracle).

Result

You can view the results of the database check in the logs in the directory sapcheck/<timestamp>.chk.

See also:

Checking the Database System

Configuring the Database System Check