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:
BRGUI is the graphical interface for BR*Tools. It displays output and gathers user input for BR*Tools.
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
----------------------------------------------------------