1. 首页
  2. IT资讯

Brtools扩oracle表空间

[/]#su – ora
hostname:orabrtools
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

 = 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:

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/223653/viewspace-1352214/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:℅傍ㄖ免沦陷dε鬼,转转请注明出处:http://www.cxybcw.com/192114.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code