Symptom
You want to execute online index rebuild using BRTOOLS in Oracle enviroment.
Solution
1. Logon to the operating system as ORASID and execute command BRTOOLS. Choose 3 – Segment management.
------------------------------------------------------------------------------- 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 -------------------------------------------------------------------------------
2. Choose 2- Rebuild indexes.
------------------------------------------------------------------------------- Database segment management 1 = Reorganize tables 2 - Rebuild indexes 3 - Export tables 4 - Import tables 5 - Alter tables 6 - Alter indexes 7 - Additional segment functions 8 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
3. Select 7 ~ Index names (index) to fill in the index name. Then, select 3 ~ Rebuild action (action) as rebuild.
-------------------------------------------------------------------------------
BRSPACE options for rebuild of indexes
1 - BRSPACE profile (profile) ...... [initSID.sap]
2 - Database user/password (user) .. [/]
3 ~ Rebuild action (action) ........ [rebuild]
4 ~ Tablespace names (tablespace) .. []
5 ~ Index owner (owner) ............ []
6 ~ Table names (table) ............ []
7 ~ Index names (index) ............ [index-name]
8 - Confirmation mode (confirm) .... [yes]
9 - Extended output (output) ....... [no]
10 - Scrolling line count (scroll) .. [20]
11 - Message language (language) .... [E]
12 - BRSPACE command line (command) .
[-p initSID.sap -s 20 -l E -f idrebuild -a rebuild -i "index-name"]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
4. Choose c (twice) to execute the rebuild process.
BR0662I Enter your choice: c BR0280I BRTOOLS time stamp: 2013-05-25 16.26.31 BR0663I Your choice: 'c' BR0259I Program execution will be continued... BR0291I BRSPACE will be started with options '-p initSID.sap -s 20 -l E -f idrebuild -a rebuild -i "index-name"' BR0280I BRTOOLS time stamp: 2013-05-25 16.26.31 BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort: c BR0280I BRTOOLS time stamp: 2013-05-25 16.26.53 BR0257I Your reply: 'c' BR0259I Program execution will be continued... ###############################################################################
5. Choose c again to continue.
-------------------------------------------------------------------------------
Options for rebuild of indexes: SAPSR3.index-name (degree 1)
1 ~ New destination tablespace (newts) ........ []
2 - Parallel threads (parallel) ............... [1]
3 ~ Index parallel degree (degree) ............ []
4 ~ Category of initial extent size (initial) . []
5 - Index rebuild mode (mode) ................. [online]
6 - SQL command (command) .....................
[alter index "SAPSR3"."index-name" rebuild online]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
6. You will received below status once the rebuild is successfully completed
BR0280I BRSPACE time stamp: 2013-05-25 16.29.29 BR1151I Starting online index rebuilding... BR0280I BRSPACE time stamp: 2013-05-25 16.29.54 BR1016I SQL statement '/* BRSPACE */ alter index "SAPSR3"."index-name" rebuild online' executed successfully BR1156I Index SAPSR3.index-name rebuilt successfully BR0280I BRSPACE time stamp: 2013-05-25 16.29.54 BR1152I Number of indexes rebuilt successfully: 1 BR0280I BRSPACE time stamp: 2013-05-25 16.29.54 BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort: c BR0280I BRSPACE time stamp: 2013-05-25 16.30.10 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRSPACE time stamp: 2013-05-25 16.30.10 BR1023I Number of indexes processed: 1 BR1003I BRSPACE function 'idrebuild' completed BR1008I End of BRSPACE processing: selgwhtt.idr 2013-05-25 16.30.10 BR0280I BRSPACE time stamp: 2013-05-25 16.30.11 BR1005I BRSPACE completed successfully ############################################################################### BR0292I Execution of BRSPACE finished with return code 0
7. You can find the log details from below directory. Look for idr files name.
/oracle/SID/sapreorg
