BRCONNECT Default Conditions for Database OperationsThe check conditions for database operations are specified in the control table DBCHECKORA
. For more information, see Database System Check with BRCONNECT.
Condition |
Severity |
Description |
|---|---|---|
|
Warning |
Checks whether the last backup of the offline redo log files with BRARCHIVE failed. BRCONNECT takes the following function IDs into account:
The |
|
Warning |
Checks whether the last complete backup of the database with BRBACKUP failed. BRCONNECT takes the following function IDs into account:
The |
|
Warning |
Checks whether the last update of the optimizer statistics with BRCONNECT failed. BRCONNECT takes the following function IDs into account:
These refer to the entire database. The |
|
Warning |
Checks whether the last DBA operation failed, which is identified by a function ID specified in the This condition does not have test operands, threshold values, or value units. You can also define this condition by specifying the function ID in the |
|
Warning |
Checks whether the last successful backup of the offline redo log files with BRARCHIVE is too old. BRCONNECT takes into account the following function ids:
The
The last successful backup of the offline redo log files is older than |
|
Warning |
Checks whether the last successful complete backup of the database with BRBACKUP is too old. BRCONNECT takes into account the following function IDs:
The
The last successful complete backup of the database is older than |
|
Warning |
Checks whether the last successful update of the Optimizer statistics with BRCONNECT is too old. BRCONNECT takes the following function ID into account:
The
The last successful update of the optimizer statistics is older than |
|
Warning |
Checks whether the last successful DBA operation, identified by a function ID specified in the Possible test operands, threshold values, value units:
The last successful DBA operation is older than You can also define this condition by specifying the function ID in the |
Note
Since the test conditions for database operations are programmed in a specific way in BRCONNECT (known as built-in test conditions), you cannot add new check conditions to the DBCHECKORA
table. However, this is generally not necessary because operations can be
monitored by the LAST_OPERATION_FAILED
and OPERATION_TOO_OLD
check conditions, or by specifying function IDs in the PARAM
field.