BR*Tools User Interface

The user interface to BR*Tools provides you with menus to perform a wide range of database administration functions for your Oracle database. The menus are controlled by BRTOOLS, which in turn calls one of the functional BR programs.

You can use BR*Tools with a:

Character-based interface, as in the following example, which shows the main menu:
BR0280I Time stamp 2003-03-06 11.30.57

BR0656I Choice menu 1 - please make a selection

----------------------------------------------------------------

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

----------------------------------------------------------------

BR0662I Enter your choice:
GUI, as in the following example, which shows the main menu:

Note

BRGUI is the graphical interface for BR*Tools. It displays output and gathers user input for BR*Tools.

End of the note.

Features

You see the following types of menus when using BRTOOLS:

Control
This type of menu leads you from step to step in a pre-defined sequence. You can repeat steps in the correct sequence. Here is an example:

BR0655I Control menu 101 - please decide how to proceed

---------------------------------------------------------------

Complete database recovery main menu

1 = Check the status of database files

2 * Select database backup

3 * Restore data files

4 * Restore and apply incremental backup

5 * Restore and apply archivelog files

6 * Open databaseand post-processing

7 - Exit program

8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

---------------------------------------------------------------

It is normally possible for you to repeat steps from a control menu but this is not always a sensible thing to do. Only repeat steps when you understand what the effects will be.
Choice
This type of menu lets you make an independent choice from the menu in any sequence. You can repeat the choice as often as required. Here is an example:

BR0656I Choice menu 120 - please decide how to proceed

---------------------------------------------------------------

Restore of individual backup filesmain menu

1 = Restore files from BRBACKUP backup

2 - Restore individual files from tape

3 - Restore individual files from disk

4 - Restore individual files from backup utility

5 - Restore and apply incremental backup

6 - Exit program

7 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

---------------------------------------------------------------
Input
This type of menu lets you enter required parameters or options. Here is an example:

BR0657I Input menu 123 - please check/enter input values

---------------------------------------------------------------

BRRESTORE main options for restore from BRBACKUP backup

1 - BRRESTORE profile (profile) ........ [initGC2.sap]

2 - BRBACKUP backup run (backup) ....... [bdjwgvvh.fnf]

3 - Fill-up previous restores (fillup) . [no]

4 - Restore device type (device) ....... [util_file]

5 - BACKINT/Mount profile (parfile) .... [initGC2.utl]

6 # Database user/password (user) ...... [system/*******]

7 ~ Restore destination (rest_dest) .... []

8 - Files for restore (mode) ........... [2,11-12]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

---------------------------------------------------------------
List
This type of menu displays a list of items from which you select one entry. Here is an example:

BR0658I List menu 121 - please select one entry

---------------------------------------------------------------

BRBACKUP database backups for restore

Pos. Log Start Type Files Device Rc

1 = bdjwhckx.ffd 2003-01-29 17.30.51 offline 110/0 disk 0

2 - bdjwhadu.fft 2003-01-29 17.05.14 offline 112/0 tape 1

3 - bdjwgyrq.fff 2003-01-29 16.48.42 offline 112/0 util_onl 0

4 - bdjwgwtj.fnt 2003-01-29 16.26.55 onl_cons 115/0 tape 0

5 - bdjwgvvh.fnf 2003-01-29 16.16.29 onl_cons 115/0 util_onl 0

BR0280I Time stamp 2003-01-29 19.05.29

There are a number of sub-types for the list menu:
- List menu with optional single selection
  BR0658I List menu 365 - you can select one entry
  
  ---------------------------------------------------------------
  
  List of BRSPACE export runs
  
  Pos. Run Date Tables Dumps Size[KB]
  
  1 - sdlmvogy.tbe 2003-09-11 20.28.36 1 1 2
  
  2 - sdlmqobv.tbe 2003-09-10 20.01.43 2 1 14
  
  3 - sdlmqimk.tbe 2003-09-10 18.58.42 2 1 5
  
  4 - sdlmqgin.tbe 2003-09-10 18.34.29 2 1 18
  
  5 - sdlmqfmw.tbe 2003-09-10 18.25.06 2 1 12
  
  ...
  
  Press <Rtn> to scroll, <n> to select, 'c' to continue, 's' to stop scrolling..
