Brtools扩oracle表空间-优快云博客

本文详细记录了使用BRTOOLS工具扩展Oracle数据库表空间的过程。通过BRTOOLS的交互式菜单，逐步展示了如何选择要扩展的表空间、指定新的数据文件路径及大小，并最终执行表空间扩展操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<hostname>[/]#su - ora<sid></sid> hostname:ora<sid>> 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" (<file>|<sapdata>|<n>) [/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" (<file>|<sapdata>|<n>) [/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: <div class="zemanta-pixie"><img class="zemanta-pixie-img" alt="" src="http://img.zemanta.com/pixy.gif?x-id=6a64b4bb-773b-8e34-8983-2d1fba8a22f7"></div></n></sapdata></file></n></sapdata></file></sid></hostname>