[/]# su - ora
hostname:ora> brtools
BR0651I BRTOOLS 7.00 (32)
BR0280I BRTOOLS time stamp: 2010-01-06 15.55.14
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:
2
BR0280I BRTOOLS time stamp: 2010-01-06 15.55.18
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2010-01-06 15.55.18
BR0656I Choice menu 5 - please make a selection
-------------------------------------------------------------------------------
Database space management

1=Extend tablespace
2 - Create tablespace
3 - Drop tablespace
4 - Alter tablespace
5 - Alter data file
6 - Move data file
7 - Additional space functions
8 - Reset program status

Standard keys: c - cont,h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2010-01-06 15.55.28
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2010-01-06 15.55.28
BR0657I Input menu 81 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension

1 - BRSPACE profile (profile) ...... [initPRD.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... []
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initPRD.sap -s 20 -l E -f tsextend]

Standard keys: c - cont,h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2010-01-06 15.55.30
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initPRD.sap -s 20 -l E -f tsextend'

BR0280I BRTOOLS time stamp: 2010-01-06 15.55.30
BR0670I Enter 'c[ont]' to continue,'b[ack]' to go back,'s[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2010-01-06 15.55.31
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 7.00 (32)
BR1002I Start of BRSPACE processing: sechhywp.tse 2010-01-06 15.55.31
BR0484I BRSPACE log file: /oracle/PRD/sapreorg/sechhywp.tse

BR0280I BRSPACE time stamp: 2010-01-06 15.55.32
BR1009I Name of database instance: PRD
BR1010I BRSPACE action ID: sechhywp
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend

BR0280I BRSPACE time stamp: 2010-01-06 15.55.32
BR0656I Choice menu 301 - please make a selection
-------------------------------------------------------------------------------
Tablespace extension main menu

1 = Extend tablespace
2 - Show tablespaces
3 - Show data files
4 - Show disk volumes
5 * Exit program
6 - Reset program status

Standard keys: c - cont,h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2010-01-06 15.55.56
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2010-01-06 15.55.57
BR0658I List menu 302 - please select one entry
-------------------------------------------------------------------------------
List of tablespaces for extension

Pos. Tablespace Files/AuExt. Total[KB] Used[%] Free[KB] MaxSize[KB]

1 - PSAPSR3 11/4 112640000 71.57 32018688 112640000
2 - PSAPSR3700 12/4 122880000 64.78 43272448 122880000
3 - PSAPSR3USR 1/1 8765440 27.63 6343744 10240000
4 - PSAPTEMP 2/1 12288000 0.00 12288000 20480000
5 - PSAPUNDO 3/1 28692480 0.00 28692288 30720000
6 - SYSAUX 2/2 2600960 22.41 2017984 20480000
7 - SYSTEM 2/2 2928640 30.09 2047424 20480000

Standard keys: c - cont,h - help
-------------------------------------------------------------------------------
BR0662I Enter your selection:
1
BR0280I BRSPACE time stamp: 2010-01-06 16.00.05
BR0663I Your selection: '1'

BR0280I BRSPACE time stamp: 2010-01-06 16.00.05
BR0657I Input menu 303 - please check/enter input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [/oracle/PRD/sapdata3/sr3_11/sr3.data11]
2 * Last added file size in MB (lastsize) . [10000]
3 - New file to be added (file) ........... [/oracle/PRD/sapdata3/sr3_12/sr3.data12]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [10000]
6 - File autoextend mode (autoextend) ..... [no]
7 # Maximum file size in MB (maxsize) ..... []
8 # File increment size in MB (incrsize) .. []
9 - sql command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/PRD/sapdata3/sr3_12/sr3.data12' size 10000M autoextend off]

Standard keys: c - cont,h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRSPACE time stamp: 2010-01-06 16.01.35
BR0663I Your choice: '3'

