Skip to Content
0
Former Member
Apr 21, 2009 at 11:30 AM

rebuild the index

326 Views

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