# su - oraep1
deliep101:oraep1 5> brtools
BR0651I BRTOOLS 7.20 (34)
BR0280I BRTOOLS time stamp: 2019-05-26 21.26.56
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: 2019-05-26 21.27.00
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2019-05-26 21.27.00
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:
1
BR0280I BRTOOLS time stamp: 2019-05-26 21.27.03
BR0663I Your choice: '1'
BR0280I BRTOOLS time stamp: 2019-05-26 21.27.03
BR0657I Input menu 81 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension
1 - BRSPACE profile (profile) ...... [initEP1.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 initEP1.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: 2019-05-26 21.27.29
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initEP1.sap -s 20 -l E -f tsextend'
BR0280I BRTOOLS time stamp: 2019-05-26 21.27.29
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2019-05-26 21.27.30
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.20 (34)
BR1002I Start of BRSPACE processing: sfbfhnli.tse 2019-05-26 21.27.30
BR0484I BRSPACE log file: /oracle/EP1/sapreorg/sfbfhnli.tse
BR0280I BRSPACE time stamp: 2019-05-26 21.27.31
BR1009I Name of database instance: EP1
BR1010I BRSPACE action ID: sfbfhnli
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend
BR0280I BRSPACE time stamp: 2019-05-26 21.27.31
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:
2
BR0280I BRSPACE time stamp: 2019-05-26 21.27.37
BR0663I Your choice: '2'
BR0280I BRSPACE time stamp: 2019-05-26 21.27.38
BR0659I List menu 259 + you can select one or more entries
-------------------------------------------------------------------------------
List of database tablespaces
Pos. Tablespace Type Status ExtMan. SegMan. Back. BigFi. Files/AuEx. Compr. Encr.
Total[KB] Used[%] Free[KB] MaxSize[KB] ExtSize[KB] FreeExt. Largest[KB]
1 - PSAPSR3 DATA ONLINE LOCAL AUTO NO NO 401/401 NO NO
8491171840 94.35 479754944 10330365936 1715556336 165 23068656+:9994240+:9994240+:9994240+:9994240+
2 - PSAPSR3731 DATA ONLINE LOCAL AUTO NO NO 15/15 NO NO
67737600 87.92 8181376 163840000 96102400 12 10240000+:7014400+:6184960+:6184960+:6184960+
3 - PSAPSR3SLT DATA ONLINE LOCAL AUTO NO NO 2/2 NO NO
13598720 12.55 11891712 20480000 6881280 5 3440640+:3440640+:3213312:3207168:2735104
4 - PSAPSR3USR DATA ONLINE LOCAL AUTO NO NO 24/24 NO NO
421969920 90.38 40582208 583680000 161710080 16 10240000+:10240000+:10240000+:10240000+:10240000+
5 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO NO 5/5 NO NO
92160000 0.00 92155904 92160000 0 0 0:0:0:0:0
6 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO NO 2/2 NO NO
35840000 0.01 35836928 35840000 0 4230 3964928:3714048:3390464:3227648:3126272
7 - SYSAUX DATA ONLINE LOCAL AUTO NO NO 1/1 NO NO
2457600 82.12 439424 10240000 7782400 12 7782400+:198912:129408:62464:21504
8 - SYSTEM DATA ONLINE LOCAL MANUAL NO NO 1/1 NO NO
2048000 60.77 803456 10240000 8192000 2 8192000+:802816:640:0:0
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your selection:
b
BR0280I BRSPACE time stamp: 2019-05-26 21.27.55
BR0663I Your selection: 'b'
BR0673I Going back to the previous menu...
BR0280I BRSPACE time stamp: 2019-05-26 21.27.55
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: 2019-05-26 21.28.01
BR0663I Your choice: '1'
BR0280I BRSPACE time stamp: 2019-05-26 21.28.01
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 401/401 8491171840 94.35 479754944 10330365936
2 - PSAPSR3731 15/15 67737600 87.92 8181376 163840000
3 - PSAPSR3SLT 2/2 13598720 12.55 11891712 20480000
4 - PSAPSR3USR 24/24 421969920 90.38 40582208 583680000
5 - PSAPTEMP 5/5 92160000 0.00 92155904 92160000
6 - PSAPUNDO 2/2 35840000 0.01 35836928 35840000
7 - SYSAUX 1/1 2457600 82.12 439424 10240000
8 - SYSTEM 1/1 2048000 60.77 803456 10240000
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your selection:
1
BR0280I BRSPACE time stamp: 2019-05-26 21.28.06
BR0663I Your selection: '1'
BR0280I BRSPACE time stamp: 2019-05-26 21.28.06
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)
1 * Last added file name (lastfile) ....... [/oracle/EP1/sapdata17/sr3_401/sr3.data401]
2 * Last added file size in MB (lastsize) . [25000]
3 - New file to be added (file) ........... [/oracle/EP1/sapdata17/sr3_402/sr3.data402]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [25000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [30000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/EP1/sapdata17/sr3_402/sr3.data402' size 25000M autoextend on next 20M maxsize 30000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2019-05-26 21.30.44
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1091I Next data file can be specified now
BR0280I BRSPACE time stamp: 2019-05-26 21.30.44
BR0675I This is a optional action - do you want to execute it now?
BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
y
BR0280I BRSPACE time stamp: 2019-05-26 21.30.49
BR0257I Your reply: 'y'
BR0677I The action will be executed...
BR0280I BRSPACE time stamp: 2019-05-26 21.30.49
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (2. file)
1 * Last added file name (lastfile) ....... [/oracle/EP1/sapdata17/sr3_401/sr3.data401]
2 * Last added file size in MB (lastsize) . [25000]
3 - New file to be added (file) ........... [/oracle/EP1/sapdata17/sr3_403/sr3.data403]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [25000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [30000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/EP1/sapdata17/sr3_402/sr3.data402' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata17/sr3_403/sr3.data403' size 25000M autoextend on next 20M maxsize 30000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2019-05-26 21.30.56
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1091I Next data file can be specified now
BR0280I BRSPACE time stamp: 2019-05-26 21.30.56
BR0675I This is a optional action - do you want to execute it now?
BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
y
BR0280I BRSPACE time stamp: 2019-05-26 21.31.00
BR0257I Your reply: 'y'
BR0677I The action will be executed...
BR0280I BRSPACE time stamp: 2019-05-26 21.31.00
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (3. file)
1 * Last added file name (lastfile) ....... [/oracle/EP1/sapdata17/sr3_401/sr3.data401]
2 * Last added file size in MB (lastsize) . [25000]
3 - New file to be added (file) ........... [/oracle/EP1/sapdata17/sr3_404/sr3.data404]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [25000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [30000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/EP1/sapdata17/sr3_402/sr3.data402' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata17/sr3_403/sr3.data403' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata17/sr3_404/sr3.data404' size 25000M autoextend on next 20M maxsize 30000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2019-05-26 21.31.15
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1091I Next data file can be specified now
BR0280I BRSPACE time stamp: 2019-05-26 21.31.15
BR0675I This is a optional action - do you want to execute it now?
BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
y
BR0280I BRSPACE time stamp: 2019-05-26 21.31.28
BR0257I Your reply: 'y'
BR0677I The action will be executed...
BR0280I BRSPACE time stamp: 2019-05-26 21.31.28
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (4. file)
1 * Last added file name (lastfile) ....... [/oracle/EP1/sapdata17/sr3_401/sr3.data401]
2 * Last added file size in MB (lastsize) . [25000]
3 - New file to be added (file) ........... [/oracle/EP1/sapdata17/sr3_405/sr3.data405]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [25000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [30000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/EP1/sapdata17/sr3_402/sr3.data402' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata17/sr3_403/sr3.data403' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata17/sr3_404/sr3.data404' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata17/sr3_405/sr3.data405' size 25000M autoextend on next 20M maxsize 30000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2019-05-26 21.31.32
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1091I Next data file can be specified now
BR0280I BRSPACE time stamp: 2019-05-26 21.31.32
BR0675I This is a optional action - do you want to execute it now?
BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2019-05-26 21.31.44
BR0257I Your reply: 'c'
BR0678I The action will be skipped...
BR0259I Program execution will be continued...
BR0370I Directory /oracle/EP1/sapreorg/sfbfhnli created
BR0280I BRSPACE time stamp: 2019-05-26 21.31.45
BR0319I Control file copy created: /oracle/EP1/sapreorg/sfbfhnli/cntrlEP1.old 102645760
BR0370I Directory /oracle/EP1/sapdata17/sr3_402 created
BR0370I Directory /oracle/EP1/sapdata17/sr3_403 created
BR0370I Directory /oracle/EP1/sapdata17/sr3_404 created
BR0370I Directory /oracle/EP1/sapdata17/sr3_405 created
BR0280I BRSPACE time stamp: 2019-05-26 21.31.45
BR1088I Extending tablespace PSAPSR3 ...
BR0280I BRSPACE time stamp: 2019-05-26 21.39.20
BR1016I SQL statement 'alter tablespace PSAPSR3 add datafile '/oracle/EP1/sapdata17/sr3_402/sr3.data402' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata17/sr3_403/sr3.data403' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata17/sr3_404/sr3.data404' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata17/sr3_405/sr3.data405' size 25000M autoextend on next 20M maxsize 30000M' executed successfully
BR1051I Tablespace PSAPSR3 extended successfully with files:
/oracle/EP1/sapdata17/sr3_402/sr3.data402 25000M,
/oracle/EP1/sapdata17/sr3_403/sr3.data403 25000M,
/oracle/EP1/sapdata17/sr3_404/sr3.data404 25000M,
/oracle/EP1/sapdata17/sr3_405/sr3.data405 25000M
BR0280I BRSPACE time stamp: 2019-05-26 21.39.20
BR0340I Switching to the next online redolog file for database instance EP1 ...
BR0321I Switch to the next online redolog file for database instance EP1 successful
BR0280I BRSPACE time stamp: 2019-05-26 21.39.22
BR0319I Control file copy created: /oracle/EP1/sapreorg/sfbfhnli/cntrlEP1.new 102645760
BR0280I BRSPACE time stamp: 2019-05-26 21.39.22
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRSPACE:
c
BR0280I BRSPACE time stamp: 2019-05-26 21.40.48
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2019-05-26 21.40.48
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:
2
BR0280I BRSPACE time stamp: 2019-05-26 21.41.02
BR0663I Your choice: '2'
BR0280I BRSPACE time stamp: 2019-05-26 21.41.03
BR0659I List menu 259 + you can select one or more entries
-------------------------------------------------------------------------------
List of database tablespaces
Pos. Tablespace Type Status ExtMan. SegMan. Back. BigFi. Files/AuEx. Compr. Encr.
Total[KB] Used[%] Free[KB] MaxSize[KB] ExtSize[KB] FreeExt. Largest[KB]
1 - PSAPSR3 DATA ONLINE LOCAL AUTO NO NO 405/405 NO NO
8593571840 93.23 582150848 10453245936 1736036336 193 23068656+:9994240+:9994240+:9994240+:9994240+
2 - PSAPSR3731 DATA ONLINE LOCAL AUTO NO NO 15/15 NO NO
67737600 87.92 8181376 163840000 96102400 12 10240000+:7014400+:6184960+:6184960+:6184960+
3 - PSAPSR3SLT DATA ONLINE LOCAL AUTO NO NO 2/2 NO NO
13598720 12.55 11891712 20480000 6881280 5 3440640+:3440640+:3213312:3207168:2735104
4 - PSAPSR3USR DATA ONLINE LOCAL AUTO NO NO 24/24 NO NO
421969920 90.38 40582208 583680000 161710080 16 10240000+:10240000+:10240000+:10240000+:10240000+
5 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO NO 5/5 NO NO
92160000 0.00 92155904 92160000 0 0 0:0:0:0:0
6 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO NO 2/2 NO NO
35840000 0.01 35837952 35840000 0 4212 3964928:3714048:3390464:3227648:3126272
7 - SYSAUX DATA ONLINE LOCAL AUTO NO NO 1/1 NO NO
2457600 82.12 439424 10240000 7782400 12 7782400+:198912:129408:62464:21504
8 - SYSTEM DATA ONLINE LOCAL MANUAL NO NO 1/1 NO NO
2048000 60.77 803456 10240000 8192000 2 8192000+:802816:640:0:0
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your selection:
至此扩充完成，可以同时扩充5个文件。
# df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 20.00 19.18 5% 11758 1% /
/dev/hd2 15.00 9.63 36% 69005 3% /usr
/dev/hd9var 2.00 1.31 35% 13200 5% /var
/dev/hd3 10.00 1.88 82% 4652 2% /tmp
/dev/hd1 5.00 4.98 1% 182 1% /home
/dev/hd11admin 0.50 0.50 1% 5 1% /admin
/proc - - - - - /proc
/dev/hd10opt 2.00 1.72 15% 10635 3% /opt
/dev/livedump 0.50 0.50 1% 8 1% /var/adm/ras/livedump
/dev/fslv00 88.00 38.51 57% 54261 1% /usr/sap/EP1
/dev/EP1backup 32765.00 4368.22 87% 10934 1% /EP1backup
192.168.112.62:/uploadexcel 299.00 259.18 14% 12109 1% /uploadexcel
/dev/EP1export 20.00 9.94 51% 50074 3% /export/sapmnt/EP1
/dev/EP1trans 40.00 6.88 83% 139476 9% /export/usr/sap/trans
/dev/EP1oracle 30.00 6.12 80% 15080 2% /oracle
/dev/EP1oracleep1 40.00 13.14 68% 64683 3% /oracle/EP1
/dev/EP1oramirA 8.00 5.00 38% 6 1% /oracle/EP1/mirrlogA
/dev/EP1oramirB 8.00 5.00 38% 6 1% /oracle/EP1/mirrlogB
/dev/EP1logarchive 440.00 437.97 1% 8 1% /oracle/EP1/oraarch
/dev/EP1oralogA 8.00 4.86 40% 9 1% /oracle/EP1/origlogA
/dev/EP1oralogB 8.00 4.90 39% 8 1% /oracle/EP1/origlogB
/dev/EP1sapdata1 400.00 262.62 35% 281 1% /oracle/EP1/sapdata1
/dev/EP1sapdata10 1024.00 252.35 76% 86 1% /oracle/EP1/sapdata10
/dev/EP1sapdata11 1024.00 291.41 72% 64 1% /oracle/EP1/sapdata11
/dev/EP1sapdata12 1024.00 291.41 72% 64 1% /oracle/EP1/sapdata12
/dev/EP1sapdata13 1024.00 266.99 74% 66 1% /oracle/EP1/sapdata13
/dev/EP1sapdata14 1024.00 291.41 72% 64 1% /oracle/EP1/sapdata14
/dev/EP1sapdata15 1024.00 242.58 77% 68 1% /oracle/EP1/sapdata15
/dev/EP1sapdata16 1024.00 266.99 74% 66 1% /oracle/EP1/sapdata16
/dev/EP1sapdata2 400.00 72.28 82% 61 1% /oracle/EP1/sapdata2
/dev/EP1sapdata3 400.00 218.15 46% 46 1% /oracle/EP1/sapdata3
/dev/EP1sapdata4 400.00 101.73 75% 44 1% /oracle/EP1/sapdata4
/dev/EP1sapdata5 400.00 77.43 81% 38 1% /oracle/EP1/sapdata5
/dev/EP1sapdata6 400.00 83.63 80% 32930 1% /oracle/EP1/sapdata6
/dev/EP1sapdata7 599.00 81.32 87% 72 1% /oracle/EP1/sapdata7
/dev/EP1sapdata8 597.50 128.65 79% 68 1% /oracle/EP1/sapdata8
/dev/EP1sapdata9 600.00 131.15 79% 68 1% /oracle/EP1/sapdata9
vep1db:/export/sapmnt/EP1 20.00 9.94 51% 50074 3% /sapmnt/EP1
vep1db:/export/usr/sap/trans 40.00 6.88 83% 139476 9% /usr/sap/trans
/dev/EP1sapdata17 1024.00 96.09 91% 80 1% /oracle/EP1/sapdata17 留80% 不然会告警
/dev/EP1sapdata18 1024.00 1023.84 1% 4 1% /oracle/EP1/sapdata18
/dev/EP1sapdata20 1024.00 1023.84 1% 4 1% /oracle/EP1/sapdata20
/dev/EP1sapdata19 1024.00 1023.84 1% 4 1% /oracle/EP1/sapdata19
192.168.99.156:/idoc 1535.87 1531.68 1% 1098060 1% /idoc
=================================换盘============================================
# su - oraep1
deliep101:oraep1 1> brtools
BR0651I BRTOOLS 7.20 (34)
BR0280I BRTOOLS time stamp: 2019-06-09 21.55.05
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: 2019-06-09 21.55.09
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2019-06-09 21.55.09
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:
1
BR0280I BRTOOLS time stamp: 2019-06-09 21.55.12
BR0663I Your choice: '1'
BR0280I BRTOOLS time stamp: 2019-06-09 21.55.12
BR0657I Input menu 81 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension
1 - BRSPACE profile (profile) ...... [initEP1.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 initEP1.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: 2019-06-09 21.55.13
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initEP1.sap -s 20 -l E -f tsextend'
BR0280I BRTOOLS time stamp: 2019-06-09 21.55.13
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2019-06-09 21.55.14
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.20 (34)
BR1002I Start of BRSPACE processing: sfbhylgk.tse 2019-06-09 21.55.14
BR0484I BRSPACE log file: /oracle/EP1/sapreorg/sfbhylgk.tse
BR0280I BRSPACE time stamp: 2019-06-09 21.55.16
BR1009I Name of database instance: EP1
BR1010I BRSPACE action ID: sfbhylgk
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend
BR0280I BRSPACE time stamp: 2019-06-09 21.55.16
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: 2019-06-09 21.55.19
BR0663I Your choice: '1'
BR0280I BRSPACE time stamp: 2019-06-09 21.55.21
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 415/415 8849571840 91.89 717656448 10760445936
2 - PSAPSR3731 15/15 67737600 87.93 8173184 163840000
3 - PSAPSR3SLT 2/2 13598720 12.58 11888640 20480000
4 - PSAPSR3USR 24/24 421969920 92.99 29581056 583680000
5 - PSAPTEMP 5/5 92160000 0.00 92160000 92160000
6 - PSAPUNDO 2/2 35840000 0.01 35837952 35840000
7 - SYSAUX 1/1 2498560 86.47 337984 10240000
8 - SYSTEM 1/1 5898240 21.10 4653696 10240000
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your selection:
1
BR0280I BRSPACE time stamp: 2019-06-09 21.55.42
BR0663I Your selection: '1'
BR0280I BRSPACE time stamp: 2019-06-09 21.55.42
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)
1 * Last added file name (lastfile) ....... [/oracle/EP1/sapdata17/sr3_415/sr3.data415]
2 * Last added file size in MB (lastsize) . [25000]
3 - New file to be added (file) ........... [/oracle/EP1/sapdata17/sr3_416/sr3.data416]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [25000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [30000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/EP1/sapdata17/sr3_416/sr3.data416' size 25000M autoextend on next 20M maxsize 30000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRSPACE time stamp: 2019-06-09 21.55.51
BR0663I Your choice: '3'
BR0681I Enter string value for "file" (<file>|<sapdata>|<N>) [/oracle/EP1/sapdata17/sr3_416/sr3.data416]:
/oracle/EP1/sapdata18/sr3_416/sr3.data416
BR0280I BRSPACE time stamp: 2019-06-09 22.08.12
BR0683I New value for "file": '/oracle/EP1/sapdata18/sr3_416/sr3.data416'
BR0280I BRSPACE time stamp: 2019-06-09 22.08.12
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)
1 * Last added file name (lastfile) ....... [/oracle/EP1/sapdata17/sr3_415/sr3.data415]
2 * Last added file size in MB (lastsize) . [25000]
3 - New file to be added (file) ........... [/oracle/EP1/sapdata18/sr3_416/sr3.data416]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [25000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [30000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/EP1/sapdata18/sr3_416/sr3.data416' size 25000M autoextend on next 20M maxsize 30000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2019-06-09 22.08.34
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1091I Next data file can be specified now
BR0280I BRSPACE time stamp: 2019-06-09 22.08.34
BR0675I This is a optional action - do you want to execute it now?
BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
y
BR0280I BRSPACE time stamp: 2019-06-09 22.08.36
BR0257I Your reply: 'y'
BR0677I The action will be executed...
BR0280I BRSPACE time stamp: 2019-06-09 22.08.36
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (2. file)
1 * Last added file name (lastfile) ....... [/oracle/EP1/sapdata17/sr3_415/sr3.data415]
2 * Last added file size in MB (lastsize) . [25000]
3 - New file to be added (file) ........... [/oracle/EP1/sapdata18/sr3_417/sr3.data417]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [25000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [30000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/EP1/sapdata18/sr3_416/sr3.data416' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata18/sr3_417/sr3.data417' size 25000M autoextend on next 20M maxsize 30000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2019-06-09 22.08.40
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1091I Next data file can be specified now
BR0280I BRSPACE time stamp: 2019-06-09 22.08.40
BR0675I This is a optional action - do you want to execute it now?
BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
y
BR0280I BRSPACE time stamp: 2019-06-09 22.09.50
BR0257I Your reply: 'y'
BR0677I The action will be executed...
BR0280I BRSPACE time stamp: 2019-06-09 22.09.50
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (3. file)
1 * Last added file name (lastfile) ....... [/oracle/EP1/sapdata17/sr3_415/sr3.data415]
2 * Last added file size in MB (lastsize) . [25000]
3 - New file to be added (file) ........... [/oracle/EP1/sapdata18/sr3_418/sr3.data418]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [25000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [30000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/EP1/sapdata18/sr3_416/sr3.data416' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata18/sr3_417/sr3.data417' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata18/sr3_418/sr3.data418' size 25000M autoextend on next 20M maxsize 30000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2019-06-09 22.09.57
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1091I Next data file can be specified now
BR0280I BRSPACE time stamp: 2019-06-09 22.09.57
BR0675I This is a optional action - do you want to execute it now?
BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
y
BR0280I BRSPACE time stamp: 2019-06-09 22.09.59
BR0257I Your reply: 'y'
BR0677I The action will be executed...
BR0280I BRSPACE time stamp: 2019-06-09 22.09.59
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (4. file)
1 * Last added file name (lastfile) ....... [/oracle/EP1/sapdata17/sr3_415/sr3.data415]
2 * Last added file size in MB (lastsize) . [25000]
3 - New file to be added (file) ........... [/oracle/EP1/sapdata18/sr3_419/sr3.data419]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [25000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [30000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/EP1/sapdata18/sr3_416/sr3.data416' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata18/sr3_417/sr3.data417' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata18/sr3_418/sr3.data418' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata18/sr3_419/sr3.data419' size 25000M autoextend on next 20M maxsize 30000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2019-06-09 22.10.03
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1091I Next data file can be specified now
BR0280I BRSPACE time stamp: 2019-06-09 22.10.03
BR0675I This is a optional action - do you want to execute it now?
BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
y
BR0280I BRSPACE time stamp: 2019-06-09 22.10.05
BR0257I Your reply: 'y'
BR0677I The action will be executed...
BR0280I BRSPACE time stamp: 2019-06-09 22.10.05
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (5. file)
1 * Last added file name (lastfile) ....... [/oracle/EP1/sapdata17/sr3_415/sr3.data415]
2 * Last added file size in MB (lastsize) . [25000]
3 - New file to be added (file) ........... [/oracle/EP1/sapdata18/sr3_420/sr3.data420]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [25000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [30000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/EP1/sapdata18/sr3_416/sr3.data416' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata18/sr3_417/sr3.data417' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata18/sr3_418/sr3.data418' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata18/sr3_419/sr3.data419' size 25000M autoextend on next 20M maxsize 30000M, '/oracle/EP1/sapdata18/sr3_420/sr3.data420' size 25000M autoextend on next 20M maxsize 30000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2019-06-09 22.10.11
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0370I Directory /oracle/EP1/sapreorg/sfbhylgk created
BR0280I BRSPACE time stamp: 2019-06-09 22.10.13
BR0319I Control file copy created: /oracle/EP1/sapreorg/sfbhylgk/cntrlEP1.old 102645760
BR0370I Directory /oracle/EP1/sapdata18/sr3_416 created
BR0370I Directory /oracle/EP1/sapdata18/sr3_417 created
BR0370I Directory /oracle/EP1/sapdata18/sr3_418 created
BR0370I Directory /oracle/EP1/sapdata18/sr3_419 created
BR0370I Directory /oracle/EP1/sapdata18/sr3_420 created
BR0280I BRSPACE time stamp: 2019-06-09 22.10.13
BR1088I Extending tablespace PSAPSR3 ..
转载自原文链接, 如需删除请联系管理员。
原文链接：Oracle-brtools 扩展表空间，转载请注明来源！