Dear all
I am rebuild the index in production serevr in follwing way ,
please advise , this is the right way , any loose data .
C:\>brtools
BR0651I BRTOOLS 7.00 (16)
BR0280I BRTOOLS time stamp: 2009-04-21 16.37.42
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:
4
BR0280I BRTOOLS time stamp: 2009-04-21 16.37.46
BR0663I Your choice: '4'
BR0280I BRTOOLS time stamp: 2009-04-21 16.37.46
BR0656I Choice menu 9 - please make a selection
-
Backup and database copy
1 = Database backup
2 - Archivelog backup
3 - Database copy
4 - Non-database backup
5 - Backup of database disk backup
6 - Verification of database backup
7 - Verification of archivelog backup
8 - Additional functions
9 - Reset program status
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2009-04-21 16.37.47
BR0663I Your choice: '1'
BR0280I BRTOOLS time stamp: 2009-04-21 16.37.47
BR0657I Input menu 15 - please check/enter input values
-
BRBACKUP main options for backup and database copy
1 - BRBACKUP profile (profile) ....... [initQAS.sap]
2 - Backup device type (device) ...... [tape]
3 ~ Tape volumes for backup (volume) . []
4 # BACKINT/Mount profile (parfile) .. []
5 - Database user/password (user) .... [/]
6 - Backup type (type) ............... [offline]
7 - Disk backup for backup (backup) .. [no]
8 # Delete disk backup (delete) ...... [no]
9 ~ Files for backup (mode) .......... [all]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
b
BR0280I BRTOOLS time stamp: 2009-04-21 16.37.52
BR0663I Your choice: 'b'
BR0673I Going back to the previous menu...
BR0280I BRTOOLS time stamp: 2009-04-21 16.37.52
BR0656I Choice menu 9 - please make a selection
-
Backup and database copy
1 = Database backup
2 - Archivelog backup
3 - Database copy
4 - Non-database backup
5 - Backup of database disk backup
6 - Verification of database backup
7 - Verification of archivelog backup
8 - Additional functions
9 - Reset program status
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
b
BR0280I BRTOOLS time stamp: 2009-04-21 16.37.55
BR0663I Your choice: 'b'
BR0673I Going back to the previous menu...
BR0280I BRTOOLS time stamp: 2009-04-21 16.37.55
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:
3
BR0280I BRTOOLS time stamp: 2009-04-21 16.37.58
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2009-04-21 16.37.58
BR0656I Choice menu 7 - please make a selection
-
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
-
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2009-04-21 16.38.06
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2009-04-21 16.38.06
BR0657I Input menu 92 - please check/enter input values
-
BRSPACE options for rebuild of indexes
1 - BRSPACE profile (profile) ...... [initQAS.sap]
2 - Database user/password (user) .. [/]
3 ~ Rebuild action (action) ........ []
4 ~ Tablespace names (tablespace) .. []
5 ~ Index owner (owner) ............ []
6 ~ Table names (table) ............ []
7 ~ Index names (index) ............ []
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 initQAS.sap -s 20 -l E -f idrebuild]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
6
BR0280I BRTOOLS time stamp: 2009-04-21 16.38.15
BR0663I Your choice: '6'
BR0280I BRTOOLS time stamp: 2009-04-21 16.38.15
BR0681I Enter string value for "table" []:
mkpf
BR0280I BRTOOLS time stamp: 2009-04-21 16.38.20
BR0683I New value for "table": 'mkpf'
BR0280I BRTOOLS time stamp: 2009-04-21 16.38.20
BR0657I Input menu 92 - please check/enter input values
-
BRSPACE options for rebuild of indexes
1 - BRSPACE profile (profile) ...... [initQAS.sap]
2 - Database user/password (user) .. [/]
3 ~ Rebuild action (action) ........ []
4 ~ Tablespace names (tablespace) .. []
5 ~ Index owner (owner) ............ []
6 ~ Table names (table) ............ [mkpf]
7 ~ Index names (index) ............ []
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 initQAS.sap -s 20 -l E -f idrebuild -t
"mkpf"]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2009-04-21 16.38.22
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initQAS.sap -s 20 -l E -f idreb
uild -t "mkpf"'
BR0280I BRTOOLS time stamp: 2009-04-21 16.38.22
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2009-04-21 16.38.23
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.00 (16)
BR1002I Start of BRSPACE processing: seakenfs.idr 2009-04-21 16.38.24
BR0280I BRSPACE time stamp: 2009-04-21 16.38.26
BR1009I Name of database instance: QAS
BR1010I BRSPACE action ID: seakenfs
BR1011I BRSPACE function ID: idr
BR1012I BRSPACE function: idrebuild
BR0280I BRSPACE time stamp: 2009-04-21 16.38.26
BR0656I Choice menu 354 - please make a selection
-
Rebuild indexes main menu
1 = Rebuild indexes
2 - Show indexes
3 - Show tables
4 - Show tablespaces
5 * Exit program
6 - Reset program status
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
1
BR0280I BRSPACE time stamp: 2009-04-21 16.38.28
BR0663I Your choice: '1'
BR0280I BRSPACE time stamp: 2009-04-21 16.38.38
BR0659I List menu 355 + please select one or more entries
-
List of indexes for rebuild
Pos. Owner Table Index Pt. Dg. Tablespace
1 - SAPPRD MKPF MKPF~0 NO 1 PSAPPRD
2 - SAPPRD MKPF MKPF~BUD NO 1 PSAPPRD
3 - SAPPRD MKPF MKPF~BVO NO 1 PSAPPRD
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your selection:
thanks
with best regrads
venkat