Brtools: Creating a new tablespace

smdev:SMD:/home/orasmd> brtools
BR0651I BRTOOLS 7.00 (28)

BR0280I BRTOOLS time stamp: 2009-07-24 14.14.48
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: 2009-07-24 14.14.52
BR0663I Your choice: ‘2’

BR0280I BRTOOLS time stamp: 2009-07-24 14.14.52
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: 2009-07-24 14.18.19
BR0663I Your choice: ‘2’

BR0280I BRTOOLS time stamp: 2009-07-24 14.18.19
BR0657I Input menu 82 – please check/enter input values
——————————————————————————-
BRSPACE options for create tablespace

1 – BRSPACE profile (profile) …… [initSMD.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 initSMD.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: 2009-07-24 14.18.24
BR0663I Your choice: ‘3’

BR0280I BRTOOLS time stamp: 2009-07-24 14.18.24
BR0681I Enter string value for “tablespace” []:
PSAPSR3701
BR0280I BRTOOLS time stamp: 2009-07-24 14.18.46
BR0683I New value for “tablespace”: ‘PSAPSR3701’

BR0280I BRTOOLS time stamp: 2009-07-24 14.18.46
BR0657I Input menu 82 – please check/enter input values
——————————————————————————-
BRSPACE options for create tablespace

1 – BRSPACE profile (profile) …… [initSMD.sap]
2 – Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) … [PSAPSR3701]
4 – Confirmation mode (confirm) …. [yes]
5 – Scrolling line count (scroll) .. [20]
6 – Message language (language) …. [E]
7 – BRSPACE command line (command) . [-p initSMD.sap -s 20 -l E -f tscreate -t PSAPSR3701]

Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2009-07-24 14.18.53
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…

BR0291I BRSPACE will be started with options ‘-p initSMD.sap -s 20 -l E -f tscreate -t PSAPSR3701’

BR0280I BRTOOLS time stamp: 2009-07-24 14.18.53
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRTOOLS time stamp: 2009-07-24 14.18.59
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…

###############################################################################

BR1001I BRSPACE 7.00 (28)
BR1002I Start of BRSPACE processing: sebcabqp.tsc 2009-07-24 14.18.59
BR0484I BRSPACE log file: /oracle/SMD/sapreorg/sebcabqp.tsc

BR0280I BRSPACE time stamp: 2009-07-24 14.19.01
BR1009I Name of database instance: SMD
BR1010I BRSPACE action ID: sebcabqp
BR1011I BRSPACE function ID: tsc
BR1012I BRSPACE function: tscreate

BR0280I BRSPACE time stamp: 2009-07-24 14.19.03
BR0657I Input menu 305 – please check/enter input values
——————————————————————————-
Main options for creation of tablespace in database SMD

1 – Tablespace name (tablespace) ……… [PSAPSR3701]
2 – Tablespace contents (contents) ……. [data]
3 – Segment space management (space) ….. [auto]
4 ? Database owner of tablespace (owner) . []
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) ……… []

Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
5
BR0280I BRSPACE time stamp: 2009-07-24 14.19.28
BR0663I Your choice: ‘5’

BR0280I BRSPACE time stamp: 2009-07-24 14.19.28
BR0681I Enter string value for “class” (all|||||none) []:
PSAPSR3700
BR0280I BRSPACE time stamp: 2009-07-24 14.19.48
BR0683I New value for “class”: ‘PSAPSR3700’

BR0280I BRSPACE time stamp: 2009-07-24 14.19.48
BR0657I Input menu 305 – please check/enter input values
——————————————————————————-
Main options for creation of tablespace in database SMD

1 – Tablespace name (tablespace) ……… [PSAPSR3701]
2 – Tablespace contents (contents) ……. [data]
3 – Segment space management (space) ….. [auto]
4 ? Database owner of tablespace (owner) . []
5 ~ Table data class / tabart (class) …. [PSAPSR3700]
6 – Data type in tablespace (data) ……. [both]
7 # Joined index/table tablespace (join) . []
8 ~ Uniform size in MB (uniform) ……… []

Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
4
BR0280I BRSPACE time stamp: 2009-07-24 14.21.08
BR0663I Your choice: ‘4’

BR0280I BRSPACE time stamp: 2009-07-24 14.21.08
BR0681I Enter string value for “owner” (|none) []:
SAPSR3
BR0280I BRSPACE time stamp: 2009-07-24 14.21.12
BR0683I New value for “owner”: ‘SAPSR3’

BR0280I BRSPACE time stamp: 2009-07-24 14.21.12
BR0657I Input menu 305 – please check/enter input values
——————————————————————————-
Main options for creation of tablespace in database SMD

