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

BRCONNECT

Use

The SAP tool BRCONNECT for Oracle databases is used as:

A database administration tool, which you can call yourself from the command line

A utility tool, which BRBACKUP calls in the background

Note

BRCONNECT was originally only a utility tool. Now you can also start it from the command line and it has taken over some of the functionality of SAPDBA. Therefore, certain SAPDBA functions are no longer being developed.

We strongly recommend you to use BRCONNECT rather than SAPDBA where the two tools perform the same tasks.

BRCONNECT is specially designed to administer multi-schema databases, in which you have more than one SAP System in the same Oracle database:

This graphic is explained in the accompanying text

Features

Database administration tool

As a database administration tool, BRCONNECT has the following functions:

Main functions, which write a detailed and a summary log

Check database system, -f check

Adapt next extents, -f next

Update statistics, -f stats

Clean up old logs and traces, -f cleanup

Additional functions, which only write messages to the standard output device

Change passwords of SAP database users, -f chpass

Create global synonyms, -f crsyn – these are used by BR tools and SAPDBA

Start database, -f dbstart

Stop database, -f dbshut

Determine database state, -f dbstate

Utility tool - monitor database status during a backup

BRBACKUP starts BRCONNECT during the backup to see if the status of the database corresponds to the backup mode. If you select backup mode online (backup_type = online), the database remains in this state during the backup.

If you select backup mode offline (backup_type = offline or backup_type = offline_force), the database is shut down and remains in the closed state during the backup.

If the state of the database changes unexpectedly during the backup, BRCONNECT terminates the backup and displays the messages BR312E or BR313E. After the backup, the database is always restored to its original status. This means that the database is left started, if it was running before the backup, or it is shut down, if it was shut down before the backup.

BRCONNECT has many parameters, which you can specify in the Initialization Profile init<DBSID>.sap.

Activities

For more information about using BRCONNECT from the command line, see Command Options for BRCONNECT.