- List menu with multiple selection
  BR0659I List menu 312 + please select one or more entries
  
  ---------------------------------------------------------------
  
  List of tablespaces for alter
  
  Pos. Tablespace Files/AuExt. Type Status SegMan. ExtMan. Backup
  
  1 - DRSYS 1/1 DATA ONLINE AUTO LOCAL NO
  
  2 - EXAMPLE 1/0 DATA ONLINE AUTO LOCAL NO
  
  3 - INDX 1/1 DATA ONLINE AUTO LOCAL NO
  
  4 - PSAP1111D 1/1 DATA ONLINE AUTO LOCAL NO
  
  5 - PSAP1111I 1/1 DATA ONLINE AUTO LOCAL NO
  
  ...
  
  Standard keys: c - cont, b - back, s - stop, r - refr, h - help
  
  ---------------------------------------------------------------
- List menu with optional multiple selection
  BR0659I List menu 259 + you can select one or more entries
  
  ---------------------------------------------------------------
  
  List of database tablespaces
  
  Pos. Tablespace Type Status ExtMan. SegMan. Backup Files/AuExt.
  
  Total[KB] Used[%] Free[KB] ExtSize[KB] FreeExt. Largest[KB]
  
  1 - DRSYS DATA ONLINE LOCAL AUTO NO 1/1
  
  10240 47.50 5376 1038336 2 1038336+:5312:64
  
  :0:0
  
  2 - EXAMPLE DATA ONLINE LOCAL AUTO NO 1/0
  
  123520 8.29 113280 0 5 93056:16128:22
  
  40:1728:128
  
  3 - INDX DATA ONLINE LOCAL AUTO NO 1/1
  
  5120 1.25 5056 1043456 1 1043456+:5056:0:
  
  0:0
  
  ...
  
  Standard keys: c - cont, b - back, s - stop, r - refr, h - help
  
  ---------------------------------------------------------------
- List display without selection
  BR0660I List display 352 - no selection possible
  
  ---------------------------------------------------------------
  
  List of tables for reorganization
  
  Pos. Owner Table Part. Rows Space[KB] Data[KB:%]
  
  1 - SAPR3 DBABARL NO 429 64 42:65
  
  2 - SAPR3 DBABD NO 1068 320 253:79
  
  3 - SAPR3 DBABL NO 763 256 189:74
  
  4 - SAPR3 DBADFL NO 0 64 0:0
  
  5 - SAPR3 DBAERR NO 0 64 0:0
  
  ...
  
  Standard keys: c - cont, b - back, s - stop, r - refr, h - help
  
  ---------------------------------------------------------------
Display in form of input menu, but no input possible

BR0692I Display menu 260 # no input possible

---------------------------------------------------------------

Information about tablespace DRSYS

1 - Tablespace type (type) ................... DATA

2 - Tablespace status (status) ............... ONLINE

3 - Extent management (extent) ............... LOCAL

4 - Segment space managenent (space) ......... AUTO

5 - Backup status (backup) ................... NO

6 - Number of files in tablespace (files) .... 1

7 - Number of autoextensible files (autoext) . 1

8 - Total tablespace size in KB (total) ...... 10240

9 - Used space in tablespace in % (used) ..... 47.50

10 - Free space in tablespace in KB (free) .... 5376

11 - Maximal extension size in KB (extsize) ... 1038336

12 - Number of free extents (freext) .......... 2

13 - Largest free extents (largest) ........... 1038336+:5312:64:0:0

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

---------------------------------------------------------------