BR*Tools User Interface

Use

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:

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

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 database and 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 files main 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

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