BR0280I BRSPACE time stamp: 2010-01-06 16.01.35
BR0681I Enter string value for "file" (||) [/oracle/PRD/sapdata3/sr3_12/sr3.data12]:
/oracle/PRD/sapdata4/sr3_12/sr3.data12
BR0280I BRSPACE time stamp: 2010-01-06 16.01.48
BR0683I New value for "file": '/oracle/PRD/sapdata4/sr3_12/sr3.data12'

BR0280I BRSPACE time stamp: 2010-01-06 16.01.48
BR0657I Input menu 303 - please check/enter input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [/oracle/PRD/sapdata3/sr3_11/sr3.data11]
2 * Last added file size in MB (lastsize) . [10000]
3 - New file to be added (file) ........... [/oracle/PRD/sapdata4/sr3_12/sr3.data12]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [10000]
6 - File autoextend mode (autoextend) ..... [no]
7 # Maximum file size in MB (maxsize) ..... []
8 # File increment size in MB (incrsize) .. []
9 - sql command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/PRD/sapdata4/sr3_12/sr3.data12' size 10000M autoextend off]

Standard keys: c - cont,h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2010-01-06 16.02.00
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2010-01-06 16.02.00
BR1091I Next data file can be specified now

BR0675I Do you want to perform this action?
BR0676I Enter 'y[es]'to perform the action,'n[o]/c[ont]' to skip it,'s[top]' to abort:
y BR0280I BRSPACE time stamp: 2010-01-06 16.02.37 BR0257I Your reply: 'y' BR0677I The action will be performed... BR0280I BRSPACE time stamp: 2010-01-06 16.02.37 BR0657I Input menu 303 - please check/enter input values ------------------------------------------------------------------------------- Options for extension of tablespace PSAPSR3 (2. file) 1 * Last added file name (lastfile) ....... [/oracle/PRD/sapdata3/sr3_11/sr3.data11] 2 * Last added file size in MB (lastsize) . [10000] 3 - New file to be added (file) ........... [/oracle/PRD/sapdata4/sr3_13/sr3.data13] 4 ~ Raw disk / link target (rawlink) ...... [] 5 - Size of the new file in MB (size) ..... [10000] 6 - File autoextend mode (autoextend) ..... [no] 7 # Maximum file size in MB (maxsize) ..... [] 8 # File increment size in MB (incrsize) .. [] 9 - sql command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/PRD/sapdata4/sr3_12/sr3.data12' size 10000M autoextend off,'/oracle/PRD/sapdata4/sr3_13/sr3.data13' size 10000M autoextend off] Standard keys: c - cont,h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: 3 BR0280I BRSPACE time stamp: 2010-01-06 16.02.57 BR0663I Your choice: '3' BR0280I BRSPACE time stamp: 2010-01-06 16.02.57 BR0681I Enter string value for "file" (||) [/oracle/PRD/sapdata4/sr3_13/sr3.data13]: /oracle/PRD/sapdata5/sr3_13/sr3.data13 BR0280I BRSPACE time stamp: 2010-01-06 16.03.07 BR0683I New value for "file": '/oracle/PRD/sapdata5/sr3_13/sr3.data13' BR0280I BRSPACE time stamp: 2010-01-06 16.03.07 BR0657I Input menu 303 - please check/enter input values ------------------------------------------------------------------------------- Options for extension of tablespace PSAPSR3 (2. file) 1 * Last added file name (lastfile) ....... [/oracle/PRD/sapdata3/sr3_11/sr3.data11] 2 * Last added file size in MB (lastsize) . [10000] 3 - New file to be added (file) ........... [/oracle/PRD/sapdata5/sr3_13/sr3.data13] 4 ~ Raw disk / link target (rawlink) ...... [] 5 - Size of the new file in MB (size) ..... [10000] 6 - File autoextend mode (autoextend) ..... [no] 7 # Maximum file size in MB (maxsize) ..... [] 8 # File increment size in MB (incrsize) .. [] 9 - sql command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/PRD/sapdata4/sr3_12/sr3.data12' size 10000M autoextend off,'/oracle/PRD/sapdata5/sr3_13/sr3.data13' size 10000M autoextend off] Standard keys: c - cont,h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: c BR0280I BRSPACE time stamp: 2010-01-06 16.03.27 BR0663I Your choice: 'c' BR0259I Program execution will be continued... BR0280I BRSPACE time stamp: 2010-01-06 16.03.27 BR1091I Next data file can be specified now BR0675I Do you want to perform this action? BR0676I Enter 'y[es]' to perform the action,'s[top]' to abort: c BR0280I BRSPACE time stamp: 2010-01-06 16.03.31 BR0257I Your reply: 'c' BR0678I The action will be skipped... BR0259I Program execution will be continued... BR0280I BRSPACE time stamp: 2010-01-06 16.03.31 BR0370I Directory /oracle/PRD/sapreorg/sechhywp created BR0280I BRSPACE time stamp: 2010-01-06 16.03.32 BR0319I Control file copy created: /oracle/PRD/sapreorg/sechhywp/cntrlPRD.old 24461312 BR0280I BRSPACE time stamp: 2010-01-06 16.03.32 BR0370I Directory /oracle/PRD/sapdata4/sr3_12 created BR0370I Directory /oracle/PRD/sapdata5/sr3_13 created BR0280I BRSPACE time stamp: 2010-01-06 16.03.32 BR1088I Extending tablespace PSAPSR3... BR0280I BRSPACE time stamp: 2010-01-06 16.05.57 BR1016I sql statement 'alter tablespace PSAPSR3 add datafile '/oracle/PRD/sapdata4/sr3_12/sr3.data12' size 10000M autoextend off,'/oracle/PRD/sapdata5/sr3_13/sr3.data13' size 10000M autoextend off' executed successfully BR1051I Tablespace PSAPSR3 extended successfully with files: /oracle/PRD/sapdata4/sr3_12/sr3.data12 10000M,/oracle/PRD/sapdata5/sr3_13/sr3.data13 10000M BR0280I BRSPACE time stamp: 2010-01-06 16.05.57 BR0340I Switching to next online redo log file for database instance PRD ... BR0321I Switch to next online redo log file for database instance PRD successful BR0280I BRSPACE time stamp: 2010-01-06 16.06.00 BR0319I Control file copy created: /oracle/PRD/sapreorg/sechhywp/cntrlPRD.new 24461312 BR0280I BRSPACE time stamp: 2010-01-06 16.06.00 BR0256I Enter 'c[ont]' to continue,'s[top]' to cancel BRSPACE: c BR0280I BRSPACE time stamp: 2010-01-06 16.06.05 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRSPACE time stamp: 2010-01-06 16.06.05 BR0656I Choice menu 301 - please make a selection ------------------------------------------------------------------------------- Tablespace extension main menu 1 + Extend tablespace 2 - Show tablespaces 3 - Show data files 4 - Show disk volumes 5 = Exit program 6 - Reset program status Standard keys: c - cont,h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: 1 BR0280I BRSPACE time stamp: 2010-01-06 16.06.14 BR0663I Your choice: '1' BR0280I BRSPACE time stamp: 2010-01-06 16.06.14 BR0658I List menu 302 - please select one entry ------------------------------------------------------------------------------- List of tablespaces for extension Pos. Tablespace Files/AuExt. Total[KB] Used[%] Free[KB] MaxSize[KB] 1 - PSAPSR3 13/4 133120000 60.56 52498560 133120000 2 - PSAPSR3700 12/4 122880000 64.78 43272448 122880000 3 - PSAPSR3USR 1/1 8765440 27.63 6343744 10240000 4 - PSAPTEMP 2/1 12288000 0.00 12288000 20480000 5 - PSAPUNDO 3/1 28692480 0.00 28692288 30720000 6 - SYSAUX 2/2 2600960 22.42 2017792 20480000 7 - SYSTEM 2/2 2928640 30.09 2047424 20480000 Standard keys: c - cont,h - help ------------------------------------------------------------------------------- BR0662I Enter your selection: