BR*Tools for Oracle DBA

Use

SAP provides the tools BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, BRCONNECT, and BRTOOLS to manage and protect the data in your Oracle database.

This section describes how to perform Oracle DBA with BR*Tools. For more information on how to work out an approach to Oracle DBA, see Approach to Oracle DBA .

For more information on other tools, including the Oracle tool SQL*Plus, see Other Tools for Oracle DBA.

Although SAPDBA 6.20 for Oracle is still available for Oracle 9i, it is no longer being developed. Therefore, we strongly recommend you to use the BR*Tools instead.

Integration

The BR*Tools are :

● Integrated with BRTOOLS, which is the character-based interface that calls BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, and BRCONNECT

· Available for the operating systems UNIX and Microsoft Windows

Distinguish between the following:

● BR*Tools is the program package containing BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, BRCONNECT, and BRTOOLS.

● BRTOOLS is the program that displays the menus from which the other BR programs are called.

As an example, the following graphic shows the integration of the backup, restore, and recovery tools:

Prerequisites

The BR*Tools are installed automatically on the database server in the directory /usr/sap//SYS/exe/run.

We classify BR*Tools as functional, help, batch, and interactive tools:

Tool Types for BR*Tools

Type	Tool	Description
Functional	BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, and BRCONNECT	Perform actions directly on database files or objects
Help	BRTOOLS and BRCONNECT	● BRTOOLS is the menu program that can call all other functional tools interactively ● BRTOOLS and BRCONNECT are also called internally: ○ BRTOOLS is called by BRBACKUP, BRARCHIVE, and BRRESTORE for backup, restore, and verification. ○ BRCONNECT is called by BRBACKUP to monitor the database during a backup
Batch	BRBACKUP, BRARCHIVE, BRRESTORE, BRCONNECT	Only run on their own in batch, without menus. You can call them interactively with BRTOOLS.
Interactive	BRSPACE, BRRECOVER, BRTOOLS	Run interactively with their own menus. BRSPACE and BRRECOVER can also run in batch mode.

There is a menu in BRCONNECT to change the database password in GUI mode.

Messages and Return Codes for the BR*Tools

Messages

The BR*Tools issue messages in the following form:

BR Message text

NNNN: Sequential number of the message

X: Type of message:

· I: Information

· W: Warning

· E: Error message

The text of the message contains the following variables:

· %s: a string

· %d: an integer

· %f: a real number in floating-point format

In most cases, the SAP tools issue a group of messages, which enables you to precisely analyze the error.

Return Codes

The following return codes are possible:

0	Successful
1	Warnings – all files were processed (for example, backed up or restored)
2	Canceled during the initialization phase by a user or other signal
3	Errors occurred during the initialization phase, processing was not started
4	Canceled by a user or other signal during processing
5	Started, but not completed because errors occurred during processing
6	Internal termination