Steps to add datafile with brtools (SAP)

Hello Friend's,

In This post we will discuss how to add datafile with use of brtools.

To invike the tool us the below command , There will be manny options, we have to add datafile so we will choose 2 - space management

And follow the steps as given below


SQL> !brtools
BR0651I BRTOOLS 7.40 (38)

BR0280I BRTOOLS time stamp: 2020-07-27 13:22:18
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
-------------------------------------------------------------------------------
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2020-07-27 13:22:21
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2020-07-27 13:22:21
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
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2020-07-27 13:22:23
BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2020-07-27 13:22:23
BR0657I Input menu 81 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension

 1 - BRSPACE profile (profile) .......... [initXA1.sap]
 2 - Database user/password (user) ...... [/]
 3 ~ Tablespace name (tablespace) ....... []
 4 # Effective pluggable database (pdb) . []
 5 - Confirmation mode (confirm) ........ [yes]
 6 - Scrolling line count (scroll) ...... [20]
 7 - Message language (language) ........ [E]
 8 - BRSPACE command line (command) ..... [-p initXA1.sap -s 20 -l E -f tsextend]

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2020-07-27 13:22:27
BR0663I Your choice: '3'
BR0681I Enter string value for "tablespace" []:
USER1
BR0280I BRTOOLS time stamp: 2020-07-27 13:22:31
BR0683I New value for "tablespace": 'USER1'

BR0280I BRTOOLS time stamp: 2020-07-27 13:22:31
BR0657I Input menu 81 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension

 1 - BRSPACE profile (profile) .......... [initXA1.sap]
 2 - Database user/password (user) ...... [/]
 3 ~ Tablespace name (tablespace) ....... [USER1]
 4 # Effective pluggable database (pdb) . []
 5 - Confirmation mode (confirm) ........ [yes]
 6 - Scrolling line count (scroll) ...... [20]
 7 - Message language (language) ........ [E]
 8 - BRSPACE command line (command) ..... [-p initXA1.sap -s 20 -l E -f tsextend -t USER1]

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2020-07-27 13:22:39
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initXA1.sap -s 20 -l E -u / -f tsextend -t USER1'

BR0280I BRTOOLS time stamp: 2020-07-27 13:22:39
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2020-07-27 13:22:42
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

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

BR1001I BRSPACE 7.40 (38)
BR1002I Start of BRSPACE processing: sfeievzu.tse 2020-07-27 13:22:42
BR0484I BRSPACE log file: /oracle/XA1/sapreorg/sfeievzu.tse

BR0280I BRSPACE time stamp: 2020-07-27 13:22:43
BR1009I Name of database instance: XA1
BR1010I BRSPACE action ID: sfeievzu
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend

BR0280I BRSPACE time stamp: 2020-07-27 13:22:45
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace USER1 (1. file)

 1 * Last added file name (lastfile) ....... [/oracle/XA1/sapdata1/sr3_250/sr3.data259]
 2 * Last added file size in MB (lastsize) . [30720]
 3 - New file to be added (file) ........... [/oracle/XA1/sapdata1/sr3_251/sr3.data260]
 4 # Raw disk / link target (rawlink) ...... []
 5 - Size of the new file in MB (size) ..... [30720]
 6 - File autoextend mode (autoextend) ..... [yes]
 7 - Maximum file size in MB (maxsize) ..... [32767]
 8 - File increment size in MB (incrsize) .. [100]
 9 - SQL command (command) ................. [alter tablespace USER1 add datafile '/oracle/XA1/sapdata1/sr3_251/sr3.data260' size 30720M autoextend on next 100M maxsize 32767M]

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2020-07-27 13:22:57
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1091I Next data file can be specified now

BR0280I BRSPACE time stamp: 2020-07-27 13:22:57
BR0675I This is an 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: 2020-07-27 13:22:58
BR0257I Your reply: 'c'
BR0678I The action will be skipped...
BR0259I Program execution will be continued...

BR0370I Directory /oracle/XA1/sapreorg/sfeievzu created

BR0280I BRSPACE time stamp: 2020-07-27 13:23:00
BR0319I Control file copy created: /oracle/XA1/sapreorg/sfeievzu/cntrlXA1.old 81903616

BR0370I Directory /oracle/XA1/sapdata1/sr3_251 created

BR0280I BRSPACE time stamp: 2020-07-27 13:23:00
BR1088I Extending tablespace USER1 ...

BR0280I BRSPACE time stamp: 2020-07-27 13:26:05
BR1016I SQL statement 'alter tablespace USER1 add datafile '/oracle/XA1/sapdata1/sr3_251/sr3.data260' size 30720M autoextend on next 100M maxsize 32767M' executed successfully

BR1051I Tablespace USER1 extended successfully with file(s): /oracle/XA1/sapdata1/sr3_251/sr3.data260 30720M

BR0280I BRSPACE time stamp: 2020-07-27 13:26:05
BR0340I Switching to the next online redolog file for database instance XA1 ...
BR0321I Switch to the next online redolog file for database instance XA1 successful

BR0280I BRSPACE time stamp: 2020-07-27 13:26:09
BR0319I Control file copy created: /oracle/XA1/sapreorg/sfeievzu/cntrlXA1.new 81903616

BR0280I BRSPACE time stamp: 2020-07-27 13:26:09
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2020-07-27 13:28:05
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2020-07-27 13:28:05
BR1020I Number of tablespaces processed: 1
BR1003I BRSPACE function 'tsextend' completed

BR1008I End of BRSPACE processing: sfeievzu.tse 2020-07-27 13:28:05
BR0280I BRSPACE time stamp: 2020-07-27 13:28:06
BR1005I BRSPACE completed successfully

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

BR0292I Execution of BRSPACE finished with return code 0

BR0280I BRTOOLS time stamp: 2020-07-27 13:28:06
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRTOOLS:
s
BR0280I BRTOOLS time stamp: 2020-07-27 13:28:09
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2020-07-27 13:28:11
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2020-07-27 13:28:11
BR0654I BRTOOLS terminated with errors
Previous
Next Post »