Database Technology: How to create new UNDO tablespace in oracle SAP database using brtools?

Linux_server>:oraORA_DB 27>brtools

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

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:

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.19

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.19

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:

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.21

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.21

BR0657I Input menu 82 - please enter/check input values

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

BRSPACE options for create tablespace

1 - BRSPACE profile (profile) ...... [initORA_DB.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 initORA_DB.sap -s 20 -l E -f tscreate]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.28

BR0663I Your choice: '3'

BR0681I Enter string value for "tablespace" []:

PSAPUNDO

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.38

BR0683I New value for "tablespace": 'PSAPUNDO'

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.38

BR0657I Input menu 82 - please enter/check input values

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

BRSPACE options for create tablespace

1 - BRSPACE profile (profile) ...... [initORA_DB.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... [PSAPUNDO]

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initORA_DB.sap -s 20 -l E -f tscreate -t PSAPUNDO]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.46

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

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

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.46

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.50

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR1001I BRSPACE 7.20 (42)

BR1002I Start of BRSPACE processing: sfgzuwru.tsc 2021-07-30 10.19.50

BR0484I BRSPACE log file: /oracle/ORA_DB/sapreorg/sfgzuwru.tsc

BR0280I BRSPACE time stamp: 2021-07-30 10.19.56

BR1009I Name of database instance: ORA_DB

BR1010I BRSPACE action ID: sfgzuwru

BR1011I BRSPACE function ID: tsc

BR1012I BRSPACE function: tscreate

BR0280I BRSPACE time stamp: 2021-07-30 10.20.02

BR0657I Input menu 305 - please enter/check input values

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

Main options for creation of tablespace in database ORA_DB

1 - Tablespace name (tablespace) ......... [PSAPUNDO]

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) ......... []

9 - Bigfile tablespace (bigfile) ......... [no]

10 - Tablespace compression (compress) .... [no]

11 - Tablespace encryption (encryption) ... [no]

12 # Encryption algorithm (algorithm) ..... []

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2021-07-30 10.20.17

BR0663I Your choice: '2'

BR0681I Enter string value for "contents" (data|temp|undo) [data]:

undo

BR0280I BRSPACE time stamp: 2021-07-30 10.20.36

BR0683I New value for "contents": 'undo'

BR0280I BRSPACE time stamp: 2021-07-30 10.20.36

BR0657I Input menu 305 - please enter/check input values

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

Main options for creation of tablespace in database ORA_DB

1 - Tablespace name (tablespace) ......... [PSAPUNDO]

2 - Tablespace contents (contents) ....... [undo]

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) ......... []

9 - Bigfile tablespace (bigfile) ......... [no]

10 # Tablespace compression (compress) .... [no]

11 # Tablespace encryption (encryption) ... [no]

12 # Encryption algorithm (algorithm) ..... []

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2021-07-30 10.20.54

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2021-07-30 10.20.54

BR0657I Input menu 306 - please enter/check input values

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

Space options for creation of tablespace PSAPUNDO (1. file)

1 - Tablespace file name (file) .......... [/oracle/ORA_DB/sapdata888/undo_1/undo.data1]

2 ~ Raw disk / link target (rawlink) ..... []

3 - File size in MB (size) ............... [11000]

4 # File autoextend mode (autoextend) .... [no]

5 # Maximum file size in MB (maxsize) .... []

6 # File increment size in MB (incrsize) . []

7 - SQL command (command) ................ [create undo tablespace PSAPUNDO datafile '/oracle/ORA_DB/sapdata888/undo_1/undo.data1' size 11000M autoextend off]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2021-07-30 10.22.58

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1091I Next data file can be specified now

BR0280I BRSPACE time stamp: 2021-07-30 10.22.58

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:

BR0280I BRSPACE time stamp: 2021-07-30 10.23.04

BR0257I Your reply: 'y'

BR0677I The action will be executed...

BR0280I BRSPACE time stamp: 2021-07-30 10.23.04

BR0657I Input menu 306 - please enter/check input values

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

Space options for creation of tablespace PSAPUNDO (2. file)

1 - Tablespace file name (file) .......... [/oracle/ORA_DB/sapdata888/undo_2/undo.data2]

2 ~ Raw disk / link target (rawlink) ..... []

3 - File size in MB (size) ............... [11000]

4 # File autoextend mode (autoextend) .... [no]

5 # Maximum file size in MB (maxsize) .... []

