Wednesday 21 August 2013

SAP BR*Tools an interactive interface for Oracle database management

Introduction: 

1) SAP delivers the "BR*Tools" to provide an interactive Oracle database administration tools which allow administrator to perform database administration tasks on the operating system level.

2) The tools are installed on the database server: /usr/sap/<SID>/SYS/exe/run

3) Different between BR*Tools and BRTOOLS
    - BR*Tools is the program package containing BRSPACE, BRBACKUP, BRARCHIVE, 
       BRRESTORE, BRRECOVER, BRCONNECT, and BRTOOLS/BRGUI.
    - BRTOOLS is the program that displays the character-based menus from which the other BR programs
       are called. It works together with BRGUI to generate a graphical user interface.

4) The list of tools:
Tools
Description
BRSPACE
Database administration: instance management, space management and reorganization
BRBACKUP
Backup of data files, control files and online redo log files
BRARCHIVE
Backup of offline redo log files
BRRESTORE
Restore of data files, control files and online and offline redo log files
BRRECOVER
Tool for database restore and recovery
BRCONNECT
Database administration: database check, update of statistics, changing user password and etc
BRTOOLS
Interactive tool for calling the other tools through menus
BRGUI
GUI for BRTOOLS

5) To check the BR*Tools version (brtools -V all)

6) Sample of BR*TOOLS:


7) Meaning of the symbol in the menu
Symbol
Description
+
The action is completed
-
Parameter can be change / choose / execute
~
change this optional parameter or reset its value to null
*
Display entry, no input allow
=
This is the initial default choice
?
Parameter value must be enter
#
Cannot:
. Execute this action
. Change this parameter

That's all for the basic of the BR*Tools, we'll me see more on the rest of the administration tools soon ...

No comments:

Post a Comment