Create Oracle Tablespace on SAP with BRTools

Pada kesempatan kali ini saya akan berbagi ilmu tentang Oracle, dimana kita akan membuat tablespace oracle di SAP dengan menggunakan BRTools, sebagai catatan SAP sangat merekomendasikan untuk menggunakan BRTools saat kita akan melakukan maintence pada Database Oracle.


sapdrp:orat01 1> brtools
BR0651I BRTOOLS 7.00 (24)

BR0280I BRTOOLS time stamp: 2010-08-23 09.16.25
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: 2010-08-23 09.16.32
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2010-08-23 09.16.32
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: 2010-08-23 09.16.34
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2010-08-23 09.16.34
BR0657I Input menu 82 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for create tablespace

1 - BRSPACE profile (profile) ...... [initT01.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 initT01.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: 2010-08-23 09.16.39
BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2010-08-23 09.16.39
BR0681I Enter string value for "tablespace" []:
PSAPGG1
BR0280I BRTOOLS time stamp: 2010-08-23 09.17.05
BR0683I New value for "tablespace": 'PSAPGG1'

BR0280I BRTOOLS time stamp: 2010-08-23 09.17.05
BR0657I Input menu 82 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for create tablespace

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

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2010-08-23 09.17.29
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initT01.sap -s 20 -l E -f tscreate -t PSAPGG1'

BR0280I BRTOOLS time stamp: 2010-08-23 09.17.29
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2010-08-23 09.17.33
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

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

BR1001I BRSPACE 7.00 (24)
BR1002I Start of BRSPACE processing: sedyonnh.tsc 2010-08-23 09.17.33
BR0484I BRSPACE log file: /oracle/T01/sapreorg/sedyonnh.tsc

BR0280I BRSPACE time stamp: 2010-08-23 09.17.34
BR1009I Name of database instance: T01
BR1010I BRSPACE action ID: sedyonnh
BR1011I BRSPACE function ID: tsc
BR1012I BRSPACE function: tscreate

BR0280I BRSPACE time stamp: 2010-08-23 09.17.35
BR0657I Input menu 305 - please check/enter input values
-------------------------------------------------------------------------------
Main options for creation of tablespace in database T01

1 - Tablespace name (tablespace) ......... [PSAPGG1]
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:
4
BR0280I BRSPACE time stamp: 2010-08-23 09.23.06
BR0663I Your choice: '4'

BR0280I BRSPACE time stamp: 2010-08-23 09.23.06
BR0681I Enter string value for "owner" []:
SAPSR3
BR0280I BRSPACE time stamp: 2010-08-23 09.23.12
BR0683I New value for "owner": 'SAPSR3'

BR0280I BRSPACE time stamp: 2010-08-23 09.23.12
BR0657I Input menu 305 - please check/enter input values
-------------------------------------------------------------------------------
Main options for creation of tablespace in database T01

1 - Tablespace name (tablespace) ......... [PSAPGG1]
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) ......... []

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2010-08-23 09.23.20
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1061W Tablespace name 'PSAPGG1' should have at least 7 characters and begin with 'PSAPSR3'
BR0691W Warning by checking input value for 'tablespace'

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRSPACE time stamp: 2010-08-23 09.23.20
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRSPACE time stamp: 2010-08-23 09.25.54
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
y
BR0280I BRSPACE time stamp: 2010-08-23 09.25.55
BR0257I Your reply: 'y'
BR0260E BRSPACE cancelled by user

BR1008I End of BRSPACE processing: sedyonnh.tsc 2010-08-23 09.25.55
BR0280I BRSPACE time stamp: 2010-08-23 09.25.55
BR1007I BRSPACE terminated with errors

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

BR0292I Execution of BRSPACE finished with return code 2

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRTOOLS time stamp: 2010-08-23 09.25.56
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRTOOLS time stamp: 2010-08-23 09.26.08
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2010-08-23 09.26.10
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2010-08-23 09.26.10
BR0654I BRTOOLS terminated with errors
sapdrp:orat01 2>



-------------------------

