Search This Blog

Thursday, February 16, 2012

BR*Tools for Oracle DBA


This graphic is explained in the accompanying text

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:


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.



Toolset for BR*Tools

Tool

Purpose

BRBACKUP

Backs up data files, control files, and online redo log files of the database

BRARCHIVE

Backs up offline redo log files

BRRESTORE

Restores data files, control files, and redo log files

BRRECOVER

Recovers database files and restores profiles and log files

BRSPACE

Manages the database instance, space, and segments (that is, tables and indexes)

BRCONNECT

      Performs database administration tasks such as statistics update, check database system, adapt next extents, clean up logs and DBA tables

      Functions as a help tool to monitor the database during a backup

BRTOOLS


      Displays the menus from which the other BR programs are called

      Functions as an internal help tool started by BRBACKUP, BRARCHIVE, and BRRESTORE

BRGUI

Functions as a Java-based GUI, working as the front-end display program for BR*Tools



No comments:

Post a Comment