1 – Tablespace name (tablespace) ……… [PSAPSR3701]
2 – Tablespace contents (contents) ……. [data]
3 – Segment space management (space) ….. [auto]
4 – Database owner of tablespace (owner) . [SAPSR3]
5 ~ Table data class / tabart (class) …. [PSAPSR3700]
6 – Data type in tablespace (data) ……. [both]
7 # Joined index/table tablespace (join) . []
8 ~ Uniform size in MB (uniform) ……… []

Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2009-07-24 14.21.46
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…

BR0280I BRSPACE time stamp: 2009-07-24 14.21.46
BR0657I Input menu 306 – please check/enter input values
——————————————————————————-
Space options for creation of tablespace PSAPSR3701 (1. file)

1 – Tablespace file name (file) ………. [/oracle/SMD/sapdata6/sr3701_1/sr3701.data1]
2 ~ Raw disk / link target (rawlink) ….. []
3 – File size in MB (size) …………… [1000]
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 PSAPSR3701 extent management local autoallocate segment space management auto datafile ‘/oracle/SMD/sapdata6/sr3701_1/sr3701.data1’ size 1000M 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: 2009-07-24 14.22.25
BR0663I Your choice: ‘5’

BR0280I BRSPACE time stamp: 2009-07-24 14.22.25
BR0682I Enter integer value for “maxsize” (0-32767) [10000]:
20000
BR0280I BRSPACE time stamp: 2009-07-24 14.22.29
BR0683I New value for “maxsize”: ‘20000’

BR0280I BRSPACE time stamp: 2009-07-24 14.22.29
BR0657I Input menu 306 – please check/enter input values
——————————————————————————-
Space options for creation of tablespace PSAPSR3701 (1. file)

1 – Tablespace file name (file) ………. [/oracle/SMD/sapdata6/sr3701_1/sr3701.data1]
2 ~ Raw disk / link target (rawlink) ….. []
3 – File size in MB (size) …………… [1000]
4 – File autoextend mode (autoextend) …. [yes]
5 – Maximum file size in MB (maxsize) …. [20000]
6 – File increment size in MB (incrsize) . [20]
7 – SQL command (command) ……………. [create tablespace PSAPSR3701 extent management local autoallocate segment space management auto datafile ‘/oracle/SMD/sapdata6/sr3701_1/sr3701.data1’ size 1000M autoextend on next 20M maxsize 20000M]

Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2009-07-24 14.22.37
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…

BR0280I BRSPACE time stamp: 2009-07-24 14.22.38
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: 2009-07-24 14.22.42
BR0257I Your reply: ‘y’
BR0677I The action will be performed…

BR0280I BRSPACE time stamp: 2009-07-24 14.22.42
BR0657I Input menu 306 – please check/enter input values
——————————————————————————-
Space options for creation of tablespace PSAPSR3701 (2. file)

1 – Tablespace file name (file) ………. [/oracle/SMD/sapdata6/sr3701_2/sr3701.data2]
2 ~ Raw disk / link target (rawlink) ….. []
3 – File size in MB (size) …………… [1000]
4 – File autoextend mode (autoextend) …. [yes]
5 – Maximum file size in MB (maxsize) …. [20000]
6 – File increment size in MB (incrsize) . [20]
7 – SQL command (command) ……………. [create tablespace PSAPSR3701 extent management local autoallocate segment space management auto datafile ‘/oracle/SMD/sapdata6/sr3701_1/sr3701.data1’ size 1000M autoextend on next 20M maxsize 20000M, ‘/oracle/SMD/sapdata6/sr3701_2/sr3701.data2’ size 1000M autoextend on next 20M maxsize 20000M]

Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
1
BR0280I BRSPACE time stamp: 2009-07-24 14.22.48
BR0663I Your choice: ‘1’

BR0280I BRSPACE time stamp: 2009-07-24 14.22.48
BR0681I Enter string value for “file” (||) [/oracle/SMD/sapdata6/sr3701_2/sr3701.data2]:
/oracle/SMD/sapdata5
BR0280I BRSPACE time stamp: 2009-07-24 14.22.58
BR0683I New value for “file”: ‘/oracle/SMD/sapdata5’

BR0280I BRSPACE time stamp: 2009-07-24 14.22.58
BR0657I Input menu 306 – please check/enter input values
——————————————————————————-
Space options for creation of tablespace PSAPSR3701 (2. file)

