Show TOC

BR*Tools for Oracle DBALocate this document in the navigation structure

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.

Integration

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

    Note

    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/<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

  • 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 during 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.

Note

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

Features

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 online and offline 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

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

Activities

For more information, see Getting Started with BR*Tools.