Here is the list of steps to follow to add data file in existing table space.
extending Tablespace size was differant in oracle SAP DB
SERVER_NAME:oraTEST 2> brtools
BR0651I BRTOOLS 7.00 (32)
BR0280I BRTOOLS time stamp: 2015-05-03 14.21.41
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: 2015-05-03 14.21.49
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2015-05-03 14.21.49
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: 2015-05-03 14.21.53
BR0663I Your choice: '1'
BR0280I BRTOOLS time stamp: 2015-05-03 14.21.53
BR0657I Input menu 81 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension
1 - BRSPACE profile (profile) ...... [initTEST.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 initTEST.sap -s 20 -l E -f tsextend]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2015-05-03 14.21.56
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2015-05-03 14.21.56
BR0681I Enter string value for "tablespace" []:
PSAPSR3DB
BR0280I BRTOOLS time stamp: 2015-05-03 14.22.11
BR0683I New value for "tablespace": 'PSAPSR3DB'
BR0280I BRTOOLS time stamp: 2015-05-03 14.22.11
BR0657I Input menu 81 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension
1 - BRSPACE profile (profile) ...... [initTEST.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPSR3DB]
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initTEST.sap -s 20 -l E -f tsextend -t PSAPSR3DB]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2015-05-03 14.22.15
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initTEST.sap -s 20 -l E -f tsextend -t PSAPSR3DB'
BR0280I BRTOOLS time stamp: 2015-05-03 14.22.15
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2015-05-03 14.22.19
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.00 (32)
BR1002I Start of BRSPACE processing: setbywqd.tse 2015-05-03 14.22.19
BR0484I BRSPACE log file: /oracle/TEST/sapreorg/setbywqd.tse
BR0280I BRSPACE time stamp: 2015-05-03 14.22.19
BR1009I Name of database instance: TEST
BR1010I BRSPACE action ID: setbywqd
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend
BR0280I BRSPACE time stamp: 2015-05-03 14.22.20
BR0657I Input menu 303 - please check/enter input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3DB (1. file)
1 * Last added file name (lastfile) ....... [/oracle/TEST/sapdata3/sr3db_3/sr3db.data3]
2 * Last added file size in MB (lastsize) . [1000]
3 - New file to be added (file) ........... [/oracle/TEST/sapdata3/sr3db_4/sr3db.data4]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [1000]
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 PSAPSR3DB add datafile '/oracle/TEST/sapdata3/sr3db_4/sr3db.data4' size 1000M autoextend off]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
5
BR0280I BRSPACE time stamp: 2015-05-03 14.22.51
BR0663I Your choice: '5'
BR0280I BRSPACE time stamp: 2015-05-03 14.22.51
BR0682I Enter integer value for "size" (1-32767) [1000]:
100
BR0280I BRSPACE time stamp: 2015-05-03 14.22.56
BR0683I New value for "size": '100'
BR0280I BRSPACE time stamp: 2015-05-03 14.22.56
BR0657I Input menu 303 - please check/enter input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3DB (1. file)
1 * Last added file name (lastfile) ....... [/oracle/TEST/sapdata3/sr3db_3/sr3db.data3]
2 * Last added file size in MB (lastsize) . [1000]
3 - New file to be added (file) ........... [/oracle/TEST/sapdata3/sr3db_4/sr3db.data4]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [100]
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 PSAPSR3DB add datafile '/oracle/TEST/sapdata3/sr3db_4/sr3db.data4' size 100M autoextend off]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2015-05-03 14.23.00
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2015-05-03 14.23.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:
n
BR0280I BRSPACE time stamp: 2015-05-03 14.23.08
BR0257I Your reply: 'n'
BR0678I The action will be skipped...
BR0280I BRSPACE time stamp: 2015-05-03 14.23.08
BR0370I Directory /oracle/TEST/sapreorg/setbywqd created
BR0280I BRSPACE time stamp: 2015-05-03 14.23.08
BR0319I Control file copy created: /oracle/TEST/sapreorg/setbywqd/cntrlTEST.old 16302080
BR0280I BRSPACE time stamp: 2015-05-03 14.23.08
BR0370I Directory /oracle/TEST/sapdata3/sr3db_4 created
BR0280I BRSPACE time stamp: 2015-05-03 14.23.08
BR1088I Extending tablespace PSAPSR3DB...
BR0280I BRSPACE time stamp: 2015-05-03 14.23.09
BR1016I SQL statement 'alter tablespace PSAPSR3DB add datafile '/oracle/TEST/sapdata3/sr3db_4/sr3db.data4' size 100M autoextend off' executed successfully
BR1051I Tablespace PSAPSR3DB extended successfully with file: /oracle/TEST/sapdata3/sr3db_4/sr3db.data4 100M
BR0280I BRSPACE time stamp: 2015-05-03 14.23.09
BR0340I Switching to next online redo log file for database instance TEST ...
BR0321I Switch to next online redo log file for database instance TEST successful
BR0280I BRSPACE time stamp: 2015-05-03 14.23.09
BR0319I Control file copy created: /oracle/TEST/sapreorg/setbywqd/cntrlTEST.new 16302080
BR0280I BRSPACE time stamp: 2015-05-03 14.23.09
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRSPACE time stamp: 2015-05-03 14.23.22
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
y
BR0280I BRSPACE time stamp: 2015-05-03 14.23.26
BR0257I Your reply: 'y'
BR0260E BRSPACE cancelled by user
BR1008I End of BRSPACE processing: setbywqd.tse 2015-05-03 14.23.26
BR0280I BRSPACE time stamp: 2015-05-03 14.23.26
BR1007I BRSPACE terminated with errors
###############################################################################
BR0292I Execution of BRSPACE finished with return code 4
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRTOOLS time stamp: 2015-05-03 14.23.26
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRTOOLS time stamp: 2015-05-03 14.23.28
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2015-05-03 14.23.30
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2015-05-03 14.23.30
BR0654I BRTOOLS terminated with errors
usoak521:oraTEST 3>
extending Tablespace size was differant in oracle SAP DB
SERVER_NAME:oraTEST 2> brtools
BR0651I BRTOOLS 7.00 (32)
BR0280I BRTOOLS time stamp: 2015-05-03 14.21.41
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: 2015-05-03 14.21.49
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2015-05-03 14.21.49
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: 2015-05-03 14.21.53
BR0663I Your choice: '1'
BR0280I BRTOOLS time stamp: 2015-05-03 14.21.53
BR0657I Input menu 81 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension
1 - BRSPACE profile (profile) ...... [initTEST.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 initTEST.sap -s 20 -l E -f tsextend]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2015-05-03 14.21.56
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2015-05-03 14.21.56
BR0681I Enter string value for "tablespace" []:
PSAPSR3DB
BR0280I BRTOOLS time stamp: 2015-05-03 14.22.11
BR0683I New value for "tablespace": 'PSAPSR3DB'
BR0280I BRTOOLS time stamp: 2015-05-03 14.22.11
BR0657I Input menu 81 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension
1 - BRSPACE profile (profile) ...... [initTEST.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPSR3DB]
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initTEST.sap -s 20 -l E -f tsextend -t PSAPSR3DB]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2015-05-03 14.22.15
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initTEST.sap -s 20 -l E -f tsextend -t PSAPSR3DB'
BR0280I BRTOOLS time stamp: 2015-05-03 14.22.15
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2015-05-03 14.22.19
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.00 (32)
BR1002I Start of BRSPACE processing: setbywqd.tse 2015-05-03 14.22.19
BR0484I BRSPACE log file: /oracle/TEST/sapreorg/setbywqd.tse
BR0280I BRSPACE time stamp: 2015-05-03 14.22.19
BR1009I Name of database instance: TEST
BR1010I BRSPACE action ID: setbywqd
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend
BR0280I BRSPACE time stamp: 2015-05-03 14.22.20
BR0657I Input menu 303 - please check/enter input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3DB (1. file)
1 * Last added file name (lastfile) ....... [/oracle/TEST/sapdata3/sr3db_3/sr3db.data3]
2 * Last added file size in MB (lastsize) . [1000]
3 - New file to be added (file) ........... [/oracle/TEST/sapdata3/sr3db_4/sr3db.data4]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [1000]
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 PSAPSR3DB add datafile '/oracle/TEST/sapdata3/sr3db_4/sr3db.data4' size 1000M autoextend off]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
5
BR0280I BRSPACE time stamp: 2015-05-03 14.22.51
BR0663I Your choice: '5'
BR0280I BRSPACE time stamp: 2015-05-03 14.22.51
BR0682I Enter integer value for "size" (1-32767) [1000]:
100
BR0280I BRSPACE time stamp: 2015-05-03 14.22.56
BR0683I New value for "size": '100'
BR0280I BRSPACE time stamp: 2015-05-03 14.22.56
BR0657I Input menu 303 - please check/enter input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3DB (1. file)
1 * Last added file name (lastfile) ....... [/oracle/TEST/sapdata3/sr3db_3/sr3db.data3]
2 * Last added file size in MB (lastsize) . [1000]
3 - New file to be added (file) ........... [/oracle/TEST/sapdata3/sr3db_4/sr3db.data4]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [100]
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 PSAPSR3DB add datafile '/oracle/TEST/sapdata3/sr3db_4/sr3db.data4' size 100M autoextend off]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2015-05-03 14.23.00
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2015-05-03 14.23.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:
n
BR0280I BRSPACE time stamp: 2015-05-03 14.23.08
BR0257I Your reply: 'n'
BR0678I The action will be skipped...
BR0280I BRSPACE time stamp: 2015-05-03 14.23.08
BR0370I Directory /oracle/TEST/sapreorg/setbywqd created
BR0280I BRSPACE time stamp: 2015-05-03 14.23.08
BR0319I Control file copy created: /oracle/TEST/sapreorg/setbywqd/cntrlTEST.old 16302080
BR0280I BRSPACE time stamp: 2015-05-03 14.23.08
BR0370I Directory /oracle/TEST/sapdata3/sr3db_4 created
BR0280I BRSPACE time stamp: 2015-05-03 14.23.08
BR1088I Extending tablespace PSAPSR3DB...
BR0280I BRSPACE time stamp: 2015-05-03 14.23.09
BR1016I SQL statement 'alter tablespace PSAPSR3DB add datafile '/oracle/TEST/sapdata3/sr3db_4/sr3db.data4' size 100M autoextend off' executed successfully
BR1051I Tablespace PSAPSR3DB extended successfully with file: /oracle/TEST/sapdata3/sr3db_4/sr3db.data4 100M
BR0280I BRSPACE time stamp: 2015-05-03 14.23.09
BR0340I Switching to next online redo log file for database instance TEST ...
BR0321I Switch to next online redo log file for database instance TEST successful
BR0280I BRSPACE time stamp: 2015-05-03 14.23.09
BR0319I Control file copy created: /oracle/TEST/sapreorg/setbywqd/cntrlTEST.new 16302080
BR0280I BRSPACE time stamp: 2015-05-03 14.23.09
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRSPACE time stamp: 2015-05-03 14.23.22
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
y
BR0280I BRSPACE time stamp: 2015-05-03 14.23.26
BR0257I Your reply: 'y'
BR0260E BRSPACE cancelled by user
BR1008I End of BRSPACE processing: setbywqd.tse 2015-05-03 14.23.26
BR0280I BRSPACE time stamp: 2015-05-03 14.23.26
BR1007I BRSPACE terminated with errors
###############################################################################
BR0292I Execution of BRSPACE finished with return code 4
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRTOOLS time stamp: 2015-05-03 14.23.26
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRTOOLS time stamp: 2015-05-03 14.23.28
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2015-05-03 14.23.30
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2015-05-03 14.23.30
BR0654I BRTOOLS terminated with errors
usoak521:oraTEST 3>
No comments:
Post a Comment