BRTOOLS In DBA

You can use BRTOOLS as a tool:

To display the menus for the BR*Tools user interface using a character-based interface

That is started internally by BRBACKUP, BRARCHIVE, and BRRESTORE

Distinguish between the following:

BR*Tools is the program package containing BRSPACE, BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT, and BRTOOLS.

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.

Features

BRTOOLS as an internal tool started by BRBACKUP, BRARCHIVE, and BRRESTORE has the following features:

Backup verification

The saved files are compared with their originals.

For more information, see -w|-verify.

The option -c force

This denies the commands that are started (such as cpio) access to the console.

For more information, see -c|-confirm.

Parallel backup to a remote host (backup_dev_file = pipe).

BR*Tools for Oracle DBA

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.

Although SAPDBA 6.20 for Oracle is still available for Oracle 9i, it is no longer being developed. Therefore, we strongly recommend you to use the BR*Tools instead.

Integration

The BR*Tools are :

● Integrated with 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:

Prerequisites

The BR*Tools are installed automatically on the database server in the directory /usr/sap//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.

Features

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

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

DBA Operations Monitor

Use the DBA operations monitor for online monitoring of database operations within both internal and external database tools. You can also monitor runtime and remaining time of operations, that are running. The DBA operations monitor can be used regardless of which database you are using. It provides historical as well as current (online) information about the following database operations:

• Backup (for example, to back up or recover the database)
• Performance (for example, checking, creating, updating and deleting database statistics)
• The memory structure (for example, space information for database objects, reorganization of database objects, or extending and deleting database objects).
• Check runs (for example, checking the database for critical situations)
• Configuration (for example, configuring database parameters)

Prerequisites

If a database operation does not fill the corresponding table(s) of the XDB interface or does not fill it (them) correctly, the DBA operations monitor will either display it (them) incorrectly or not at all.

Features

To call the DBA operations monitor, choose Tools ® CCMS ® DB administration ® Operations monitor Alternatively, call Transaction DB24.

The initial screen displays a table containing the database operations.
The table includes the following columns:

Column	Meaning
Date	Date of the operation
Time	Start time of the operation
FID	Type of operation
Object	Database objects affected by the operation
Status	Status of the operation STARTED The operation started. However information about the operation is not yet available (for example, percent complete, or estimated remaining time). RUNNING The operation is running and information about the operation is available. COMPLETED The operation is finished
RC	Operation result 0 means "Everything OK" 1 means "Warning" 2 to 9999 means "Error"
Runtime	Runtime of the operation
Program	Program that executes the operation (for example, SAPDBA)
Description	Short description of the operation

The initial screen also displays an overview of:

• Database operations already completed
• Database operations that are still running
• Current DBA operations monitor setup

Activities

Displaying specific database operations

To display specific database operations (for example, backup/recovery operations), choose the corresponding pushbutton, or the menu option under DBA operation. Choose Overview to display all DBA operations.

Displaying specific views

To display specific views (for example, to display those database operations with status "warning", or those with status "error") choose Setup ® Filter. Then choose either Warning message or Error. Choose the menu option All , to display all database operations. To set the time period for the view, choose Setup ® Filter ® Time period.

Update display

To update the display of database operations, choose Edit ® Refresh, or choose Refresh on the application toolbar.

Automatically update display

To automatically refresh the display of database operations, choose Setup ® Auto Refresh ® Auto refresh ON. To deactivate automatic refresh of the display, choose Auto refresh OFF. To set the time interval for the refresh, choose Setup ® Auto Refresh ® Refresh interval.

Delete table entries

To delete database operations from the table, first select the relevant entries. Then choose Edit ® Delete, or Delete on the application toolbar.

Automatically delete table entries

To automatically delete table entries, choose Setup ® Auto Delete ® Auto delete ON. Choose Auto delete OFF to deactivate automatic delete. To set the time interval for the refresh, choose Setup ® Auto Delete ® Delete interval.

Sort table entries

To sort columns in ascending or descending order, first select the relevant column. Then choose Edit ® Sort and Sort in descending order, or Sort in ascending order. Alternately, choose Sort descending or Sort ascending on the application tool bar.

Save setup

To save all your settings (filter, auto refresh, and auto delete), choose Setup ® Save.

Details about database operations

For details about operations (for example, remaining time for the operation, or directory and name of the log file), double-click the table entry, or select the table entry and choose Display details on the application toolbar. On the next screen, choose Refresh on the application toolbar to update the display. Use Display action log to display a detailed log for the database operation.