Database Files layout

Recommendation to store the files of the
database system on different physical disks. In this example, the control file
is mirrored twice:

Disk
Number

Directory

Contents of
Directory

1

origlogA

Online redo log
files from the first and third group (Set A)

2

origlogB

Online redo log
files from the second and fourth group (Set B)

3

mirrlogA

Mirrored online
redo log files from the first and third group (Set A)

4

mirrlogB

Mirrored online
redo log files from the second and fourth group (Set B)

5

sapdata1

Database files,
mirror of the control file

6

sapdata2

Database files,
mirror of the control file

7

sapdata<n>

Other database
files in sapdata3 up to
sapdata<n>, each on separate disks when
possible

For performance reasons, it is recommended to distribute the online redo log groups to four disks

Advertisements

SAP : The OPS$ Mechanism Under UNIX

For the database, the SAP System is a single user, SAPR3 / SAP, whose password is stored in the table SAPUSER.
Therefore, to access the database, the SAP System uses a mechanism called the OPS$ mechanism, which works as follows:

1. When the system accesses the database, it first logs on to the database as the user OPS$, for example, OPS$adm. (The OPS$ user that corresponds to the operating system user must be defined in the database and identified as externally.)

2. It retrieves the password for SAPR3from the SAPUSER table.

3. It then logs on to the database as the user SAPR3.

SAP- Brtools – Tablespace deletion step by step

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

BR0280I BRTOOLS time stamp: 2010-08-25 10.25.31
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-25 10.25.35
BR0663I Your choice: ‘2’

BR0280I BRTOOLS time stamp: 2010-08-25 10.25.35
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:
3
BR0280I BRTOOLS time stamp: 2010-08-25 10.25.39
BR0663I Your choice: ‘3’

BR0280I BRTOOLS time stamp: 2010-08-25 10.25.40
BR0657I Input menu 83 – please check/enter input values
——————————————————————————-
BRSPACE options for drop 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 tsdrop]

Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2010-08-25 10.25.49
BR0663I Your choice: ‘3’

BR0280I BRTOOLS time stamp: 2010-08-25 10.25.49
BR0681I Enter string value for “tablespace” []:
PSAPSR3700
BR0280I BRTOOLS time stamp: 2010-08-25 10.26.08
BR0683I New value for “tablespace”: ‘PSAPSR3700’

BR0280I BRTOOLS time stamp: 2010-08-25 10.26.08
BR0657I Input menu 83 – please check/enter input values
——————————————————————————-
BRSPACE options for drop tablespace

1 – BRSPACE profile (profile) …… [initSMD.sap]
2 – Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) … [PSAPSR3700]
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 tsdrop -t PSAPSR3700]

Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2010-08-25 10.26.20
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 tsdrop -t PSAPSR3700’

BR0280I BRTOOLS time stamp: 2010-08-25 10.26.20
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRTOOLS time stamp: 2010-08-25 10.28.18
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…

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

BR1001I BRSPACE 7.00 (28)
BR1002I Start of BRSPACE processing: sedzavzu.tsd 2010-08-25 10.28.18
BR0484I BRSPACE log file: /oracle/SMD/sapreorg/sedzavzu.tsd

BR0280I BRSPACE time stamp: 2010-08-25 10.28.19
BR1009I Name of database instance: SMD
BR1010I BRSPACE action ID: sedzavzu
BR1011I BRSPACE function ID: tsd
BR1012I BRSPACE function: tsdrop

BR0280I BRSPACE time stamp: 2010-08-25 10.28.20
BR0657I Input menu 310 – please check/enter input values
——————————————————————————-
Options for dropping of tablespace PSAPSR3700

1 * Number of files in tablespace (files) . [7]
2 * Total tablespace size in MB (size) …. [700]
3 – Force tablespace drop (force) ……… [no]
4 – SQL command (command) …………….. [drop tablespace PSAPSR3700]

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

BR0280I BRSPACE time stamp: 2010-08-25 10.28.45
BR1070I Searching for segments in tablespace PSAPSR3700…
BR0285I This function can take several seconds/minutes – be patient…

BR0280I BRSPACE time stamp: 2010-08-25 10.28.45
BR1071I Tablespace PSAPSR3700 is empty

