Feeds:
Posts
Comments

Posts Tagged ‘add tablespace’

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….!!!!

Advertisements

Read Full Post »