Brtools扩oracle表空间

待我称王封你为后i 2022-09-25 01:26 210阅读 0赞

\[/\]\# 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:

![pixy.gif_x-id_6a64b4bb-773b-8e34-8983-2d1fba8a22f7][]

[pixy.gif_x-id_6a64b4bb-773b-8e34-8983-2d1fba8a22f7]: http://img.zemanta.com/pixy.gif?x-id=6a64b4bb-773b-8e34-8983-2d1fba8a22f7