SAPGG1
BR0280I BRSPACE time stamp: 2010-08-23 10.27.27
BR0683I New value for "owner": 'SAPGG1'

BR0280I BRSPACE time stamp: 2010-08-23 10.27.27
BR0657I Input menu 305 - please check/enter input values
-------------------------------------------------------------------------------
Main options for creation of tablespace in database T01

1 - Tablespace name (tablespace) ......... [PSAPGG1]
2 - Tablespace contents (contents) ....... [data]
3 - Segment space management (space) ..... [auto]
4 - Database owner of tablespace (owner) . [SAPGG1]
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:
c
BR0280I BRSPACE time stamp: 2010-08-23 10.27.33
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2010-08-23 10.27.33
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPGG1 (1. file)

1 - Tablespace file name (file) .......... [/oracle/T01/sapdata4/gg1_1/gg1.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 PSAPGG1 extent management local autoallocate segment space management auto datafile '/oracle/T01/sapdata4/gg1_1/gg1.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:
c
BR0280I BRSPACE time stamp: 2010-08-23 10.29.34
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_1 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 420575.048 MB
BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_1 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 292575.048 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRSPACE time stamp: 2010-08-23 10.29.34
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
b
BR0280I BRSPACE time stamp: 2010-08-23 10.30.46
BR0257I Your reply: 'b'
BR0673I Going back to the previous menu...

BR0280I BRSPACE time stamp: 2010-08-23 10.30.46
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPGG1 (1. file)

1 - Tablespace file name (file) .......... [/oracle/T01/sapdata4/gg1_1/gg1.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 PSAPGG1 extent management local autoallocate segment space management auto datafile '/oracle/T01/sapdata4/gg1_1/gg1.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:
3
BR0280I BRSPACE time stamp: 2010-08-23 10.31.13
BR0663I Your choice: '3'

BR0280I BRSPACE time stamp: 2010-08-23 10.31.13
BR0682I Enter integer value for "size" (1-32767) [1000]:
100
BR0280I BRSPACE time stamp: 2010-08-23 10.31.19
BR0683I New value for "size": '100'

BR0280I BRSPACE time stamp: 2010-08-23 10.31.19
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPGG1 (1. file)

1 - Tablespace file name (file) .......... [/oracle/T01/sapdata4/gg1_1/gg1.data1]
2 ~ Raw disk / link target (rawlink) ..... []
3 - File size in MB (size) ............... [100]
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 PSAPGG1 extent management local autoallocate segment space management auto datafile '/oracle/T01/sapdata4/gg1_1/gg1.data1' size 100M autoextend on next 20M maxsize 10000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2010-08-23 10.31.26
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_1 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 419675.051 MB
BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_1 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 291675.051 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRSPACE time stamp: 2010-08-23 10.31.26
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
b
BR0280I BRSPACE time stamp: 2010-08-23 10.32.45
BR0257I Your reply: 'b'
BR0673I Going back to the previous menu...

BR0280I BRSPACE time stamp: 2010-08-23 10.32.45
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPGG1 (1. file)

1 - Tablespace file name (file) .......... [/oracle/T01/sapdata4/gg1_1/gg1.data1]
2 ~ Raw disk / link target (rawlink) ..... []
3 - File size in MB (size) ............... [100]
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 PSAPGG1 extent management local autoallocate segment space management auto datafile '/oracle/T01/sapdata4/gg1_1/gg1.data1' size 100M 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: 2010-08-23 10.32.49
BR0663I Your choice: '3'

BR0280I BRSPACE time stamp: 2010-08-23 10.32.49
BR0682I Enter integer value for "size" (1-32767) [100]:
10
BR0280I BRSPACE time stamp: 2010-08-23 10.32.52
BR0683I New value for "size": '10'

BR0280I BRSPACE time stamp: 2010-08-23 10.32.52
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPGG1 (1. file)

1 - Tablespace file name (file) .......... [/oracle/T01/sapdata4/gg1_1/gg1.data1]
2 ~ Raw disk / link target (rawlink) ..... []
3 - File size in MB (size) ............... [10]
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 PSAPGG1 extent management local autoallocate segment space management auto datafile '/oracle/T01/sapdata4/gg1_1/gg1.data1' size 10M autoextend on next 20M maxsize 10000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2010-08-23 10.32.54
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_1 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 419585.028 MB
BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_1 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 291585.028 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRSPACE time stamp: 2010-08-23 10.32.54
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
b
BR0280I BRSPACE time stamp: 2010-08-23 10.33.22
BR0257I Your reply: 'b'
BR0673I Going back to the previous menu...

BR0280I BRSPACE time stamp: 2010-08-23 10.33.22
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPGG1 (1. file)

1 - Tablespace file name (file) .......... [/oracle/T01/sapdata4/gg1_1/gg1.data1]
2 ~ Raw disk / link target (rawlink) ..... []
3 - File size in MB (size) ............... [10]
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 PSAPGG1 extent management local autoallocate segment space management auto datafile '/oracle/T01/sapdata4/gg1_1/gg1.data1' size 10M autoextend on next 20M maxsize 10000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:

===================================================


BR1011I BRSPACE function ID: tsc
BR1012I BRSPACE function: tscreate

BR0280I BRSPACE time stamp: 2010-08-23 14.03.31
BR0657I Input menu 305 - please check/enter input values
-------------------------------------------------------------------------------
Main options for creation of tablespace in database T01

1 - Tablespace name (tablespace) ......... [PSAPGG1]
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:
4
BR0280I BRSPACE time stamp: 2010-08-23 14.03.38
BR0663I Your choice: '4'

BR0280I BRSPACE time stamp: 2010-08-23 14.03.38
BR0681I Enter string value for "owner" []:
SAPGG1
BR0280I BRSPACE time stamp: 2010-08-23 14.03.46
BR0683I New value for "owner": 'SAPGG1'

BR0280I BRSPACE time stamp: 2010-08-23 14.03.46
BR0657I Input menu 305 - please check/enter input values
-------------------------------------------------------------------------------
Main options for creation of tablespace in database T01

1 - Tablespace name (tablespace) ......... [PSAPGG1]
2 - Tablespace contents (contents) ....... [data]
3 - Segment space management (space) ..... [auto]
4 - Database owner of tablespace (owner) . [SAPGG1]
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:
c
BR0280I BRSPACE time stamp: 2010-08-23 14.03.51
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2010-08-23 14.03.51
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPGG1 (1. file)

1 - Tablespace file name (file) .......... [/oracle/T01/sapdata4/gg1_1/gg1.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 PSAPGG1 extent management local autoallocate segment space management auto datafile '/oracle/T01/sapdata4/gg1_1/gg1.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: 2010-08-23 14.04.24
BR0663I Your choice: '5'

BR0280I BRSPACE time stamp: 2010-08-23 14.04.24
BR0682I Enter integer value for "maxsize" (0-32767) [10000]:
1500
BR0280I BRSPACE time stamp: 2010-08-23 14.04.33
BR0683I New value for "maxsize": '1500'

BR0280I BRSPACE time stamp: 2010-08-23 14.04.33
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPGG1 (1. file)

1 - Tablespace file name (file) .......... [/oracle/T01/sapdata4/gg1_1/gg1.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) .... [1500]
6 - File increment size in MB (incrsize) . [20]
7 - SQL command (command) ................ [create tablespace PSAPGG1 extent management local autoallocate segment space management auto datafile '/oracle/T01/sapdata4/gg1_1/gg1.data1' size 1000M autoextend on next 20M maxsize 1500M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2010-08-23 14.04.41
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_1 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 420619.157 MB
BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_1 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 292619.157 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRSPACE time stamp: 2010-08-23 14.04.41
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2010-08-23 14.19.22
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2010-08-23 14.19.22
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: 2010-08-23 14.21.40
BR0257I Your reply: 'y'
BR0677I The action will be performed...

BR0280I BRSPACE time stamp: 2010-08-23 14.21.40
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPGG1 (2. file)

1 - Tablespace file name (file) .......... [/oracle/T01/sapdata4/gg1_2/gg1.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) .... [1500]
6 - File increment size in MB (incrsize) . [20]
7 - SQL command (command) ................ [create tablespace PSAPGG1 extent management local autoallocate segment space management auto datafile '/oracle/T01/sapdata4/gg1_1/gg1.data1' size 1000M autoextend on next 20M maxsize 1500M, '/oracle/T01/sapdata4/gg1_2/gg1.data2' size 1000M autoextend on next 20M maxsize 1500M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2010-08-23 14.22.49
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_2 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 421619.250 MB
BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_2 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 293619.250 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRSPACE time stamp: 2010-08-23 14.22.49
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2010-08-23 14.23.17
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2010-08-23 14.23.17
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: 2010-08-23 14.23.50
BR0257I Your reply: 'y'
BR0677I The action will be performed...

BR0280I BRSPACE time stamp: 2010-08-23 14.23.50
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPGG1 (3. file)

1 - Tablespace file name (file) .......... [/oracle/T01/sapdata4/gg1_3/gg1.data3]
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) .... [1500]
6 - File increment size in MB (incrsize) . [20]
7 - SQL command (command) ................ [create tablespace PSAPGG1 extent management local autoallocate segment space management auto datafile '/oracle/T01/sapdata4/gg1_1/gg1.data1' size 1000M autoextend on next 20M maxsize 1500M, '/oracle/T01/sapdata4/gg1_2/gg1.data2' size 1000M autoextend on next 20M maxsize 1500M, '/oracle/T01/sapdata4/gg1_3/gg1.data3' size 1000M autoextend on next 20M maxsize 1500M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2010-08-23 14.24.57
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_3 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 422619.239 MB
BR1049W Not enough free space in /oracle/T01/sapdata4/gg1_3 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 294619.239 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRSPACE time stamp: 2010-08-23 14.24.57
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2010-08-23 14.25.08
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2010-08-23 14.25.08
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: 2010-08-23 14.25.12
BR0257I Your reply: 'c'
BR0678I The action will be skipped...
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2010-08-23 14.25.12
BR0370I Directory /oracle/T01/sapreorg/sedypmxe created

BR0280I BRSPACE time stamp: 2010-08-23 14.25.12
BR0319I Control file copy created: /oracle/T01/sapreorg/sedypmxe/cntrlT01.old 10567680

BR0280I BRSPACE time stamp: 2010-08-23 14.25.12
BR0370I Directory /oracle/T01/sapdata4/gg1_2 created
BR0370I Directory /oracle/T01/sapdata4/gg1_3 created

BR0280I BRSPACE time stamp: 2010-08-23 14.25.12
BR1089I Creating tablespace PSAPGG1...

BR0280I BRSPACE time stamp: 2010-08-23 14.25.39
BR1016I SQL statement 'create tablespace PSAPGG1 extent management local autoallocate segment space management auto datafile '/oracle/T01/sapdata4/gg1_1/gg1.data1' size 1000M autoextend on next 20M maxsize 1500M, '/oracle/T01/sapdata4/gg1_2/gg1.data2' size 1000M autoextend on next 20M maxsize 1500M, '/oracle/T01/sapdata4/gg1_3/gg1.data3' size 1000M autoextend on next 20M maxsize 1500M' executed successfully
BR1060I Tablespace PSAPGG1 created successfully with files:
/oracle/T01/sapdata4/gg1_1/gg1.data1 1000M,
/oracle/T01/sapdata4/gg1_2/gg1.data2 1000M,
/oracle/T01/sapdata4/gg1_3/gg1.data3 1000M

BR0280I BRSPACE time stamp: 2010-08-23 14.25.39
BR0340I Switching to next online redo log file for database instance T01 ...
BR0321I Switch to next online redo log file for database instance T01 successful

BR0280I BRSPACE time stamp: 2010-08-23 14.25.43
BR0319I Control file copy created: /oracle/T01/sapreorg/sedypmxe/cntrlT01.new 10567680

BR0280I BRSPACE time stamp: 2010-08-23 14.25.43
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort: