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
---------------------------------------------------------------