Dear Friens back to my Oracle journey after long time. In our organisation I got the opportunity to work on SAP as well from Database point of issue.I want to make my blog as complete solution for BRtools.So here I am coming with new post to add tablespace in DB using the BRtools.
bash-3.00$ brtools
BR0651I BRTOOLS 7.20 (1)
BR0280I BRTOOLS time stamp: 2011-08-01 00.28.27
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: 2011-08-01 00.28.31
BR0663I Your choice: ‘2’
BR0280I BRTOOLS time stamp: 2011-08-01 00.28.31
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:
2
BR0280I BRTOOLS time stamp: 2011-08-01 00.28.33
BR0663I Your choice: ‘2’
BR0280I BRTOOLS time stamp: 2011-08-01 00.28.33
BR0657I Input menu 82 – please enter/check input values
——————————————————————————-
BRSPACE options for create tablespace
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 tscreate]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2011-08-01 00.28.39
BR0663I Your choice: ‘3’
BR0681I Enter string value for “tablespace” []:
PSAPSR3SAM
BR0280I BRTOOLS time stamp: 2011-08-01 00.29.06
BR0683I New value for “tablespace”: ‘PSAPSR3SAM’
BR0280I BRTOOLS time stamp: 2011-08-01 00.29.06
BR0657I Input menu 82 – please enter/check input values
——————————————————————————-
BRSPACE options for create tablespace
1 – BRSPACE profile (profile) …… [initSAM.sap]
2 – Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) … [PSAPSR3SAM]
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 tscreate -t PSAPSR3SAM]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2011-08-01 00.29.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 tscreate -t PSAPSR3SAM’
BR0280I BRTOOLS time stamp: 2011-08-01 00.29.13
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRTOOLS time stamp: 2011-08-01 00.29.18
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…
###############################################################################
BR1001I BRSPACE 7.20 (1)
BR1002I Start of BRSPACE processing: segljdri.tsc 2011-08-01 00.29.18
BR0484I BRSPACE log file: /oracle/SAM/sapreorg/segljdri.tsc
BR0280I BRSPACE time stamp: 2011-08-01 00.29.19
BR1009I Name of database instance: SAM
BR1010I BRSPACE action ID: segljdri
BR1011I BRSPACE function ID: tsc
BR1012I BRSPACE function: tscreate
BR0280I BRSPACE time stamp: 2011-08-01 00.29.20
BR0657I Input menu 305 – please enter/check input values
——————————————————————————-
Main options for creation of tablespace in database SAM
1 – Tablespace name (tablespace) ……… [PSAPSR3SAM]
2 – Tablespace contents (contents) ……. [data]
3 – Segment space management (space) ….. [auto]
4 – Database owner of tablespace (owner) . [SAPSR3]
5 ~ Table data class / tabart (class) …. []
6 – Data type in tablespace (data) ……. [both]
7 # Joined index/table tablespace (join) . []
8 ~ Uniform size in MB (uniform) ……… []
9 # Tablespace compression (compress) …. [no]
10 # Tablespace encryption (encrypt) …… [no]
11 # Encryption algorithm (algorithm) ….. []
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
5
BR0280I BRSPACE time stamp: 2011-08-01 00.29.26
BR0663I Your choice: ‘5’
BR0681I Enter string value for “class” (all|<tab_class>|<tab_class_list>|<old_tsp>|<old_tsp_list>|none) []:
PSAPSR3SAM01
BR0280I BRSPACE time stamp: 2011-08-01 00.29.47
BR0683I New value for “class”: ‘PSAPSR3SAM01’
BR0280I BRSPACE time stamp: 2011-08-01 00.29.47
BR0657I Input menu 305 – please enter/check input values
——————————————————————————-
Main options for creation of tablespace in database SAM
1 – Tablespace name (tablespace) ……… [PSAPSR3SAM]
2 – Tablespace contents (contents) ……. [data]
3 – Segment space management (space) ….. [auto]
4 – Database owner of tablespace (owner) . [SAPSR3]
5 ~ Table data class / tabart (class) …. [PSAPSR3SAM01]
6 – Data type in tablespace (data) ……. [both]
7 # Joined index/table tablespace (join) . []
8 ~ Uniform size in MB (uniform) ……… []
9 # Tablespace compression (compress) …. [no]
10 # Tablespace encryption (encrypt) …… [no]
11 # Encryption algorithm (algorithm) ….. []
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2011-08-01 00.30.23
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…
BR0280I BRSPACE time stamp: 2011-08-01 00.30.23
BR0657I Input menu 306 – please enter/check input values
——————————————————————————-
Space options for creation of tablespace PSAPSR3SAM (1. file)
1 – Tablespace file name (file) ………. [/oracle/SAM/sapdata4/sr3sam_1/sr3sam.data1]
2 ~ Raw disk / link target (rawlink) ….. []
3 – File size in MB (size) …………… [30]
4 – File autoextend mode (autoextend) …. [yes]
5 – Maximum file size in MB (maxsize) …. [10000]
6 – File increment size in MB (incrsize) . [20]
7 – SQL command (command) ……………. [create tablespace PSAPSR3SAM extent management local autoallocate segment space management auto datafile ‘/oracle/SAM/sapdata4/sr3sam_1/sr3sam.data1’ size 30M autoextend on next 20M maxsize 10000M]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRSPACE time stamp: 2011-08-01 00.30.49
BR0663I Your choice: ‘3’
BR0682I Enter integer value for “size” (1-32767) [30]:
500
BR0280I BRSPACE time stamp: 2011-08-01 00.31.13
BR0683I New value for “size”: ‘500’
BR0280I BRSPACE time stamp: 2011-08-01 00.31.13
BR0657I Input menu 306 – please enter/check input values
——————————————————————————-
Space options for creation of tablespace PSAPSR3SAM (1. file)
1 – Tablespace file name (file) ………. [/oracle/SAM/sapdata4/sr3sam_1/sr3sam.data1]
2 ~ Raw disk / link target (rawlink) ….. []
3 – File size in MB (size) …………… [500]
4 – File autoextend mode (autoextend) …. [yes]
5 – Maximum file size in MB (maxsize) …. [10000]
6 – File increment size in MB (incrsize) . [20]
7 – SQL command (command) ……………. [create tablespace PSAPSR3SAM extent management local autoallocate segment space management auto datafile ‘/oracle/SAM/sapdata4/sr3sam_1/sr3sam.data1’ size 500M autoextend on next 20M maxsize 10000M]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
5
BR0280I BRSPACE time stamp: 2011-08-01 00.31.21
BR0663I Your choice: ‘5’
BR0682I Enter integer value for “maxsize” (0-32767) [10000]:
1000
BR0280I BRSPACE time stamp: 2011-08-01 00.31.28
BR0683I New value for “maxsize”: ‘1000’
BR0280I BRSPACE time stamp: 2011-08-01 00.31.28
BR0657I Input menu 306 – please enter/check input values
——————————————————————————-
Space options for creation of tablespace PSAPSR3SAM (1. file)
1 – Tablespace file name (file) ………. [/oracle/SAM/sapdata4/sr3sam_1/sr3sam.data1]
2 ~ Raw disk / link target (rawlink) ….. []
3 – File size in MB (size) …………… [500]
4 – File autoextend mode (autoextend) …. [yes]
5 – Maximum file size in MB (maxsize) …. [1000]
6 – File increment size in MB (incrsize) . [20]
7 – SQL command (command) ……………. [create tablespace PSAPSR3SAM extent management local autoallocate segment space management auto datafile ‘/oracle/SAM/sapdata4/sr3sam_1/sr3sam.data1’ size 500M autoextend on next 20M maxsize 1000M]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2011-08-01 00.31.55
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…
BR1049W Not enough free space in /oracle/SAM/sapdata4 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 76824.785 MB
BR1049W Not enough free space in /oracle/SAM/sapdata4 for total maximum size of all database files of tablespace PSAPSR3702 located on this disk volume, missing at least 47264.785 MB
BR0280I BRSPACE time stamp: 2011-08-01 00.31.55
BR0668I Warnings or errors occurred – you can continue to ignore them or go back to repeat the last action
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRSPACE time stamp: 2011-08-01 00.32.05
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…
BR1091I Next data file can be specified now
BR0280I BRSPACE time stamp: 2011-08-01 00.32.05
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: 2011-08-01 00.32.19
BR0257I Your reply: ‘c’
BR0678I The action will be skipped…
BR0259I Program execution will be continued…
BR0280I BRSPACE time stamp: 2011-08-01 00.32.19
BR0370I Directory /oracle/SAM/sapreorg/segljdri created
BR0280I BRSPACE time stamp: 2011-08-01 00.32.20
BR0319I Control file copy created: /oracle/SAM/sapreorg/segljdri/cntrlSAM.old 13844480
BR0280I BRSPACE time stamp: 2011-08-01 00.32.20
BR0370I Directory /oracle/SAM/sapdata4/sr3sam_1 created
BR0280I BRSPACE time stamp: 2011-08-01 00.32.20
BR1089I Creating tablespace PSAPSR3SAM…
BR0280I BRSPACE time stamp: 2011-08-01 00.32.45
BR1016I SQL statement ‘create tablespace PSAPSR3SAM extent management local autoallocate segment space management auto datafile ‘/oracle/SAM/sapdata4/sr3sam_1/sr3sam.data1′ size 500M autoextend on next 20M maxsize 1000M’ executed successfully
BR1060I Tablespace PSAPSR3SAM created successfully with file: /oracle/SAM/sapdata4/sr3sam_1/sr3sam.data1 500M
BR0280I BRSPACE time stamp: 2011-08-01 00.32.45
BR0340I Switching to next online redolog file for database instance SAM …
BR0321I Switch to next online redolog file for database instance SAM successful
BR0280I BRSPACE time stamp: 2011-08-01 00.32.48
BR0319I Control file copy created: /oracle/SAM/sapreorg/segljdri/cntrlSAM.new 13844480
BR0280I BRSPACE time stamp: 2011-08-01 00.32.48
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRSPACE time stamp: 2011-08-01 00.33.51
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…
BR0280I BRSPACE time stamp: 2011-08-01 00.33.51
BR1020I Number of tablespaces processed: 1
BR1003I BRSPACE function ‘tscreate’ completed
BR1008I End of BRSPACE processing: segljdri.tsc 2011-08-01 00.33.51
BR0280I BRSPACE time stamp: 2011-08-01 00.33.51
BR1006I BRSPACE completed successfully with warnings
###############################################################################
BR0292I Execution of BRSPACE finished with return code 1
BR0280I BRTOOLS time stamp: 2011-08-01 00.33.51
BR0668I Warnings or errors occurred – you can continue to ignore them or go back to repeat the last action
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRTOOLS time stamp: 2011-08-01 00.33.58
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…
BR0280I BRTOOLS time stamp: 2011-08-01 00.33.58
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:
BR0256I Enter ‘c[ont]’ to continue, ‘s[top]’ to cancel BRTOOLS:
s
BR0280I BRTOOLS time stamp: 2011-08-01 00.34.51
BR0257I Your reply: ‘s’
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2011-08-01 00.34.54
BR0257I Your reply: ‘y’
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2011-08-01 00.34.54
BR0654I BRTOOLS terminated with errors
bash-3.00$
Hope you guy’s like this post. ….!!!!
Experts are always welcome for their valuable comment or suggestion for the above post….!!!!
Thank you and worth full
thx for this explaination.
you are the best