BR0280I BRSPACE time stamp: 2010-08-25 10.28.45
BR0370I Directory /oracle/SMD/sapreorg/sedzavzu created

BR0280I BRSPACE time stamp: 2010-08-25 10.28.46
BR0319I Control file copy created: /oracle/SMD/sapreorg/sedzavzu/cntrlSMD.old 11223040

BR0280I BRSPACE time stamp: 2010-08-25 10.28.48
BR0768I Tablespace PSAPSR3700 set OFFLINE

BR0280I BRSPACE time stamp: 2010-08-25 10.28.48
BR1090I Dropping tablespace PSAPSR3700…

BR0280I BRSPACE time stamp: 2010-08-25 10.28.49
BR1016I SQL statement ‘drop tablespace PSAPSR3700’ executed successfully
BR1069I Tablespace PSAPSR3700 dropped successfully

BR0280I BRSPACE time stamp: 2010-08-25 10.28.49
BR0794I Database file /oracle/SMD/sapdata1/sr3700_1/sr3700.data1 deleted
BR0480I Directory /oracle/SMD/sapdata1/sr3700_1 deleted
BR0794I Database file /oracle/SMD/sapdata2/sr3700_2/sr3700.data2 deleted
BR0480I Directory /oracle/SMD/sapdata2/sr3700_2 deleted
BR0794I Database file /oracle/SMD/sapdata3/sr3700_3/sr3700.data3 deleted
BR0480I Directory /oracle/SMD/sapdata3/sr3700_3 deleted
BR0794I Database file /oracle/SMD/sapdata4/sr3700_4/sr3700.data4 deleted
BR0480I Directory /oracle/SMD/sapdata4/sr3700_4 deleted
BR0794I Database file /oracle/SMD/sapdata4/sr3700_5/sr3700.data5 deleted
BR0480I Directory /oracle/SMD/sapdata4/sr3700_5 deleted
BR0794I Database file /oracle/SMD/sapdata6/sr3700_6/sr3700.data6 deleted
BR0480I Directory /oracle/SMD/sapdata6/sr3700_6 deleted
BR0794I Database file /oracle/SMD/sapdata6/sr3700_7/sr3700.data7 deleted
BR0480I Directory /oracle/SMD/sapdata6/sr3700_7 deleted

BR0280I BRSPACE time stamp: 2010-08-25 10.28.49
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: 2010-08-25 10.28.53
BR0319I Control file copy created: /oracle/SMD/sapreorg/sedzavzu/cntrlSMD.new 11223040

BR0280I BRSPACE time stamp: 2010-08-25 10.28.53
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRSPACE time stamp: 2010-08-25 10.29.00
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…

BR0280I BRSPACE time stamp: 2010-08-25 10.29.00
BR1020I Number of tablespaces processed: 1
BR1003I BRSPACE function ‘tsdrop’ completed

BR1008I End of BRSPACE processing: sedzavzu.tsd 2010-08-25 10.29.00
BR0280I BRSPACE time stamp: 2010-08-25 10.29.00
BR1005I BRSPACE completed successfully

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

BR0292I Execution of BRSPACE finished with return code 0
BR0280I BRTOOLS time stamp: 2010-08-25 10.29.00
BR0256I Enter ‘c[ont]’ to continue, ‘s[top]’ to cancel BRTOOLS:
c
BR0280I BRTOOLS time stamp: 2010-08-25 10.29.07
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…

BR0280I BRTOOLS time stamp: 2010-08-25 10.29.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: 2010-08-25 10.29.11
BR0663I Your choice: ‘b’
BR0673I Going back to the previous menu…

BR0280I BRTOOLS time stamp: 2010-08-25 10.29.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: 2010-08-25 10.29.13
BR0663I Your choice: ‘9’
BR0280I BRTOOLS time stamp: 2010-08-25 10.29.13
BR0680I Do you really want to exit BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2010-08-25 10.29.15
BR0257I Your reply: ‘y’

BR0280I BRTOOLS time stamp: 2010-08-25 10.29.15
BR0652I BRTOOLS completed successfully
smdev:SMD:/home/orasmd>

SAP Transation Codes

Following are some of the SAP transaction codes that can be used to view the database details in SAP GUI.
DataBase SAP Transaction Codes

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