1 – Tablespace file name (file) ………. [/oracle/SMD/sapdata5/sr3701_2/sr3701.data2]
2 ~ Raw disk / link target (rawlink) ….. []
3 – File size in MB (size) …………… [1000]
4 – File autoextend mode (autoextend) …. [yes]
5 – Maximum file size in MB (maxsize) …. [20000]
6 – File increment size in MB (incrsize) . [20]
7 – SQL command (command) ……………. [create tablespace PSAPSR3701 extent management local autoallocate segment space management auto datafile ‘/oracle/SMD/sapdata6/sr3701_1/sr3701.data1’ size 1000M autoextend on next 20M maxsize 20000M, ‘/oracle/SMD/sapdata5/sr3701_2/sr3701.data2’ size 1000M autoextend on next 20M maxsize 20000M]

Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2009-07-24 14.23.15
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…

BR0280I BRSPACE time stamp: 2009-07-24 14.23.15
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: 2009-07-24 14.23.20
BR0257I Your reply: ‘n’
BR0678I The action will be skipped…

BR0280I BRSPACE time stamp: 2009-07-24 14.23.21
BR0370I Directory /oracle/SMD/sapreorg/sebcabqp created

BR0280I BRSPACE time stamp: 2009-07-24 14.23.21
BR0319I Control file copy created: /oracle/SMD/sapreorg/sebcabqp/cntrlSMD.old 11124736

BR0280I BRSPACE time stamp: 2009-07-24 14.23.21
BR0370I Directory /oracle/SMD/sapdata6/sr3701_1 created
BR0370I Directory /oracle/SMD/sapdata5/sr3701_2 created

BR0280I BRSPACE time stamp: 2009-07-24 14.23.22
BR1089I Creating tablespace PSAPSR3701…

BR0280I BRSPACE time stamp: 2009-07-24 14.23.45
BR1016I SQL statement ‘create tablespace PSAPSR3701 extent management local autoallocate segment space management auto datafile ‘/oracle/SMD/sapdata6/sr3701_1/sr3701.data1’ size 1000M autoextend on next 20M maxsize 20000M, ‘/oracle/SMD/sapdata5/sr3701_2/sr3701.data2′ size 1000M autoextend on next 20M maxsize 20000M’ executed successfully
BR1060I Tablespace PSAPSR3701 created successfully with files:
/oracle/SMD/sapdata6/sr3701_1/sr3701.data1 1000M,
/oracle/SMD/sapdata5/sr3701_2/sr3701.data2 1000M

BR0280I BRSPACE time stamp: 2009-07-24 14.23.45
BR0340I Switching to next online redo log file for database instance SMD …
BR0321I Switch to next online redo log file for database instance SMD successful

BR0280I BRSPACE time stamp: 2009-07-24 14.23.47
BR0319I Control file copy created: /oracle/SMD/sapreorg/sebcabqp/cntrlSMD.new 11124736

BR0280I BRSPACE time stamp: 2009-07-24 14.23.47
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRSPACE time stamp: 2009-07-24 14.24.04
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…

BR0280I BRSPACE time stamp: 2009-07-24 14.24.04
BR1020I Number of tablespaces processed: 1
BR1003I BRSPACE function ‘tscreate’ completed

BR1008I End of BRSPACE processing: sebcabqp.tsc 2009-07-24 14.24.04
BR0280I BRSPACE time stamp: 2009-07-24 14.24.04
BR1005I BRSPACE completed successfully

###############################################################################

BR0292I Execution of BRSPACE finished with return code 0
BR0280I BRTOOLS time stamp: 2009-07-24 14.24.04
BR0256I Enter ‘c[ont]’ to continue, ‘s[top]’ to cancel BRTOOLS:
c
BR0280I BRTOOLS time stamp: 2009-07-24 14.24.07
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…

BR0280I BRTOOLS time stamp: 2009-07-24 14.24.07
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:
b
BR0280I BRTOOLS time stamp: 2009-07-24 14.24.11
BR0663I Your choice: ‘b’
BR0673I Going back to the previous menu…

BR0280I BRTOOLS time stamp: 2009-07-24 14.24.11
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:
9
BR0280I BRTOOLS time stamp: 2009-07-24 14.24.13
BR0663I Your choice: ‘9’
BR0280I BRTOOLS time stamp: 2009-07-24 14.24.13
BR0680I Do you really want to exit BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2009-07-24 14.24.15
BR0257I Your reply: ‘y’

BR0280I BRTOOLS time stamp: 2009-07-24 14.24.15
BR0652I BRTOOLS completed successfully

Advertisements

5 Responses

  1. Hey Maxwell thanks a lot for sharing this… I just followed it blindly to create tablespace….
    hope you will continue the same spirit.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: