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:

This graphic is explained in the accompanying text


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 to scroll, 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

No comments:

topics