Show TOC

Check and Verification with BR*ToolsLocate this document in the navigation structure

Use

You can check and verify your Oracle database with BR*Tools.

You typically use BR*Tools menus for a one-off check and verification. The aim of regular checks and verification is to detect and correct potentially critical problems before these lead to downtime of the production database.

For more information, see Database System Check.

Recommendation

For routine check and verification, we recommend one of the following:

  • DBA Planning Calendar to schedule a check or verification and then view its log

  • The scheduler cron for UNIX or at for Windows

  • We recommend you to regularly verify the database blocks - for example, once a week - if you do not use RMAN to back up the database.

Integration

  • BRTOOLS normally calls the SAP tool BRCONNECT or BRBACKUP. You can also perform a check or verification directly by calling BRCONNECT or BRBACKUP from the command line.

    Recommendation

    We recommend you to normally use BRTOOLS rather than BRCONNECT or BRBACKUP. This is because the BRTOOLS menus simplify entry of the correct parameters.

  • Make sure that you have set the necessary parameters for BRCONNECT and BRBACKUP in the Initialization Profile init<DBSID>.sap.

Features

You can perform the following check and verification functions with BR*Tools:

  • Database system check

  • Validation of database structure

  • Verification of database blocks

Activities

  1. You call the required function in BRTOOLS and check the displayed parameters, changing them as required.

    The default, which is set in the initialization profile init<DBSID>.sap, is to check or verify the entire database.

  2. If required, you change the default values for the check or verification parameters in the initialization profile init<DBSID>.sap and restart BRTOOLS.

  3. If required, you choose Start of the navigation path Check and verification Next navigation step Reset program status End of the navigation path to set the defaults used to the values in the initialization profile init<DBSID>.sap. For certain input values, there is no corresponding parameter in the initialization profile, in which case the default value from the BRTOOLS program is used.

  4. You start the check or verification.

  5. You check the results of the check or verification in the BRCONNECT logs or the BRBACKUP logs.