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.
The BR*Tools are:
Integrated with the menus of 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:
The BR*Tools are installed automatically on the database server in the directory /usr/sap/<SAPSID>/SYS/exe/run.
We classify BR*Tools as functional, help, batch, and interactive tools:
Type |
Tool |
Description |
---|---|---|
Functional |
BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, and BRCONNECT |
Perform actions directly on database files or objects |
Help |
BRTOOLS and BRCONNECT |
|
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.
Tool |
Purpose |
---|---|
Backs up data files, control files, and online redo log files of the database |
|
Backs up offline redo log files |
|
Restores data files, control files, and online and offline redo log files |
|
Recovers database files and restores profiles and log files |
|
Manages the database instance, space, and segments (that is, tables and indexes) |
|
|
|
|
|
BRGUI |
Functions as a Java-based GUI, working as the front-end display program for BR*Tools |
The following features apply to all the BR*Tools:
Menu-driven interface, including GUI, in English or German
Context-sensitive supporting information
Detail and summary logs
Available with operating systems UNIX and Microsoft Windows
Command-line options for experts
For more information, see Getting Started with BR*Tools.