In SAP system, Oracle database administration will be done using BR*Tools program package. They are installed automatically on the oracle database server in the directory /usr/sap/<SAPSID>/SYS/exe/run or /usr/sap/<SAPSID>/SYS/exe/uc/NTAMD64. This package includes the following programs.

1. BRBACKUP – This program is used to take backup of data files, control files and online redo log files
2. BRARCHIVE – This program is used to take backup of offline redo log files
3. BRRESTORE – This program is used to restore data files, control files, online and offline redo log files
4. BRRECOVER – This is interactive tool for datavase restore and recovery
5. BRSPACE – This tool is used for database instance management, space management and reorganization
6. BRCONNECT – This tool is used for database administration like, database check, update of statistics and changing database user password
7. BRTOOLS – This is the interactive tool used for calling the other tools through menus

BRTOOLS is provided as a character based user interface for the functional programs BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE and BRCONNECT. While BRTOOLS enables the administrator
to manage the database through menes using a simple telnet connection or on console level, the graphical user interface BRGUI offers a more convenient way for the database administration.

BRGUI is a Java based graphical user interface for BRTOOLS. BRGUI itself does not offer any own logic for the database administration – it calls BRTOOLS, displays the menus of BRTOOLS and forwards selections and button clicks to BRTOOLS. Using remote shell, it is possible to run BRGUI on the administrators desktop calling BRTOOLS on the remote database server.

When the database administrator has to perform a certain administrative task, instead of calling a tool such as BRRESTORE, BRBACKUP or BRCONNECT directly, we can use the interactive, menu-driven program BRTOOLS. Through nested menus, this tool lets us choose the action and all the necessary options we need including logon information.

You can see the some screen shots of these programs in a folder and menu of the BRTOOLS.

Directory of BR*Tools in the SAP system

BR*Tools Menu of the SAP System

This entry was posted on February 17, 2012 at 11:05 PM. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Posted in SAP Basis Notes by Raj No Comments Yet