Brtools扩oracle表空间

[/]#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, b - back, s - stop, r - refr, 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, b - back, s - stop, r - refr, 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, b - back, s - stop, r - refr, 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, b - back, s - stop, r - refr, 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, b - back, s - stop, r - refr, 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, b - back, s - stop, r - refr, 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, b - back, s - stop, r - refr, 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, b - back, s - stop, r - refr, 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, 'n[o]/c[ont]' to skip it, '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, b - back, s - stop, r - refr, 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, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your selection: