Show TOC

BR*Tools User InterfaceLocate this document in the navigation structure

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:

    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.

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 split/standby control files

    4 * Restore data files

    5 * Restore split incremental control files

    6 * Restore and apply incremental backup

    7 * Restore and apply archivelog files

    8 * Open database and post-processing

    9 - Exit program

    10 - 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 a pply 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) ....... [befwgvvh.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 d estination ( 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 = behwhckx.ffd 2012-01-29 17.30.51 offline 110/0 disk 0

    2 - behwhadu.fft 2012-01-29 17.05.14 offline 112/0 tape 1

    3 - behwgyrq.fff 2012-01-29 16.48.42 offline 112/0 util_onl 0

    4 - behwgwtj.fnt 2012-01-29 16.26.55 onl_cons 115/0 tape 0

    5 - behwgvvh.fnf 2012-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] Util.

      1 - segmvogy.tbe 2011-09-11 20.28.36 1 1 2 EXPDP

      2 - segmqobv.tbe 2011-09-10 20.01.43 2 1 14 EXPDP

      3 - segmqimk.tbe 2011-09-10 18.58.42 2 1 5 EXPDP

      4 - segmqgin.tbe 2011-09-10 18.34.29 2 1 18 EXPDP

      5 - segmqfmw.tbe 2011-09-10 18.25.06 2 1 12 EXPDP

      ...

      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 261 + you can select one or more entries

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

      List of database data files

      Pos. Tablespace Status Type File

      Id. Size[KB] Device Back. AuExt. MaxSize[KB] IncrSize[KB]

      1 - PSAPBTABD ONLINE FILE E:\ORACLE\PC1\SAPDATA4\BTABD_1\BTABD.DATA1

      8 61440 4 NO NO 0 0

      2 - PSAPBTABI ONLINE FILE E:\ORACLE\PC1\SAPDATA3\BTABI_1\BTABI.DATA1

      9 30720 4 NO NO 0 0

      3 - PSAPSTABD ONLINE FILE E:\ORACLE\PC1\SAPDATA3\STABD_1\STABD.DATA1

      6 81920 4 NO NO 0 0

      4 - PSAPSTABI ONLINE FILE E:\ORACLE\PC1\SAPDATA4\STABI_1\STABI.DATA1

      7 40960 4 NO NO 0 0

      ...

      11 - PSAPTEMP ONLINE FILE E:\ORACLE\PC1\SAPDATA2\TEMP_1\TEMP.DATA1

      -1 29696 4 NO NO 0 0

      12 - PSAPUNDO ONLINE FILE E:\ORACLE\PC1\SAPDATA1\UNDO_1\UNDO.DATA1

      3 107520 4 NO YES 33554416 5120

      13 - SYSAUX ONLINE FILE E:\ORACLE\PC1\SAPDATA2\SYSAUX_1\SYSAUX.DATA1

      2 778240 4 NO YES 33554416 10240

      14 - SYSTEM SYSTEM FILE E:\ORACLE\PC1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

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

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

    • List display with selection

      BR0659I List menu 352 + please select one or more entries

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

      List of tables for reorganization

      Pos. Owner Table Pt. DgPk. Rows Used[KB] Data[KB:%]

      1 - SAPSR3 ABCD NO 1 1 32 0:0

      2 - SAPSR3 ARFCRSTATE NO 1 0 0 0:0

      3 - SAPSR3 ARFCSDATA NO 1 0 0 0:0

      4 - SAPSR3 ARFCSSTATE NO 1 0 0 0:0

      5 - SAPSR3 ATAB NO 1 0 0 0:0

      6 - SAPSR3 BALDAT NO 1 0 0 0:0

      7 - SAPSR3 BLOBTAB NO 1 1 32 0:0

      8 - SAPSR3 CCPROF NO 1+ 0 0 0:0

      9 - SAPSR3 CDCLS NO 1 0 0 0:0

      10 - SAPSR3 CLOBTAB NO 1 3 32 0:1

      11 - SAPSR3 DARTT NO 1 0 0 0:0

      12 - SAPSR3 DBABARL NO 1 217 64 21:33

      13 - SAPSR3 DBABD NO 1 321 512 71:14

      14 - SAPSR3 DBABL NO 1 65 64 16:25

      ...

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

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

  • Display in form of input menu, but no input possible

    BR0280I BRSPACE time stamp: 2012-02-13 14.24.02

    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 - Bigfile tablespace (bigfile) .............. NO

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

    8- Number of autoextensible files (autoext).... 0

    9 - Tablespace compression (compression) ...... NO

    10 - Tablespace encryption (encryption) ....... NO

    11- Total tablespace size in KB (total) ....... 61440

    12 - Used space in tablespace in % (used) ..... 25.73

    13 - Free space in tablespace in KB (free) .... 45632

    14 - Maximum tablespace size in KB (maxsize) .. 61440

    15 - Maximum extension size in KB (extsize) ... 1038336

    16 - Used space as to max. size in % (used) ... 25.73

    17 - Free space as to max. size in KB (free) .. 45632

    18 - Allocated disk space in KB (space) ....... 61448

    19 - Number of free extents (freext) .......... 133

    20 - Largest free extents (largest) ........... 8192:8192:5120:3072:2048

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

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