** Tested with UNIX / Solarise operating system.
In our organisation SAP is front end application. So as DBA we do have exposure on BRTOOL,BRSPACE etc.So just sharing the BR tool handling issue from todays onwards.
So here is one tested example for adding datafile in tablespace using the BRTOOL. Hopw you guys enjoy with this one…..!!!!
bash-3.00$ brtools
BR0651I BRTOOLS 7.00 (11)
BR0651I BRTOOLS 7.00 (11)
BR0280I BRTOOLS time stamp: 2011-04-06 07.10.35
BR0656I Choice menu 1 – please make a selection
——————————————————————————-
BR*Tools main menu
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
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: 2011-04-06 07.10.39
BR0663I Your choice: '2′
——————————————————————————-
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2011-04-06 07.10.39
BR0663I Your choice: '2′
BR0280I BRTOOLS time stamp: 2011-04-06 07.10.39
BR0656I Choice menu 5 – please make a selection
——————————————————————————-
Database space management
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
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: 2011-04-06 07.10.57
BR0663I Your choice: '1′
——————————————————————————-
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2011-04-06 07.10.57
BR0663I Your choice: '1′
BR0280I BRTOOLS time stamp: 2011-04-06 07.10.57
BR0657I Input menu 81 – please check/enter input values
——————————————————————————-
BRSPACE options for tablespace extension
BR0657I Input menu 81 – please check/enter input values
——————————————————————————-
BRSPACE options for tablespace extension
1 – BRSPACE profile (profile) …… [initSAM.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 initSAM.sap -s 20 -l E -f tsextend]
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 initSAM.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: 2011-04-06 07.11.09
BR0663I Your choice: '3′
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2011-04-06 07.11.09
BR0663I Your choice: '3′
BR0280I BRTOOLS time stamp: 2011-04-06 07.11.09
BR0681I Enter string value for "tablespace" []:
3
BR0280I BRTOOLS time stamp: 2011-04-06 07.11.32
BR0683I New value for "tablespace": '3′
BR0681I Enter string value for "tablespace" []:
3
BR0280I BRTOOLS time stamp: 2011-04-06 07.11.32
BR0683I New value for "tablespace": '3′
BR0280I BRTOOLS time stamp: 2011-04-06 07.11.32
BR0657I Input menu 81 – please check/enter input values
——————————————————————————-
BRSPACE options for tablespace extension
BR0657I Input menu 81 – please check/enter input values
——————————————————————————-
BRSPACE options for tablespace extension
1 – BRSPACE profile (profile) …… [initSAM.sap]
2 – Database user/password (user) .. [/]
3 ‾ Tablespace name (tablespace) … [3]
4 – Confirmation mode (confirm) …. [yes]
5 – Scrolling line count (scroll) .. [20]
6 – Message language (language) …. [E]
7 – BRSPACE command line (command) . [-p initSAM.sap -s 20 -l E -f tsextend -t 3]
2 – Database user/password (user) .. [/]
3 ‾ Tablespace name (tablespace) … [3]
4 – Confirmation mode (confirm) …. [yes]
5 – Scrolling line count (scroll) .. [20]
6 – Message language (language) …. [E]
7 – BRSPACE command line (command) . [-p initSAM.sap -s 20 -l E -f tsextend -t 3]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2011-04-06 07.12.55
BR0663I Your choice: '3′
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2011-04-06 07.12.55
BR0663I Your choice: '3′
BR0280I BRTOOLS time stamp: 2011-04-06 07.12.55
BR0681I Enter string value for "tablespace" [3]:
BR0681I Enter string value for "tablespace" [3]:
BR0280I BRTOOLS time stamp: 2011-04-06 07.13.17
BR0686I The value of "tablespace" was not changed
BR0686I The value of "tablespace" was not changed
BR0280I BRTOOLS time stamp: 2011-04-06 07.13.17
BR0657I Input menu 81 – please check/enter input values
——————————————————————————-
BRSPACE options for tablespace extension
BR0657I Input menu 81 – please check/enter input values
——————————————————————————-
BRSPACE options for tablespace extension
1 – BRSPACE profile (profile) …… [initSAM.sap]
2 – Database user/password (user) .. [/]
3 ‾ Tablespace name (tablespace) … [3]
4 – Confirmation mode (confirm) …. [yes]
5 – Scrolling line count (scroll) .. [20]
6 – Message language (language) …. [E]
7 – BRSPACE command line (command) . [-p initSAM.sap -s 20 -l E -f tsextend -t 3]
2 – Database user/password (user) .. [/]
3 ‾ Tablespace name (tablespace) … [3]
4 – Confirmation mode (confirm) …. [yes]
5 – Scrolling line count (scroll) .. [20]
6 – Message language (language) …. [E]
7 – BRSPACE command line (command) . [-p initSAM.sap -s 20 -l E -f tsextend -t 3]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2011-04-06 07.13.59
BR0663I Your choice: '3′
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2011-04-06 07.13.59
BR0663I Your choice: '3′
BR0280I BRTOOLS time stamp: 2011-04-06 07.13.59
BR0681I Enter string value for "tablespace" [3]:
PSAPSR3
BR0280I BRTOOLS time stamp: 2011-04-06 07.14.51
BR0683I New value for "tablespace": 'PSAPSR3′
BR0681I Enter string value for "tablespace" [3]:
PSAPSR3
BR0280I BRTOOLS time stamp: 2011-04-06 07.14.51
BR0683I New value for "tablespace": 'PSAPSR3′
BR0280I BRTOOLS time stamp: 2011-04-06 07.14.51
BR0657I Input menu 81 – please check/enter input values
——————————————————————————-
BRSPACE options for tablespace extension
BR0657I Input menu 81 – please check/enter input values
——————————————————————————-
BRSPACE options for tablespace extension
1 – BRSPACE profile (profile) …… [initSAM.sap]
2 – Database user/password (user) .. [/]
3 ‾ Tablespace name (tablespace) … [PSAPSR3]
4 – Confirmation mode (confirm) …. [yes]
5 – Scrolling line count (scroll) .. [20]
6 – Message language (language) …. [E]
7 – BRSPACE command line (command) . [-p initSAM.sap -s 20 -l E -f tsextend -t PSAPSR3]
2 – Database user/password (user) .. [/]
3 ‾ Tablespace name (tablespace) … [PSAPSR3]
4 – Confirmation mode (confirm) …. [yes]
5 – Scrolling line count (scroll) .. [20]
6 – Message language (language) …. [E]
7 – BRSPACE command line (command) . [-p initSAM.sap -s 20 -l E -f tsextend -t PSAPSR3]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2011-04-06 07.15.13
BR0663I Your choice: 'c'
BR0259I Program execution will be continued…
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2011-04-06 07.15.13
BR0663I Your choice: 'c'
BR0259I Program execution will be continued…
BR0291I BRSPACE will be started with options '-p initSAM.sap -s 20 -l E -f tsextend -t PSAPSR3′
BR0280I BRTOOLS time stamp: 2011-04-06 07.15.13
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2011-04-06 07.15.25
BR0257I Your reply: 'c'
BR0259I Program execution will be continued…
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2011-04-06 07.15.25
BR0257I Your reply: 'c'
BR0259I Program execution will be continued…
###############################################################################
BR1001I BRSPACE 7.00 (11)
BR1002I Start of BRSPACE processing: sefphjwn.tse 2011-04-06 07.15.25
BR1002I Start of BRSPACE processing: sefphjwn.tse 2011-04-06 07.15.25
BR0280I BRSPACE time stamp: 2011-04-06 07.15.26
BR1009I Name of database instance: SAM
BR1010I BRSPACE action ID: sefphjwn
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend
BR1009I Name of database instance: SAM
BR1010I BRSPACE action ID: sefphjwn
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend
BR0280I BRSPACE time stamp: 2011-04-06 07.15.26
BR0657I Input menu 303 – please check/enter input values
——————————————————————————-
Options for extension of tablespace PSAPSR3 (1. file)
BR0657I Input menu 303 – please check/enter input values
——————————————————————————-
Options for extension of tablespace PSAPSR3 (1. file)
1 * Last added file name (lastfile) ……. [/oracle/SAM/sapdata2/sr3_30/sr3.data30]
2 * Last added file size in MB (lastsize) . [10240]
3 – New file to be added (file) ……….. [/oracle/SAM/sapdata2/sr3_31/sr3.data31]
4 ‾ Raw disk / link target (rawlink) …… []
5 – Size of the new file in MB (size) ….. [10240]
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/SAM/sapdata2/sr3_31/sr3.data31' size 10240M autoextend off]
2 * Last added file size in MB (lastsize) . [10240]
3 – New file to be added (file) ……….. [/oracle/SAM/sapdata2/sr3_31/sr3.data31]
4 ‾ Raw disk / link target (rawlink) …… []
5 – Size of the new file in MB (size) ….. [10240]
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/SAM/sapdata2/sr3_31/sr3.data31' size 10240M autoextend off]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRSPACE time stamp: 2011-04-06 07.16.07
BR0663I Your choice: '3′
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRSPACE time stamp: 2011-04-06 07.16.07
BR0663I Your choice: '3′
BR0280I BRSPACE time stamp: 2011-04-06 07.16.07
BR0681I Enter string value for "file" (<file>|<sapdata>|<N>) [/oracle/SAM/sapdata2/sr3_31/sr3.data31]:
/oracle/SAM/sapdata2/sr3_31/sr3.data31
BR0280I BRSPACE time stamp: 2011-04-06 07.17.24
BR0683I New value for "file": '/oracle/SAM/sapdata2/sr3_31/sr3.data31′
BR0681I Enter string value for "file" (<file>|<sapdata>|<N>) [/oracle/SAM/sapdata2/sr3_31/sr3.data31]:
/oracle/SAM/sapdata2/sr3_31/sr3.data31
BR0280I BRSPACE time stamp: 2011-04-06 07.17.24
BR0683I New value for "file": '/oracle/SAM/sapdata2/sr3_31/sr3.data31′
BR0280I BRSPACE time stamp: 2011-04-06 07.17.24
BR0657I Input menu 303 – please check/enter input values
——————————————————————————-
Options for extension of tablespace PSAPSR3 (1. file)
BR0657I Input menu 303 – please check/enter input values
——————————————————————————-
Options for extension of tablespace PSAPSR3 (1. file)
1 * Last added file name (lastfile) ……. [/oracle/SAM/sapdata2/sr3_30/sr3.data30]
2 * Last added file size in MB (lastsize) . [10240]
3 – New file to be added (file) ……….. [/oracle/SAM/sapdata2/sr3_31/sr3.data31]
4 ‾ Raw disk / link target (rawlink) …… []
5 – Size of the new file in MB (size) ….. [10240]
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/SAM/sapdata2/sr3_31/sr3.data31' size 10240M autoextend off]
2 * Last added file size in MB (lastsize) . [10240]
3 – New file to be added (file) ……….. [/oracle/SAM/sapdata2/sr3_31/sr3.data31]
4 ‾ Raw disk / link target (rawlink) …… []
5 – Size of the new file in MB (size) ….. [10240]
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/SAM/sapdata2/sr3_31/sr3.data31' size 10240M autoextend off]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2011-04-06 07.17.49
BR0663I Your choice: 'c'
BR0259I Program execution will be continued…
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2011-04-06 07.17.49
BR0663I Your choice: 'c'
BR0259I Program execution will be continued…
BR0280I BRSPACE time stamp: 2011-04-06 07.17.49
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: 2011-04-06 07.18.17
BR0257I Your reply: 'c'
BR0678I The action will be skipped…
BR0259I Program execution will be continued…
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: 2011-04-06 07.18.17
BR0257I Your reply: 'c'
BR0678I The action will be skipped…
BR0259I Program execution will be continued…
BR0280I BRSPACE time stamp: 2011-04-06 07.18.17
BR0370I Directory /oracle/SAM/sapreorg/sefphjwn created
BR0370I Directory /oracle/SAM/sapreorg/sefphjwn created
BR0280I BRSPACE time stamp: 2011-04-06 07.18.18
BR0319I Control file copy created: /oracle/SAM/sapreorg/sefphjwn/cntrlSAM.old 14237696
BR0319I Control file copy created: /oracle/SAM/sapreorg/sefphjwn/cntrlSAM.old 14237696
BR0280I BRSPACE time stamp: 2011-04-06 07.18.18
BR0370I Directory /oracle/SAM/sapdata2/sr3_31 created
BR0370I Directory /oracle/SAM/sapdata2/sr3_31 created
BR0280I BRSPACE time stamp: 2011-04-06 07.18.18
BR1088I Extending tablespace PSAPSR3…
BR1088I Extending tablespace PSAPSR3…
BR0280I BRSPACE time stamp: 2011-04-06 07.19.33
BR1016I SQL statement 'alter tablespace PSAPSR3 add datafile '/oracle/SAM/sapdata2/sr3_31/sr3.data31′ size 10240M autoextend off' executed successfully
BR1051I Tablespace PSAPSR3 extended successfully with file: /oracle/SAM/sapdata2/sr3_31/sr3.data31 10240M
BR1016I SQL statement 'alter tablespace PSAPSR3 add datafile '/oracle/SAM/sapdata2/sr3_31/sr3.data31′ size 10240M autoextend off' executed successfully
BR1051I Tablespace PSAPSR3 extended successfully with file: /oracle/SAM/sapdata2/sr3_31/sr3.data31 10240M
BR0280I BRSPACE time stamp: 2011-04-06 07.19.33
BR0340I Switching to next online redo log file for database instance SAM…
BR0321I Switch to next online redo log file for database instance SAM successful
BR0340I Switching to next online redo log file for database instance SAM…
BR0321I Switch to next online redo log file for database instance SAM successful
BR0280I BRSPACE time stamp: 2011-04-06 07.19.35
BR0319I Control file copy created: /oracle/SAM/sapreorg/sefphjwn/cntrlSAM.new 14237696
BR0319I Control file copy created: /oracle/SAM/sapreorg/sefphjwn/cntrlSAM.new 14237696
BR0280I BRSPACE time stamp: 2011-04-06 07.19.35
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRSPACE time stamp: 2011-04-06 07.21.00
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
yes
BR0280I BRSPACE time stamp: 2011-04-06 07.21.03
BR0257I Your reply: 'yes'
BR0260E BRSPACE cancelled by user
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRSPACE time stamp: 2011-04-06 07.21.00
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
yes
BR0280I BRSPACE time stamp: 2011-04-06 07.21.03
BR0257I Your reply: 'yes'
BR0260E BRSPACE cancelled by user
BR1008I End of BRSPACE processing: sefphjwn.tse 2011-04-06 07.21.03
BR0280I BRSPACE time stamp: 2011-04-06 07.21.03
BR1007I BRSPACE terminated with errors
BR0280I BRSPACE time stamp: 2011-04-06 07.21.03
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: 2011-04-06 07.21.03
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRTOOLS time stamp: 2011-04-06 07.21.08
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
yes
BR0280I BRTOOLS time stamp: 2011-04-06 07.21.11
BR0257I Your reply: 'yes'
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2011-04-06 07.21.03
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRTOOLS time stamp: 2011-04-06 07.21.08
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
yes
BR0280I BRTOOLS time stamp: 2011-04-06 07.21.11
BR0257I Your reply: 'yes'
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2011-04-06 07.21.11
BR0654I BRTOOLS terminated with errors
bash-3.00$
BR0654I BRTOOLS terminated with errors
bash-3.00$
Facebook
0 comments:
Post a Comment