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
ConversionConversion EmoticonEmoticon