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:
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:
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/223653/viewspace-1352214/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle表空間擴容Oracle
- oracle UNDO表空間一個bug——undo表空間快速擴充套件Oracle套件
- Oracle RAC+DG 表空間擴容Oracle
- 擴充套件表空間套件
- Oracle表空間Oracle
- Oracle 擴充磁碟空間Oracle
- 華納雲：如何配置oracle表空間自動擴容？Oracle
- Oracle 10g 物理DataGuard擴充套件表空間Oracle 10g套件
- oracle temp 表空間Oracle
- 增加oracle表空間Oracle
- oracle undo 表空間Oracle
- oracle users 表空間Oracle
- Oracle表空間管理Oracle
- oracle建立表空間Oracle
- Oracle 表空間管理Oracle
- oracle表空間操作Oracle
- ORACLE MOVE表空間Oracle
- ORACLE表空間概述Oracle
- Oracle表空間命令Oracle
- Oracle 表空間回收Oracle
- oracle RAC+DG 擴容ASM和表空間(Linux)OracleASMLinux
- Oracle表移動表空間Oracle
- oracle 表移動表空間Oracle
- oracle表空間的整理Oracle
- Oracle 批量建表空間Oracle
- Oracle清理SYSAUX表空間OracleUX
- Oracle undo 表空間管理Oracle
- oracle表空間查詢Oracle
- Oracle 表空間傳輸Oracle
- oracle重建UNDO表空間Oracle
- oracle 臨時表空間Oracle
- Oracle各種表空間Oracle
- Oracle 表空間的管理Oracle
- oracle表空間傳輸Oracle
- Oracle傳輸表空間Oracle
- oracle 系統表空間Oracle
- oracle臨時表空間Oracle
- oracle undo表空間管理Oracle