6 # File increment size in MB (incrsize) . []

7 - SQL command (command) ................ [create undo tablespace PSAPUNDO datafile '/oracle/ORA_DB/sapdata888/undo_1/undo.data1' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_2/undo.data2' size 11000M autoextend off]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2021-07-30 10.23.27

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1091I Next data file can be specified now

BR0280I BRSPACE time stamp: 2021-07-30 10.23.27

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:

BR0280I BRSPACE time stamp: 2021-07-30 10.23.31

BR0257I Your reply: 'y'

BR0677I The action will be executed...

BR0280I BRSPACE time stamp: 2021-07-30 10.23.31

BR0657I Input menu 306 - please enter/check input values

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

Space options for creation of tablespace PSAPUNDO (3. file)

1 - Tablespace file name (file) .......... [/oracle/ORA_DB/sapdata888/undo_3/undo.data3]

2 ~ Raw disk / link target (rawlink) ..... []

3 - File size in MB (size) ............... [11000]

4 # File autoextend mode (autoextend) .... [no]

5 # Maximum file size in MB (maxsize) .... []

6 # File increment size in MB (incrsize) . []

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2021-07-30 10.24.07

BR0664W Invalid choice: 'n'

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2021-07-30 10.24.46

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1091I Next data file can be specified now

BR0280I BRSPACE time stamp: 2021-07-30 10.24.46

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:

BR0280I BRSPACE time stamp: 2021-07-30 10.24.50

BR0257I Your reply: 'n'

BR0678I The action will be skipped...

BR0370I Directory /oracle/ORA_DB/sapreorg/sfgzuwru created

BR0280I BRSPACE time stamp: 2021-07-30 10.24.54

BR0319I Control file copy created: /oracle/ORA_DB/sapreorg/sfgzuwru/cntrlORA_DB.old 133906432

BR0370I Directory /oracle/ORA_DB/sapdata888/undo_1 created

BR0370I Directory /oracle/ORA_DB/sapdata888/undo_2 created

BR0370I Directory /oracle/ORA_DB/sapdata888/undo_3 created

BR0280I BRSPACE time stamp: 2021-07-30 10.24.54

BR1089I Creating tablespace PSAPUNDO ...

BR0280I BRSPACE time stamp: 2021-07-30 10.28.07

BR1016I SQL statement 'create undo tablespace PSAPUNDO datafile '/oracle/ORA_DB/sapdata888/undo_1/undo.data1' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_2/undo.data2' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_3/undo.data3' size 11000M autoextend off' executed successfully

BR1060I Tablespace PSAPUNDO created successfully with files:

/oracle/ORA_DB/sapdata888/undo_1/undo.data1 11000M,

/oracle/ORA_DB/sapdata888/undo_2/undo.data2 11000M,

/oracle/ORA_DB/sapdata888/undo_3/undo.data3 11000M

BR0280I BRSPACE time stamp: 2021-07-30 10.28.07

BR0340I Switching to the next online redolog file for database instance ORA_DB ...

BR0321I Switch to the next online redolog file for database instance ORA_DB successful

BR0280I BRSPACE time stamp: 2021-07-30 10.28.12

BR0319I Control file copy created: /oracle/ORA_DB/sapreorg/sfgzuwru/cntrlORA_DB.new 133906432

BR0280I BRSPACE time stamp: 2021-07-30 10.28.12

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I BRSPACE time stamp: 2021-07-30 10.28.26

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:

BR0280I BRSPACE time stamp: 2021-07-30 10.28.32

BR0257I Your reply: 'y'

BR0260E BRSPACE cancelled by user

BR1008I End of BRSPACE processing: sfgzuwru.tsc 2021-07-30 10.28.32

BR0280I BRSPACE time stamp: 2021-07-30 10.28.32

BR1007I BRSPACE terminated with errors

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

BR0292I Execution of BRSPACE finished with return code 4

BR0280I BRTOOLS time stamp: 2021-07-30 10.28.32

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:

BR0280I BRTOOLS time stamp: 2021-07-30 10.28.35

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:

BR0280I BRTOOLS time stamp: 2021-07-30 10.28.38

BR0257I Your reply: 'y'

BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2021-07-30 10.28.38

BR0654I BRTOOLS terminated with errors

Linux_server>:oraORA_DB 30>

Database Technology

Sunday, August 8, 2021

How to create new UNDO tablespace in oracle SAP database using brtools?

No comments:

Post a Comment